Function making cell really "empty"

A

Arvi Laanemets

Hi


Marko Pinteric said:
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?
Click to expand...

Deleting the cell entry (select cell and hit Del, or use some VBA equivalent
of it)

To bypass your problem, use the formula
C1=IF(A1="",0,A1)*B1
 
M

Marko Pinteric

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
 
Top