Compound rate

[SPY]

I'm trying to create a worksheet to help with an online game (Storm8 Worldwar). Cost of units increase by 10% after each purchase. e.g first unit costs 20000, next time it's 22000 and then 24200 etc.
I'd like to enter the base cost (20000) in a cell and next to it the quantity held and in another cell calculate the cost of the next purchase.

Hope that makes sense! Thanks

 

[VoG]

Try this - formula in B3 copied down

Excel Workbook
	A	B
1	Qty	Cost
2	1	20000
3	2	22000
4	3	24200
Sheet9

 

[SPY]

Thanks but I'm trying to use a single cell to calculate the cost.

Base Cost Quantity Held Next Cost
Unit A 20 5 29.3


i.e
# 2 = 20 *1.1 22
# 3 = 22 *1.1 24.2
#4 = 24.2 *1.1 26.62 etc

 

[VoG]

Try this

Excel Workbook
	A	B	C
1	Base cost	Qty	Next cost
2	20000	3	26620
Sheet11

 

[SPY]

Great, thanks