if formula
 

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!


--
hmz
Wash DC
--
hmz
Wash DC

if formula
 

Hi,

See the answer on your other post.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"hmz" wrote:

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!


--
hmz
Wash DC
--
hmz
Wash DC