b;ank cells in calculations


G

geotso

I use the IF function, in order to get some blank cells like:

A1: IF(E1>F1;E1-F1;"") and
B1: IF(F1>E1;F1-E1;"")
and:
A2: IF(E2>F2;E2-F2;"")and
B2: IF(F2>E2;F2-E2;"")

However, that empty string doesn't allow me to use any of the blank cells in
a new calculation, giving me a #VALUE! error. For example:

A3: =A1+A2 or
B3: =B1+B2

Is there a workaround? (please note that I want those cells totally blank
and not with a zero value)
 
Ad

Advertisements

Ad

Advertisements


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

Top