Cormanthor
New Member
- Joined
- Nov 26, 2016
- Messages
- 2
I have a sheet that calculates the different experience points needed to gain levels in a game. I currently have a column of levels (1-30, consecutively) and another column with the formula =250*(A1^2+A1)/2
This formula yields the difference needed to gain the next level (250 to gain level 2, 750 more to gain level 3, and so on).
I would like a way to find the total experience points needed directly, without the aid of these columns (example: level 10 needs 41,250 experience). Currently I have to add B1:B9 to get this info.
Any idea what math / formula I need to use to get here from a cold start? Is this even possible?
This formula yields the difference needed to gain the next level (250 to gain level 2, 750 more to gain level 3, and so on).
I would like a way to find the total experience points needed directly, without the aid of these columns (example: level 10 needs 41,250 experience). Currently I have to add B1:B9 to get this info.
Any idea what math / formula I need to use to get here from a cold start? Is this even possible?