0

No matter which syntax i use, sharepoint throws me a syntax error on IF function.

here is what i have tried so far

= IF ( [colA] = "dddd"; "yes" ; "no" )
= IF ( [nr1] < [nr2]; "yes"; "no")
= IF ( [colA] = "ddd", "yes", "no")  -my localization should use " ; "
= IF ( [colA] ='ddd'; 'yes'; 'no')

I can't figure out what's wrong, can this be something that is restricted from Sharepoint Admin in the enviroment?

  • Strange....Assuming you have a single line of text column with display name Column1. Try using this: =IF([Column1]="ABC";"OK";"Not OK"). Also, return the data type of your column as "Single line of text". – Ganesh Sanap Jul 29 at 15:38
1

I think you should use , instead of ;.

Also dont give space after If. Try these:

= IF([colA]="dddd","yes","no")
= IF([nr1]<[nr2],"yes","no")

let me know if it works. I used comma and it works fine.

| improve this answer | |
  • please see line 3, where i stated my localization. I have tried commas :) – Michael Christensen Jul 29 at 13:54
  • =IF([tal1]=[tal2],1,2), =IF([tal1]=[tal2],"1","2") - throws syntax error same with ; – Michael Christensen Jul 29 at 14:02
0

Official document: https://support.microsoft.com/en-us/office/if-function-7025be14-5665-43d0-af20-8293d1fe9d3a

=IF(Title="1","yes","no") should be ok.

Test Result:

enter image description here

| improve this answer | |
  • Tried it both with , and ; my localization is ; and i have other calculated columns that works with ; it just seems that IF doesnt want to work. I will have a meeting with our software partners in September, it must be something in the enviroment thats not right. – Michael Christensen Jul 31 at 8:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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