bellashahar
New Member
- Joined
- Nov 5, 2009
- Messages
- 34
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.
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.