Share via

IFF function formula has error

Anonymous
2022-09-13T04:41:21+00:00

There is a exactly same formula online

Where my IIf formula prompts error message:

  • This formula contains errors. Correct the formula and try again.

IIf([t_En]=1, “Complete”, IIf([t_En]=2, “On Schedule”, IIf([t_En]=3, “Late”, IIf([t_En]=4, “Future Task”, “Not Applicable”))))

Anyone knows the reason?

Microsoft 365 and Office | Project | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2022-09-14T07:22:40+00:00

You still have several commas in the formula.

Something else I saw only now: you use curly quotes around the text strings. You should use straight quotes in expressions/formulas. So if you use point as decimal separator:

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

And if you use comma as decimal separator:

IIf([t_En]=1; "Complete"; IIf([t_En]=2; "On Schedule"; IIf([t_En]=3; "Late"; IIf([t_En]=4; "Future Task"; "Not Applicable"))))

Was this answer helpful?

1 person found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-14T09:09:31+00:00

    thanks perfect.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-09-14T03:24:55+00:00

    IIf([t_En]=1, “Complete”; IIf([t_En=2, “On Schedule”; IIf([t_En]=3, “Late”; IIf([t_En]=4, “Future Task”, “Not Applicable”))))

    Thanks, but changed still have error.

    Was this answer helpful?

    0 comments
  3. HansV 462.6K Reputation points
    2022-09-13T11:42:46+00:00

    Do you use comma as decimal separator? If so, use semicolon ; between the arguments instead of comma ,

    Was this answer helpful?

    0 comments