Using if to multiple values in a field

[eduardo_dimperio]

Hi everyone,

I have a Field name ALERT with values from 1 to 10, and i want this output

Case:

Alert <=2, 'None'

Alert >2 and Alert<=6, 'Normal'

Alert >6 and Alert<=10, 'Urgent'

How can i right this?

i had thought to use several ifs, but doesnt work in the same field or i dont know how to write.

Thank you

[sunny_talwar · Accepted solution]

May be this

If(ALERT <= 2, 'None',

     If(ALERT <= 6, 'Normal', 'Urgent')) as Flags

[eduardo_dimperio]

Wow so simple, thank you a lot. I didnt know how to put if inside a if (until now)

[sunny_talwar]

But now you do