Syntax error in computed SharePoint column formula

Question

Can I debug computed formulas for SharePoint columns?

I am trying to use a simple SharePoint calculation formula =IF([YTD]<[Budget], "OK", "Not OK"). These are Danish installations of SharePoint. I believe that fomula should look like this:

=HVIS([YTD]<=[Budget]; "OK"; "Not OK")

But it just comes out with the same syntax error or the error is not supported. I tried all IF / HVIS combinations, with / without square brackets, comma / semicolon, single quotes / double quotes, but nothing works. The formula =YTD<=Budgetworks.

Answer 1

The correct form depends on how the "Danish" installation: - (

, , , "HVIS" "IF"

, ";" ",", "," .

:

=HVIS([YTD]<=[Budget]; "OK"; "Not OK")
=IF([YTD]<=[Budget]; "OK"; "Not OK")
=HVIS([YTD]<=[Budget], "OK", "Not OK")
=IF([YTD]<=[Budget], "OK", "Not OK")