Does anyone know how to get excel to return a formula result only within specified minimum and maximum values?
That is, I want Excel to calculate a series of % to hit chances, based on reference cells for to hit bonus and AC; but the values returned should have a minimum of 0.05 and a maximum of 0.95.
Thanks!
That is, I want Excel to calculate a series of % to hit chances, based on reference cells for to hit bonus and AC; but the values returned should have a minimum of 0.05 and a maximum of 0.95.
Thanks!