Blank or Zero or None?

  • Thread starter Thread starter HH
  • Start date Start date
H

HH

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
 
You could use this formula instead I guess...

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

Rick
 
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
Click to expand...

=IF(AND(B4<TODAY(),NOT(ISBLANK(B4))),25+H4,"")
-or-
=IF(OR(B4>=TODAY(),ISBLANK(B4)),"",25+H4)
 
Thanks JW,
Worked great!

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
Click to expand...

=IF(AND(B4<TODAY(),NOT(ISBLANK(B4))),25+H4,"")
-or-
=IF(OR(B4>=TODAY(),ISBLANK(B4)),"",25+H4)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula to change font colour depending on which cell it has used 1
If Condition 4
Supressing a #VALUE! error returned? 3
Leave final cell blank 2
File Name changes with dates and Deleting Rows of Zeros 0
Formula to get number of days within a period excluding Fridays 6
EMPLOYEE WEEKLY SCHEDULE 6
formula or macro to change a formula in muliple spreadsheets 1

Back
Top