Hello. I am new to this forum, not entirely sure where to post a question or search to see if the issue has been solved. I tried skimming through several threads, but couldn't find a similar enough problem. Sorry the title is wrong, I messed up the equation.
I am trying to develop a property calculator for an app. It is highly requested by several players, but no one has decided to make one public yet.
The issue I keep encountering is how to calculate the sum of calculation from 1 to n. The math isn't too complicated, but I have no idea how to translate Sigma P+(N*.1P) from 1 to N into excel. I would rather not calculate the this for each of the two dozen properties several thousand times and then find the sum of several thousand cells. I'm looking for a way to compact this into the minimal amount of cells. There will be one cell dedicated to each of the follow: the initial value of the property (P), the change is 10% of the initial property value (.1*P), and the number of properties bought (N), and the total cost (series equation). This of course can be modified if this cannot be accomplished in 4 cells. I am attempting to keep the file size as small as possible to make it easier to download.
A1 = 1000
B1 = 100
C1 = 5000
D1 = Total Cost
Please let me know if I need to clarify anything else. Thank you for taking time out of your day to help solve my problem.
Bookmarks