Forum Discussion
Michelle Brand Beast
May 24, 2018Copper Contributor
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!
- Matt MickleBronze Contributor
Michelle-
I believe you can accomplish your task by using a Vlookup. Please reference the below post and the example file that is included in it . You will need to make a reference table based on your thresholds and then use the table in the vlookup to get the correct cost. You may have to make a few tweaks but it should be the same basic concept. :
Ill also attach the file here for easier reference.
- Michelle Brand BeastCopper Contributor
Hi Matt,
Thank you so much for the quick response!
You're the best!
- Matt MickleBronze Contributor
Glad you were able to get your issue resolved. Feel free to post back to the community if you have more questions or need further clarification.