Hello, first time poster here and hoping to get some help with something outside of my wheelhouse !
I am designing an P&P rpg and using Excel to house my character sheets. I'm capable enough in excel to handle the small formulas and referencing but this one formula is a bit over my head.
What I desire is as follows - A23 will contain the amount of character experience points not yet distributed. A3, A7, A11, and A15 will house the character attributes that I wish to subtract their value from A23.
The hold up that I'm having is that I need for the values of A3,A7,A11, and A15 to subtract from A23, not their displayed values but a value dependant on the number in the cell.
The first 5 points in an A3, A7, A11, and A15 cell only cost 1 point each. Once you reach 6, however, each increase costs 2 points. This pattern continues into infinity with every 5th value increasing the cost of the points by 1. Examples below.
Example 1 : If a character has a value of 7 in their A3 stat then I need 9 points subtracted from A23.
Example 2 : If a character has a value of 3 in their A7 stat then I need 3 points subtracted from A23.
Example 3 : If a character has a value of 22 in their A11 stat then I need 60 points subtracted from A23.
Here is an example of the grid that may shed more light on the system that is being used.
1 1 2 1 3 1 4 1 5 1 6 2 7 2 8 2 9 2 10 2 11 3 12 3 13 3 14 3 15 3 16 4
This is my first post so if it's vague or more information is required please let me know and thanks in advance!
Bookmarks