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 0 Years worked: 20, 5, and 17 please help! Thanks!