I need a formula to calculate redundancy payments in a table. The redundancy
payment due to each employee depends on his or her age and length of service
(up to twenty years). This determines the number of weeks pay due. I want to
calculate, automatically, the number of weeks pay due.

To calculate the number of weeks pay due, one should use the following
amounts €“

0.5 week's pay for each full year of service where age during year less than
22
1.0 week's pay for each full year of service where age during year is 22 or
above, but less than 41

(I have, within the spreadsheet I am using, a cell which already has
calculated the age - can you, in the answer, use A1 to refer to this cell,
thanks).
1.5 weeks' pay for each full year of service where age during year is 41+
I believe this can be done, by a single cell formula using if, greater than,
less than etc., but I cant get beyond stage 1! I would then multiply the
calculated figure (number of weeks pay due) against the number of years
service.