Prev: Macro/VBA to loop through list of values and output row- Help
Next: Sort function
From: Ayo on 26 Feb 2010 11:39

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 26 Feb 2010 12:02
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 26 Feb 2010 12:41
"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.
 | 
Pages: 1
Prev: Macro/VBA to loop through list of values and output row- Help
Next: Sort function