Tuesday, June 25, 2013

yogi_Compute Total Price For Quantity Ordered Based On Multi-Tier Pricing System

                                          Google Spreadsheet   Post  #1262
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 26, 2013
user Cooper Brown (http://productforums.google.com/forum/?zx=81uncl5s0y25#!category-topic/docs/spreadsheets/mT06SpkrTLw)
Challenging sum problem
Can anyone help me with the following summation formula:  $145 for 1 unit, $165 for 2 units, $195 for 3 units, and $45 for every unit over 3.  I would like to be able to enter the number of units into a cell and have dollar total show up in the cell directly to the right.  Is this at all possible?   Thank you very much for your help.
-----------------------------------------------------------------------------------------------------------------------------------------------------