Sharepoint list, Calculated Column, IF syntax error

[Dimitrij_P]

Hi all,
I have the following problem:
I have a SharePoint list with different columns.

Column 1 = single choice column with drop-down and values 1, 2, 3

Now I want to create a Column 2 = calculated column

The formula looks like this
=IF([Column 1] = 3; "OK"; "NOK")

After the confirmation, I get a message of a syntax error.
I don't know where the error should be, since the formula is quite simple.

Do you have a hint?

Thank you in advance,

best regards

Dimitrij

[#2 · Accepted solution]

@Dimitrij_P it needs to be =if([Column 1]="3","OK","NOK")

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

[#3]

Hi Rob,
thank you for your quick reply!

I've tried your solution, unfortunately, it doesn't help. Still get the syntax error.

Dimitrij

[#4]

It works perfectly for me, so what is the formula you have used?

[#5]

The same you've posted:
=if([Column 1]="3","OK","NOK")

[#6]

@Dimitrij_P are you sure? This is my list and the formula which gives exactly what you wanted:

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

[#7]

@RobElliott 

now it works - very strange - I've not changed anything.

However, it works - so thank you very much for your suppot!

Best Regards

Dimitrij

[#8]

Hi all.

I've the same problem. I tried replacing ; by , I tried with another browsers. :(

[#9]

Hello all just wanted to throw in my comments that I think sometimes the formula required a semicolon and sometimes it requires a comma, based on the default language of your environment. In my case the default environment was French and requires a semicolon. I believe other sites have other default languages, so their formulas required commas. This is really painful to troubleshoot and documentation seems pretty lacking in this regard from what I can tell.

[#10]

@AlexinEdmonton 

Thanks, You solved my problem.

Kind regards,

Frankly 

[#11]

Thank you!! It was exactly this that caused my error. Very similar requirement: going from an enum value to display names. Belgian user, Dutch SPO site, ";" needed instead of ",".