View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default keep cell blank if IF statement is False

Put: "" as the value_if_false in the IF
Example: =IF(expression, value_if_true , "")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"ruthslaughter" wrote in message
...
I'm trying to keep a cell blank for the False component of an IF

statement.
If I leave it blank it comes back with False in the cell. I don't want
anything in the False section of the IF statement. How do I do that?