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