H
hmz
Hi,
I am having trouble writing a formula for the following:
Severance Plan:
12 Weeks of base pay, plus an additional 1 week of base pay for every year
worked service more than 10 years of service, to maximum of 18 weeks in
total.
So, in other words, if someone has worked over 10 years, say it is 22 years,
then they would be entitled to at least a total of 18 weeks (12+6 weeks).
My problem is writing a formula that captures all three "or" outcomes of (1)
under 10 years (2) (or) over 10 years but under Max amount of 18 (3) over the
18 weeks.
So, I am looking for something to say,
Salary: 25,000 weekly $480
Years worked: 20, 5, and 17
please help! Thanks!
I am having trouble writing a formula for the following:
Severance Plan:
12 Weeks of base pay, plus an additional 1 week of base pay for every year
worked service more than 10 years of service, to maximum of 18 weeks in
total.
So, in other words, if someone has worked over 10 years, say it is 22 years,
then they would be entitled to at least a total of 18 weeks (12+6 weeks).
My problem is writing a formula that captures all three "or" outcomes of (1)
under 10 years (2) (or) over 10 years but under Max amount of 18 (3) over the
18 weeks.
So, I am looking for something to say,
Salary: 25,000 weekly $480
Years worked: 20, 5, and 17
please help! Thanks!