IF Function with 3 or more posible results HELP!

[christianfcbmx]

This could be basic Dear Community but I need to find the way to clasify a result in 3 posibilities using "If"

I need to know if a x number es between 9, 16, 24.

ANY HELP WOULD BE SO MUCH APPRECIATED

My try was the following:

Rango* = IF('column (Chil'[TotalhoursDiff**]<= 'column (Chil'[Rango 1],"1",IF(AND('column (Chil'[TotalhoursDiff**]<='column (Chil'[Rango 2],'column (Chil'[TotalhoursDiff**]<='column (Chil'[Rango 3]),"2","3"))

[jthomson]

What range of TotalhoursDiff** should produce an output of 1, 2 or 3 respectively?

[christianfcbmx]

Exactly...and I might need a 4° range!

Thank @jthomson

[Greg_Deckler]

You have a mystery AND in there, not sure why. Try this:

Rango* = IF('column (Chil'[TotalhoursDiff**]<= 'column (Chil'[Rango 1],"1",IF('column (Chil'[TotalhoursDiff**]<='column (Chil'[Rango 2],2,3))

[christianfcbmx]

Hi @Greg_Deckler thats work better thank you but I have 2 last questions... what can I do when is 16:00 to keep it in range 2... because when is 16:00 goes to range 3.

What About if I need to add a fourth range (4)... How do I continue with the formula?

That would be all...hopefully you can give me a hand!!!

WRONG!!

[Greg_Deckler · Accepted solution]

Hmm, that's odd, do you have <= in the formula for the second condition?

The general format of the IF is:

IF(<condition>, <if true>, <if false>)

So, you just keep tacking on IF statements in the <if false> area. So, if you need a fourth value, you would just tack on an IF statement where you have the 3. You can string these together indefinitely but you might want to take a look at the SWITCH statement instead of the IF statement as it will be cleaner code-wise.

[christianfcbmx]

Pretty decent advices fellows!!!! thank you so much

[jthomson]

Would SWITCH actually work if it's trying to compare a range of values? AFAIK it would only work with constant values, and OP's got a lot of potential constant values

[Greg_Deckler]

Sure you could use SWITCH

https://community.powerbi.com/t5/Desktop/Switch-amp-Calculate-Issue/m-p/352890#M158765

[jthomson]

Heh, didn't think of using a variable as an intermediate step, that's nice