I have a Custom forumla I need help with..

[Timmy V.]

I have to create a custom formula that does the following:

IF
100% work complete,

THEN
(Actual Work-Baseline Estimate)

IF NOT, THEN
display "Incomplete"

Can anyone help?

Plus, what is the format of a good formula with multiple parts (EG. if then
statements followed by a resulting formula if true)

Thanks!

 

[Dale Howard [MVP]]

Timmy V --

Based on the description of your reporting needs, you could use a task Text
field with the following formula:

IIf([% Work Complete]=100, ([Work Variance]/60) & "h", "Incomplete")

The above formula will display the result in hours. However, what do you
want the system to show if the task and/or project has not been baselined?
A better formula would be one that would "trap" for the possibility of no
baseline information on a task. Therefore, I would recommend a formula such
as the following:

IIf([Baseline Finish] = ProjDateValue("NA"), "No Baseline", IIf([% Work
Complete]=100, ([Work Variance]/60) & "h", "Incomplete"))

The above formula shows you how to nest IIf statements to test for specific
conditions. Hope this helps.