Help with IF statement

[bellashahar]

I need help with a formula.

Basically it's just H10-L10 (both are dates), however some in H and some in L show #VALUE! (this really can't be helped until data is populated).

So in my formula I would prefer if H or L has #VALUE! to return a blank cell instead of another #VALUE!

Any suggestions?

Thanks in advance.

 

[rwheeler]

In the "Applies to" box, you can specify the range. (E.g. H2:H100 or L2:L100)