Deduct different values depends in other values

**PeterHacke** · 01-15-2021, 06:15 PM

Good evening,
sorry for my bad english but I hope you can get it

We are a small group of pen and paper player and since corona we moved to a remote version for our character sheets. Basically we would like to automate some calculations for those sheets.
The basics we managed easily but now we stucked for following part.

After each big quest we get points to level our skills and depends on skill-level the next level-costs raises.

For example:
point-pool is 20
to raise skill-level from 3 to 4 we need to spend 1 point, but after 4, from 4 to 5, we need to spend 2 points. With level 8 we have new raise of costs to 4 points and so on.
I found already IFS function but I stuck to finish the formula.

Small overview what we would like to reach

Field XY = 20
Field CB = 3
User changes CB to 4
Field XY = 19 (1to4 costs 1point)
User changes CB to 5 (5to 8 costs 2 points)
Field XY = 17

or

Field XY = 20
Field CB = 0
User changes CB to 8
Field XY = 8 (1-4 = 4 points + 5 to 8 = 8 points)

We dont need to block the possible to go into minus, that just would be the cherry on the cake

Have a nice evening, keep well and thanks for your help.