Blank or Zero or None?

's Computer Specifications

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

's Computer Specifications

You could use this formula instead I guess...

=IF(AND(B4<TODAY(),B4<>""),SUM(25+H4),"")

Rick

"HH" <(E-Mail Removed)> wrote in message
news:zrg%j.18629$(E-Mail Removed)...
> 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
>

's Computer Specifications

On May 28, 1:17*pm, "HH" <deerl...@bellsouth.net> 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)

's Computer Specifications

Thanks JW,
Worked great!

"JW" <(E-Mail Removed)> wrote in message
news:fe042553-1b1c-42ac-b1cf-(E-Mail Removed)...
On May 28, 1:17 pm, "HH" <deerl...@bellsouth.net> 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)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Average Formula to display blank cell if named range is blank	Rachael F	Microsoft Excel Worksheet Functions	3	22nd Feb 2008 05:05 PM
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between.........	amorrison2006@googlemail.com	Microsoft Excel Programming	2	7th Jun 2007 09:27 PM
Macro code to test for blank row and insert blank row if false	=?Utf-8?B?TWF0dGll?=	Microsoft Excel Programming	2	29th Mar 2006 01:19 AM
Blank Sender, Blank Subject, Blank Body	=?Utf-8?B?c2luMTQ3MA==?=	Microsoft Outlook Discussion	2	4th Nov 2005 01:02 PM
Receiving totally blank emails - To, From, Subject, & Body blank	=?Utf-8?B?dGFicmlnaHQ=?=	Microsoft Outlook Discussion	1	2nd Nov 2005 10:35 PM