Forum Discussion

Michelle Brand Beast's avatar
Michelle Brand Beast
Copper Contributor
May 24, 2018

IF function - formula incorrect

Hi guys,

 

So basically what I am trying to do is let Excel determine if what tier we are going to use automatically so it's like this:

 

If the given weight (column B) is less than, equal to, or greater than the range in column I, then it should correctly select the correct tier on column G.

 

I have tried this formula =IFS(B2<=I2:I6,"New - Tier One", "New - Tier Two", B2<=I2:I6,"New - Tier Three", "New - Tier Four", B2<=I2:I6,"New - Tier Five")
but it is not working. I am not sure if I am using the correct one.

 

Any help? I would appreciate it.

Thank you!

Resources