Funciotion if with multiple values

[#1]

Hi I nedd to create a new field to summarize information coming form another field saying:

- if (field A="1or2", then 'OK',

- if (field A= "3or4or5or6", then KO"

- if (field A= "7or8or9 then "MAYBE"

How can i put togheter?

Thanks in advance

Bruno

[stabben23]

Hi Bruno, this should work: If(field A=1 or 2, 'OK, if(field A = 3 or 4 or 5 or 6, 'KO', if(field A= 7 or 8 or 9, 'MAYBE'))) as new_field.

[#3]

are u sure If(field A=1 or 2 is working?

When i got just one value for category i write it as If(field A='1')

[stabben23 · Accepted solution]

Hi Bruno, then put all numbers between 'x'. Like if(field A='1' or '2', 'OK'............