Hi


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

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

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets

Function making cell really "empty"
 

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

Arvi Laanemets wrote...
....
To bypass your problem, use the formula
C1=IF(A1="",0,A1)*B1

Simpler to use

=N(A1)*B1