Change Cell Content

G

George

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'
 
R

Rick Rothstein

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).
 
Top