Hi

I need a formula to calculate redundancy in on cell. The current
methodology is

for year 1 you receive 7 weeks pay

Between Year 2 an 10 you receive 4 weeks pay

Between year 11 and 16 year 3 weeks pay

from yr 17 to 25 2 weeks pay, capped at 25 years service.