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

1. ## 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  Register To Reply

2. ## Re: I have a sheet that i want to stop calculating a field after it has been calculated

ZOMG third edition. I'll give it a shot.

What is your desired output? Are you trying to prevent recalculation if skill1 changes?  Register To Reply

3. ## Re: I have a sheet that i want to stop calculating a field after it has been calculated

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

4. ## Re: I have a sheet that i want to stop calculating a field after it has been calculated

::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.  Register To Reply

5. ## Re: I have a sheet that i want to stop calculating a field after it has been calculated

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.  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 