IF function (if) in Word table
uzuma
-
m@rina Posted messages 27633 Registration date Status Moderator Last intervention -
m@rina Posted messages 27633 Registration date Status Moderator Last intervention -
Hello,
I’m on a Word table. I’m using the 'Formula' option and then the IF function directly on field codes like this: =if(A1=1;1;0)
The formula works: if the number 1 is entered in cell A1, the result is 1; 0 otherwise. So far so good.
When I use letters, it doesn’t work :( The same approach with: =if(A1=1;"A";"B"). I get this error: !Syntax error, " even though cell A1 shows 1 or something else!! In Excel, of course, it works!
Please help me!
Thanks in advance.
I’m on a Word table. I’m using the 'Formula' option and then the IF function directly on field codes like this: =if(A1=1;1;0)
The formula works: if the number 1 is entered in cell A1, the result is 1; 0 otherwise. So far so good.
When I use letters, it doesn’t work :( The same approach with: =if(A1=1;"A";"B"). I get this error: !Syntax error, " even though cell A1 shows 1 or something else!! In Excel, of course, it works!
Please help me!
Thanks in advance.
1 answer
-
Hello,
No need to compare with Excel, because it doesn’t work the same at all.
With Word, we use fields and we don’t start with an equals sign.
And on that side, Word is much more complicated to use... So, if we can do without it, it’s better to do this with Excel.
Here is the correct field, please strictly respect the syntax. I’m going to copy-paste an image so you can clearly see where the spaces are.
I specify that ALL pairs of { } are created with Ctrl+F9. One can go through the Formulas menu, but the result isn’t guaranteed!
m@rina
--
We are not fortune-tellers: please remember to indicate the version of the software used, and how you proceeded.
