Forum Discussion
AlexCertificati
7 years agoQrew Cadet
Well, it will. The If function stops once a condition is met. So, say..
IF([Penny Saved]<>[Penny Earned],FALSE,
[Pope]="Catholic",TRUE,
[Water]="Wet",FALSE,
FALSE)
the first condition is not met
the second condition is met, so the checkbox is checked
and it stops there - the third condition is not evaluated
So if you want your formula to stop working once the checkbox is checked, order your conditions such that all the cases in which it's checked are evaluated first, and once a condition to check the checkbox is satisfied, your formula has done its job and will stop.
Does this answer your question?
IF([Penny Saved]<>[Penny Earned],FALSE,
[Pope]="Catholic",TRUE,
[Water]="Wet",FALSE,
FALSE)
the first condition is not met
the second condition is met, so the checkbox is checked
and it stops there - the third condition is not evaluated
So if you want your formula to stop working once the checkbox is checked, order your conditions such that all the cases in which it's checked are evaluated first, and once a condition to check the checkbox is satisfied, your formula has done its job and will stop.
Does this answer your question?