Thread: IF statement
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default IF statement

No. If you put a formula in a cell, the formula will replace the previous
contents.

You can, of course, write the IF statement to include the previous contents
(whether formula or value), for example:
=IF(condition,new value,previous contents)
--
David Biddulph

"DP7" wrote in message
...
Hi I would like to know if it is possible to run an IF statement and if
the
condition is FALSE. It will leave the value that was previously in the
cell?
Thanks in advance