I am looking for an IF formula for...number of severance weeks based on salary grade level...for example:
IF grade level 21-25 receives 10 weeks of severance @ [amount] (based on individual salary)
IF grade level 26-27 receives 12 weeksof severance @ [amount] (based on individual salary)
IF...