I have a sheet that i want to stop calculating a field after it has been calculated

Hi there, my sheet is Calculating the BE column =IF(Chr.lvl<BF21,"",Skill1*4) if skill1 changes, it calculates previous cells. if your Intelligence modifier goes up it calcs it as it goes. you can't learn something new from the fourth grade when you have already graduated from high school.
Any other suggestions would be greatly appreciated

yes. you get ability points every 4 levels if you put them into INT then it goes up every 8 levels

::cough cough:: You could always use the 3.5 Variant Rule where it applies retroactively ::cough min/maxing cough::

Otherwise, this is tough. I'm thinking a circular reference, possibly in conjunction with a hidden timestamp. I'll research it further.

Okay, I rolled a 1 on my Excel (Int) check after a few hundred tries.

Turn on circular references under Options -> Formulas -> Enable Iterations


For BE21:
=IF(BE21<>"",IF(CHR.lvl>=BF21,Skill1*4,""),"")

For BE22 and onwards:
=IF(BE22<>"",IF(CHR.lvl>=BF22,Skill1,""),"")

With the circular reference and iterative calculations turned on, the formula will check if the cell itself is blank, and if it isn't it will update. This will prevent values from changing once they already have skill points assigned for those levels.

I'm giving myself 500 xp.