IF Formula

[dcjames]

I know I should probably know the answer to this, but I can't seem to get a formula to work correctly.

I have a field with spaces in the values ( e.g. "New User" "Old User" "Medium User")

When I try to do the following I get an error

If (field name) in ("New User", "Old User) then "User" else ""

The error indicates that a ) is required after "New User"

Any help is appreciated.

Thanks

 

[xxyyzz49]

Put the list in brackets "[]" like:

If {field} in ["New User" , "Old User"] then "User" else ""

 

[dcjames]

Thanks pmsawyer!