|
Grand Rapids, MI | Yes, I took it to mean that it is the opposite of a volume discount. Each individual item is $25 more than the last and you need to add them together to get the total.
The formula I posted is based on a method first attributed to Gauss. Think of adding the numbers 1 to 100...how would you do it...Lets say you added the 1 and the 100 = 101 and 2+99=101 and 3+98=101 and so on until you ran out of numbers. You would have 100/2=50 sets right? So 101*50=5050 is the answer. So (1+n) is the 101 part and the (n/2) is the 50 part in a general formula. So you get the sum of the numbers from 1 to n = (1+n)*(n/2)
Now we just need to add the $75 base plus the $25 increment times the sum of the numbers from 1 to the total. That gives us that final formula.
PS you are right my degree in Mathematics is actually a BS. The BA was in Economics..although some might argue that Econ involves more bs....lol | |
|
Excel Formula Help
