 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008Blank 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 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),"") > [quoted text clipped - 4 lines] > > Hank > My formula in E4 is: =IF(B4<TODAY(),SUM(25+H4),"") > [quoted text clipped - 4 lines] > > Hank =IF(AND(B4<TODAY(),NOT(ISBLANK(B4))),25+H4,"") -or- =IF(OR(B4>=TODAY(),ISBLANK(B4)),"",25+H4) Thanks JW, Worked great! On May 28, 1:17 pm, "HH" <deerl...@bellsouth.net> wrote: > My formula in E4 is: =IF(B4<TODAY(),SUM(25+H4),"") > [quoted text clipped - 5 lines] > > Hank =IF(AND(B4<TODAY(),NOT(ISBLANK(B4))),25+H4,"") -or- =IF(OR(B4>=TODAY(),ISBLANK(B4)),"",25+H4) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.