microsoft project formula question

IIf([% complete]=0 and [Start]<[current Date],2,1)

The above forumla works but what i would like to do is have more than a true or false option (2,1 as above)

Basically i'm looking to write a formula that will.....

Put a "1" in a text column if the% complete is greater than 0

Put a "2" in a text column if the task is up to a week late in starting i.e the percent complete has a value of 0 and the date is 5 working days past today's date

Put a "3" in a text column if the task is more than a week late in starting i.e the percent complete has a value of 0 and the date is greater than 5 working days past today's date.

I have not included any way of measuring expectted progress compared to actual progress to date (its a v simple planning we're working in here)

Please help! :crybaby:

Here I have one example of formula which may be helpful to solve your issue.

IIf([% Complete]<100,Switch(([% Complete]=0 And (DateValue([Current Date])-DateValue([Start]))>0),1,((DateValue([Current Date])-DateValue([Finish]))<-5),3,(DateValue([Current Date])-DateValue([Finish]))>=-5 And (DateValue([Current Date])-DateValue([Finish]))<0,2,(DateValue([Current Date])-DateValue([Finish]))>=0,1),3)


Just try this and let me know if this will solve your problem.