I have a cell with formula

A1 = IF(condition,value,"")

Since condition is not fulfilled, the cell "seems" to be empty.

However another cell refers to this cell

C1 = A1 * B1

and formula returns error #VALUE!

If cell A1 would be REALLY empty, function in C1 would return simply 0.
How to make cell A1 look REALLY empty to formula in C1?

Regards, Marko