Change Cell Content
 

Excel 2007
I would like to create a formula that changes the content of a cell;
If C10 = House than A36 should read Add $10.00/Sq', if C10 = Net than A36
should read Add $10.50/Sq'

Change Cell Content
 

In A36, enter:

=IF(C10="House","Add $10.00/Sq","Add $10.50/Sq")
--
Gary''s Student - gsnu200839


"George" wrote:

Excel 2007
I would like to create a formula that changes the content of a cell;
If C10 = House than A36 should read Add $10.00/Sq', if C10 = Net than A36
should read Add $10.50/Sq'

Change Cell Content
 

Put this in A36...

=IF(C10="House","Add $10.00/Sq'",IF(C10="Net","Add $10.50/Sq'",""))

Note that the above formula leaves A36 "blank" if C10 has something else in
it besides "House" or "Net" (that is what the "" at the end does).

--
Rick (MVP - Excel)


"George" wrote in message
...
Excel 2007
I would like to create a formula that changes the content of a cell;
If C10 = House than A36 should read Add $10.00/Sq', if C10 = Net than A36
should read Add $10.50/Sq'