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...
Formulas & Functions
tips and tricks
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
May 24, 2018

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. :

 

https://techcommunity.microsoft.com/t5/Formulas-and-Functions/Formula-debug-am-i-using-the-wrong-formula/m-p/197021#M5726

 

 

Ill also attach the file here for easier reference.

 

 

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

Hi Matt,

 

Thank you so much for the quick response!

You're the best!

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    May 24, 2018

    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.

      • Matt Mickle's avatar
        Matt Mickle
        Bronze Contributor
        May 25, 2018

        Hey Michelle-

         

        Happy to help.  Try using the below formula.  I'm also attaching a sample workbook for reference.

         

         

         

Resources