Forum Discussion
Multiple IF statement
It looks correct and works for me when I test with the same code. I have sometimes experienced that there can be problems with language settings so you can try replacing the " with ' and see if that helps.
The statement You are trying to use (that does not work):=IF([Document Type]="Form","F-",
IF([Document Type]="Document","D-",
IF([Document Type]="SOP","SOP-")))
The statement i am using (that works for me):=IF([Document Type]="Form","F-",IF([Document Type]="Document","D-",IF([Document Type]="SOP","SOP-")))
A statement that might work for You:
=IF([Document Type]='Form','F-',IF([Document Type]='Document','D-',IF([Document Type]='SOP','SOP-')))If that variant doesn't work, maybe you can try removing the line breaks in your code and typing/pasting the code the way I wrote it with everything on one line. (That shouldn't be the solution but you never know 🙂
It looks correct and works for me when I test with the same code. I have sometimes experienced that there can be problems with language settings so you can try replacing the " with ' and see if that helps.
The statement You are trying to use (that does not work):
=IF([Document Type]="Form","F-",
IF([Document Type]="Document","D-",
IF([Document Type]="SOP","SOP-")))
The statement i am using (that works for me):
=IF([Document Type]="Form","F-",IF([Document Type]="Document","D-",IF([Document Type]="SOP","SOP-")))
A statement that might work for You:
=IF([Document Type]='Form','F-',IF([Document Type]='Document','D-',IF([Document Type]='SOP','SOP-')))
If that variant doesn't work, maybe you can try removing the line breaks in your code and typing/pasting the code the way I wrote it with everything on one line. (That shouldn't be the solution but you never know 🙂
- thanks for this MagnusGoksoyrOLDProfile, i used the formula that you were using and worked for me also, however I cant see any difference between my formula and yours (I pasted these both in notepad to check) either way it works and I am happy so thank you for your help!
