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
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