#VALUE ERROR

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

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
 
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 said:
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
Click to expand...

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.
 
Back
Top