Hi,

I'm not sure I understand, it seems to me that you need to know the age when
they started and there current age. And you need to assume that there were
no breaks in service. The only thing we know is their age, in cell A1.

That doesn't help because they may be 45 and they may have started when they
were 44. So we need to know their start date so we can calculate their years
of service.

What about rehires?

I don't believe it is possible to answer this without that info.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Red_Goldfish" wrote:

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.