I'm trying to make a quick reference sheet for a TTRPG campaign, and I'm trying to create a section of the sheet that will account for leveling up, and by extension, skill points. Since I will not know how the players wish to split skill points, I need a cell equation for inputting x number of points out of y and then adding that input to the appropriate skill. I have that part figured out I believe, but I'm trying to find a way to keep using the cell for various inputs and outputs. Is there some type of "clear cell" function built into numbers or some type of 'for loop' function I could use?
I have been trying to find an answer but all that shows up is just how to clear a cell using the delete key.
