I am trying to get a formula to quit calculating after another cell has been changed.

=IF($AL$2>=BF21,AH19,"")

=IF($AL$2>=BF22,AH19,"")

$AL$2 is the cell I change that number is equal to the BF21 or BF22 (the BF column is where my list is for a number dropdown).

When I change the cell to equal the next number in the list. I want the previous formula(=IF($AL$2>=BF21,AH19,"")to quit calculating and give me the number(AH19) it calculated before I changed the number ($AL$2) from 1 to 2

AH19 is a formula that can change by adding a number to its' base.

This is for a role playing game character sheet I am developing.

Thanks in advance

## Bookmarks