locked
Sharepoint 2007 IF OR 3 way condition to check for days left if they are greater or smaller <> RRS feed

  • Question

  • Hi, I try to create a calculated column based on another column where I get a calculated days left in my project list.

    Now I would like to get a 3 way status based on Days_left>10  Days_left<10  10  Days_left<0 

     

    With this formula I can get a working 2 way condition but I cant get a 3rd way into to address <=0 a overdue. 

    =IF(OR(Days_left>10,Days_left<10),"Late","On Time")

     

    Does anyone have an idea how to get a 3rd condition into? 

    Thanks

    Andreas

     

    • Moved by Mike Walsh FIN Tuesday, May 31, 2011 4:48 PM admin q (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Tuesday, May 31, 2011 4:26 PM

Answers

  • I don't know the proper formatting, but I assume something like this would work?

    =IF( (Days_Left=0),"Whatever") IF(OR(Days_Left>10,Days_Left<10),"Late","On Time") )

    You can't really do a Days_Left<=0 because Days_Left<10 is the same result.
    • Marked as answer by David HM Thursday, June 9, 2011 1:31 AM
    Tuesday, May 31, 2011 7:12 PM