Please help me with this nested formula! Thanks :)


Posted by Jim Jankowski on November 19, 2001 1:34 AM

I have spreadsheet which has expiration dates on items. If there is an expiration date in F the word approved shows in column G. If it's within 60 days of expiring the word "Expiring" appears in column G. I would like the word expired to appear when the item actually expires. Here is the formula I'm using now. Does anyone have any suggestions how to add the "Expired" factor into this nested formula?

=IF(ISNUMBER(F22),IF(F22<=TODAY()+60,"Expiring","Approved"),"")

Thanks for your help.



Posted by Paul Akkermans on November 19, 2001 1:50 AM

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