Sharepoint 2007 IF OR 3 way condition to check for days left if they are greater or smaller <> (Network Steve Forum)

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

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.

May 31st, 2011 3:34pm

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

Free Windows Admin Tool Kit Click here and download it now

May 31st, 2011 4:36pm

This topic is archived. No further replies will be accepted.