Need help with using the IIF Function in MS Project RRS feed

  • Question

  • Hello,

    I am attempting to write the following formula but having an issue with the syntax and which relational operator is required to make it successful.  

    I need to do the following:

    • If [Date1] is less then or equal to DateValue "12/31/2018", add [Number1] and [Number2] than divide it by 4. 
    • If [Date1] is more then DateValue"12/31/2018, And if [Number4] *[number5] is less then 0, return "0", otherwise return [Number4]*[Number5]

    I wrote this formula but it is incorrect and I an having a difficult time determining where the errors are:

    IIf ([Date1] <= DateValue(“12/31/2018”), [Number1] +[Numberr2]/4,  IIF([Date1] > DateValue(“12/31/2018”), IIF(AND[Number4] * [Number5] < 0, "0",([Number4] * [Number5])))

    Thank you,


    Thursday, April 5, 2018 3:59 PM

All replies

  • KR,

    Please don't cross-post. Didn't I already answer this question for you on the Answers forum? Answer, yes I did.


    Thursday, April 5, 2018 4:58 PM