Tuesday, April 28, 2015

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