Help with expression "if" in a value range

[Mantenimiento_S]

Hi you all !!!

Hi. I have a value range like from 185 to 210 is SMALL, from 210 to 235 is BIG, and from 235 to 259 is VERY BIG.

How can I do that with and "if" expression?

Like always, thanks in advance

[TeeSee1 · Accepted solution]

You can use IFS() instead.

[TeeSee1 · Accepted solution]

The first conditional statement is less than 210 and a second condition is less than 235 in IFS().

Any numbers below 185 are also evaluated as big but I assume you don't have such cases because you have not identified any classification for those numbers.