How can I get an IIF statement to recognize true text in a defaul.

E

EW

I am trying to get the following formula to work in MSProject:

IIf([Status]="Complete",1,IIf([Status]="Future
Task",2,IIf([Status]="Late",3,IIf([Status]="On Schedule",4,""""))))

For some reason it won't recoginze any true value in the [Status] column as
true.

Any advise?
 
D

Dale Howard [MVP]

EW --

You're not going to believe this, but in spite of the fact that you see TEXT
entries in the Status field, the field actually contais NUMERIC data.
Here's how the field works:

What You See Actual Value
Complete 0
On Schedule 1
Late 2
Future Task 3

Based on this information, you should be able to rewrite your formula
accordingly. Hope this helps.
 
Top