b;ank cells in calculations
 

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

A1: IF(E1F1;E1-F1;"") and
B1: IF(F1E1;F1-E1;"")
and:
A2: IF(E2F2;E2-F2;"")and
B2: IF(F2E2;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)
--
geotso
---- ---- --- -- -- - -
Please, remove hyphens to contact me
---- ---- --- -- -- - -

b;ank cells in calculations
 

try this

=sum(A1,A2)


On Jan 31, 5:40*pm, "geotso" wrote:
I use the IF function, in order to get some blank cells like:

A1: IF(E1F1;E1-F1;"") and
B1: IF(F1E1;F1-E1;"")
and:
A2: IF(E2F2;E2-F2;"")and
B2: IF(F2E2;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)
--
geotso
---- * *---- * *--- * *-- * -- * - * *-
Please, remove hyphens to contact me
---- * *---- * *--- * *-- * -- * - * *-

b;ank cells in calculations
 

"muddan madhu" wrote in message
...
try this

=sum(A1,A2)

Thanks!