yogi_Compute Unit Rate For Specified Quantity Of Items Based On Table Of Multiple Quantity_Unit Rate Table

                                           Google Spreadsheet   Post  #1950
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr-28, 2015
question by Kiwi67mum:

https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/0CAYgbVvC1c
Multiple formulas.

I have 3 columns, each with different amounts.

I enter the quantity in Col B and would like it to identify what the $ amount is that is equal to the quantity. I don't think it is possible but it can't hurt to ask.

          

                                                                                                                Quantity            Rate               1-5 units              6-25 units     Over 25 units

Stencil

Unit

$22.50

$18.50

$15.00

-------------------------------------------------------------------------------------------------