Blank or Zero or None?
My formula in E4 is: =IF(B4<TODAY(),SUM(25+H4),"")
Works great when I put a date in B4. But - if I accidently put a date in B4
and then delete it, the value stays in E4.
How do I get the value to disappear if I delete the date?
Hank
|