Post the formula that returns the value error, a value error occurs when you
calculate with text like "" so you can replace it with 0 instead if you add
it or you can use functions that ignores text like SUM or SUMIF

--
Regards,

Peo Sjoblom

(No private emails please)


"noyb" wrote in message
...
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?