View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HH[_4_] HH[_4_] is offline
external usenet poster
 
Posts: 42
Default 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