cancel
Showing results for
Did you mean:
Highlighted
Member

## IF Function with 3 or more posible results HELP!

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"))

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: IF Function with 3 or more posible results HELP!

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.

Proud to be a Datanaut!

9 REPLIES 9
Super User

## Re: IF Function with 3 or more posible results HELP!

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))`

Proud to be a Datanaut!

Super User

## Re: IF Function with 3 or more posible results HELP!

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

Member

## Re: IF Function with 3 or more posible results HELP!

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

Thank @jthomson

Member

## Re: IF Function with 3 or more posible results HELP!

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!!

Super User

## Re: IF Function with 3 or more posible results HELP!

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.

Proud to be a Datanaut!

Super User

## Re: IF Function with 3 or more posible results HELP!

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

Member

## Re: IF Function with 3 or more posible results HELP!

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

Super User

## Re: IF Function with 3 or more posible results HELP!

Sure you could use SWITCH

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