Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|