Formula Help comparing multiple finish dates--Anyone up to the challenge? ;)

Submitted by DaveF on
Microsoft Project

Member for

9 years 10 months
Member for 9 years 10 months
Submitted by DaveF on Fri, 2015-12-18 22:41
Permalink

WELL DONE - Thank You

Member for

9 years 10 months
Member for 9 years 10 months
Submitted by DaveF on Fri, 2015-12-18 22:41
Permalink

WELL DONE - Thank You

Member for

21 years 9 months
Member for 21 years 9 months
Submitted by Jerome Odeh on Thu, 2015-12-17 23:19
Permalink

Hi David,

You need nested IIF Statements. The outline nested IIF is:

IIf( Exp1, Ans1, IIf( Exp2, Ans2, IIf( Exp3, Ans3, IIf( Exp4, Ans4, IIf( Exp5, Ans5, IIf( Exp6, Ans6, IIf( Exp7, Ans7, "= =" ) ) ) ) ) ) )

Replace the following in the above outline.

  1. Exp1 = ([Finish]>[Finish1]) And ([Finish]>[Finish2])
  2. Ans1 = "> >"
  3. Exp2 = ([Finish]<[Finish1]) And ([Finish]<[Finish2])
  4. Ans2 = "< <"
  5. Exp3 = ([Finish]>[Finish1]) And ([Finish]<[Finish2])
  6. Ans3 = "> <"
  7. Exp4 = ([Finish]=[Finish1]) And ([Finish]>[Finish2])
  8. Ans4 = "= >"
  9. Exp5 = ([Finish]>[Finish1]) And ([Finish]=[Finish2])
  10. Ans5 = "> ="
  11. Exp6 = ([Finish]=[Finish1]) And ([Finish]<[Finish2])
  12. Ans6 = "= <"
  13. Exp7 = ([Finish]<[Finish1]) And ([Finish]=[Finish2])
  14. Ans7 = "< ="

I think I have covered all possible 8 scenarios for you. See snippet below for working proof.

[[wysiwyg_imageupload:3213:]]

 

[[wysiwyg_imageupload:3214:]]