From: Ayo on

Why am I getting a #Value error with this formula:
IF(OR(H22>0,F22>0),F22+H22,0)

where F22=1 and H22=blank
From: ker_01 on
My guess would be that H22 isn't really blank- it has a space or some other
character in it. Or, the "1" is stored as text and not numeric.

F22+H22 requires two numeric values, and if either cell has a non-numeric
value, I would expect the #value result.

HTH,
Keith

"Ayo" wrote:

>
> Why am I getting a #Value error with this formula:
> IF(OR(H22>0,F22>0),F22+H22,0)
>
> where F22=1 and H22=blank
From: Joe User on
"Ayo" wrote:
> Why am I getting a #Value error with this formula:
> IF(OR(H22>0,F22>0),F22+H22,0)
> where F22=1 and H22=blank

Try:

=IF(OR(N(H22)>0,F22>0),F22+N(H22),0)

H22 probably only __appears__ blank, but its value might actually be the
null string (""). This is quite common, e.g. =IF(G22="","",G22+E22).

It also possible that F22 contains the text "1" instead of the number 1. If
that is the case, you probably want to correct F22. For example,
=IF(G22="","1","2") should be =IF(G22="",1,2).

Alternatively, you could write N(F22) instead of F22.