This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I'm currently doing a MS Project Beginners to Advance course on YouTube.
My issue is, we are doing a relatively simple calculation. The calculation is to create Red, Amber, Green flags for variances in costs.
I am using their example sheets, therefore should not be any issues relating to missing fields - at the very least.
I have copied their calculation verbatim per the course and it does not work.
The calculation is:
IIf([Cost Variance]>0, "X", "G")
What it is saying is:
if the cost variance is greater than 0 - if true, output an "X" for positive values.
For the G - if false, the cost variance is negative then output a "G".
I get the below error pop up every time and don't understand why?
"The formula contains a syntax error or contains a reference to an unrecognized field or function name."
Thanks
Microsoft project management software used to plan, manage, and communicate a project schedule and other information among workgroup members, project managers, and other stakeholders.
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.
Answer accepted by question author
Well, that works for me in a text field. Is your formula in a custom text field?
In your country version of MSP maybe the quotes or comma separators should be other characters. Try single quotes.
Hi Trevor,
Thank you.
I changed the comma separator - to works now.
Much appreciated.