Enter this formula on sheet 2

=IF(Sheet1!A1<0,"Included",Sheet1!A1)

In this code, Cell A1 on Sheet 1 contains the price. The formula returns
the value "Included" if Sheet1!A1 is less than zero, otherwise it returns
the value of Sheet1!A1.


"Bob" wrote in message
...
I'm trying to build a proposal template that will pull prices from the
product spreadsheet (sheet 1). The formula I need is when the price for a
component is less than zero it would use the word "Included" in the
proposal
template. The prices are in sheet 1. The proposal template would be
located
in sheet 2.