If the cell evaluates to "" and then shows blank, but, another cell
references the blank cell that second cell returns a #VALUE. Its OK if
the cell evaluates to a number but not "". Is there a way around this?
Thanks
Max wrote:
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?