Maybe something along the lines of:
Edit: And as for the last formula.....SUM won't work over rows AND columns.
Are you looking for an array there? maybe post a sample sheet with the results you are looking for.
Or does G1 refer to a single cell you want added to the formula?
And also, don't forget that most rpg's require much more xp as you level. So 150 xp at level 1 might still be a much higher % of a level then 1500 xp at level 10.
Edit 2: Also might need to add in a qualifier so that a level 10 player killing a level 2 monster doesn't lose xp
I think protonLeah's modifier table might be the way to go.
Bookmarks