View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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'