Error using iif function

Question

When using the iif function I get an error that says 'you omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks'. I get this even when I try:

iif((1+1=2),"yes","no")

I've been working on this for a few hours, trying different things. I called MS support and apparently this is the only forum to get help. Having that function for the work I'm doing is critical. Any suggestions please?

Answer 1

Try changing the list separator to a comma.

Answer 2

Also should mention I'm on version 2402.

Answer 3

I use commas but I also tried semicolons based on advice in a prior posting and that didn't work. Plus in the expression builder when typing =iif, it shows what the expression should look like and appears to show pipe delimiters ( | ) between the condition and the results but that didn't work either.

Answer 4

Also, forgot the '=' in my message above, should have written:

=iif((1+1=2),"yes","no")

Appreciate whatever help you can provide.

Answer 5

Do you use comma as decimal separator? If so, use semicolons between the arguments:

IIf(1+1=2; "yes"; "no")