I would like to create a simple calculated field, that returns a text if a value is greater than another. Column [Bruttó összeg] is number type. I just copied the formula from the official Microsoft site, but still getting the error message:

"syntax error or not supported".

What should I do?

calculated field

1 Answer 1


Your formula syntax seems correct to me. Try using below formula:

=IF([Bruttó összeg] <= 100; "Within budget"; "Over budget")


  1. Sometimes comma(,) does not work in formula (It is based on language or regional settings on your site). So in that case you have to use semicolon(;) instead of comma(,).

Official Documentations:

  1. Calculated Field Formulas.
  2. IF function.
  • 1
    Thank you, semicolon was the trick. Commented Dec 13, 2021 at 8:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.