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.

[TeeSee1 · Accepted solution]

You can use IFS() instead.

[Mantenimiento_S]

OK. And hoy can compare a value for example for this range:

185 to 210:    between 185 to 210 the value is BIG, between 210 to 235 is VERY BIG

[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.

[Mantenimiento_S]

Numbers below or above the range should not be evaluated

[Mantenimiento_S]

How I should do that?

Regards

[TeeSee1 · Accepted solution]

you mean the label should be blank?

IFS(
 [col]<185, "",
 [col]<210,"BIG",
 [col]=<235,"VERY BIG",
 [col]>235,""
)

Note: Please mark only the post that actually solves your issue.