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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing the values of multiple cells in conditinal formatting. 0
Help with IF Function for times. 5
VBA for Dependents shortcut menu 0
can a cell be both input and output? 3
Show value from one cell in another cell if today falls between a date range 5
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1
If Not blank - Formula for two cells 0

Top