I am using the formula below to calculate the number of days left to do something, when there are no days left I want the cell to display "Begun" in red italic text. Is it possible to do that via this formula or is a macro needed?
=IF(ISBLANK(E2),"",IF((E2-I2)<0,"",E2-I2-10&(" Days")))
Last edited by jsolder; 10-23-2009 at 10:34 AM.
=IF(ISBLANK(E2),"",IF((E2-I2)<0,"Begun",E2-I2-10&(" Days")))
Use conditional formatting to check cell for Begun.
That works. Would I be able to modify that formula to display "Complete" in the Cell if Cell L2 contains "Passed"?
=IF(ISBLANK(E2),"",IF((E2-I2)<0,"Begun",E2-I2&(" Days")))
=IF(ISBLANK(E2),"",IF((E2-I2)<0,if(L2="Passed","Complete","Begun"),E2-I2&(" Days")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks