=IF((TODAY()+30)<J2,"",IF(TODAY()>J2,"Overdue",IF( ISBLANK(I2),"Warning",K2*1)))
=IF((TODAY()+30)<J2,"",IF(TODAY()>J2,"Overdue",IF( ISBLANK(I2),"Warning",K2*1)))
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks