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

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

Blank or Zero or None?
 

On May 28, 1:17*pm, "HH" wrote:
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

=IF(AND(B4<TODAY(),NOT(ISBLANK(B4))),25+H4,"")
-or-
=IF(OR(B4=TODAY(),ISBLANK(B4)),"",25+H4)

Blank or Zero or None?
 

Thanks JW,
Worked great!

"JW" wrote in message
...
On May 28, 1:17 pm, "HH" wrote:
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

=IF(AND(B4<TODAY(),NOT(ISBLANK(B4))),25+H4,"")
-or-
=IF(OR(B4=TODAY(),ISBLANK(B4)),"",25+H4)