Nested If calculation

[Wang]

I'm trying to put the following calculation into Project
at the task level... why wont it work?

IIF([% Complete]<1,IIF([FinishDate]<
[CurrentDate], "Yes","No"))

Any ideas?

 

[JulieD]

Hi Wang

firstly, you've not put the false parameter in for the first IIF statement,
therefore if the % Complete is >1 then an #error will be returned,
secondly what does [currentdate] refer to?

this seems to work for me (although not tested extensively)
IIf([% Complete]<1,IIf([Finish]<Now(),"Yes","No"),"No")

Cheers
JulieD

 

[JackD]

You are missing the second value for the first Iif statement.
Put a comma after the parenthesis after no and then a value.

Should be
IIF([% Complete]<1,IIF([FinishDate]<[CurrentDate], "Yes","No"), "something
here if % complete is greater than or equal to 1")

-Jack

 

[John]

Wang,
I assume you are using a spare text field (e.g. Text1) and creating a
custom field. Be aware that the formula will apply to all tasks, not
just a single task. Other than that, there are a couple of errors in the
formula. The field is simply "finish", not "finishdate" and there is a
space between the two words in the field "current date". Try the
following formula:
IIF([% Complete]<1,IIF([Finish]<[Current Date],"Yes","No"))

Hope this helps.
John

 

[John]

Jack,
Interesting, see my post. I didn't put in a second value and it worked
fine once I corrected the other errors (at least with Project 2000).
Ain't "consistency" wonderful.

John

 

[John]

Julie,
See my reply to Jack.

John