View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_2013_] Rick Rothstein \(MVP - VB\)[_2013_] is offline
external usenet poster
 
Posts: 1
Default 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