ExcelBanter - #VALUE ERROR

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - #VALUE ERROR (https://www.excelbanter.com/excel-programming/440021-value-error.html)

Why am I getting a #Value error with this formula:
IF(OR(H220,F220),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" wrote:

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

where F22=1 and H22=blank

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

Try:

=IF(OR(N(H22)0,F220),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.