Search code examples
excelformulas

Populating a Cell based on the value of another cell?

I'm trying to calculate an hourly pay rate based the quantity of product being produced. Different quantities ordered will require different pay rates to produce the product. Here is an example of what I'm trying to accomplish:

If D2(The Quantity) is between 1 and 25 Display F29( Hourly Rate 1)

If D2(The Quantity) is between 26 and 50 Display F30( Hourly Rate 2)

If D2(The Quantity) is between 51 and 100 Display F29( Hourly Rate 3)

Any help would be appreciated. Thanks.

Solution

  • Use this:

    =INDEX(F:F,MATCH(D2,{1,26,51})+28)