Forum Discussion
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...
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.
Hi Matt,
Thank you so much for the quick response!
You're the best!
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.
Hi Matt,
We can't make it work - I have attached a sample file. Could you please have a look at it?
Hoping that you could resolve it. Thank you.
Hey Michelle-
Happy to help. Try using the below formula. I'm also attaching a sample workbook for reference.
