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.
-----------------------------------------------------------------------------------------------------------------------------------------------------
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.
-----------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment