SharePoint Online calculated column formula error

Question

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?

Answer 1

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

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

Note:

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.