MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Having MUCH trouble with a simple problem (please help)


Posted by Jim Jankowski on February 22, 2001 1:26 AM

In my spreadsheet I have and expiration date coumn (J)and in column K is a formula that will let me know when the expiration date is within 60 days of today. My K2 value is =IF K2<=TODAY()+60,"Expiring","")

My problem is that it puts "Expiring" in block K2 if block J2 is blank. I don't want this. But I can't figure out how to write an arguement that looks for a null value in J. Please help


Posted by A. Akyurek on February 22, 2001 1:42 AM

How about entering in K2

=IF(ISNUMBER(J2),IF(J2<=TODAY()+60,"Expiring","Expired"),"")

Aladin

Posted by dan on February 22, 2001 4:29 AM


Or you could just add an extra if statement, ie
IF(J2 = "","", IF K2<=TODAY()...ETC)
dan