"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.