• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Help Please

brad87

New Member
Hello, I am trying to have excel tell me how much somthing would cost that increase by 10% each time you buy it. Example cost for 1 2500 cost for 2 is 2750 and 3 3000 each time the number goes up by 250 or 10%. What i am looking for is a formula so if i say i want to buy 20 of them, it will tell me the total cost. 8250.
 
The cost would be 7250 I believe. Use this formula:

=2500*(0.9+0.1*A2)

Where A2 contains qty. This would create a table that looks like this:

[pre]
Code:
Qty	Cost
1	2500
2	2750
3	3000
4	3250
5	3500
6	3750
7	4000
8	4250
9	4500
10	4750
11	5000
12	5250
13	5500
14	5750
15	6000
16	6250
17	6500
18	6750
19	7000
20	7250
[/pre]
 
=2500+(a1-1)*250

Where A1 is the cell containing the number you want to purchase
 
Hi, brad87!

If you buy 20 they'd cost you 7250 as Luke M wrote and not 8250, unless your formula isn't completely accurate.

Another one that displays same results as both Luke M's and Hui's ones is:

=2500*(1+0,1*(A2-1))

Back to your sequence, which is an arithmetic progression, if I change it to a geometric progression as:

=2500*(1+0,1)^(A2-1)

I get 15289.77 for 20 items and not 8250.

Regards!
 
Back
Top