Blank or Zero or None?
You could use this formula instead I guess...
=IF(AND(B4<TODAY(),B4<""),SUM(25+H4),"")
Rick
"HH" wrote in message
. ..
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
|