Calculating pensions rate
 

Salary DOB Age Date Date of employment 7.5% 10%


Hi there I have the above headings (Columns a-g) what I need it to do is
when employees are over 41 their pension increases to 10% rather than 7.5% so
what it needs to do is give a number in 7.5% for how long they've been in
employment and below 41 years old and how long they've been in employment and
41 and above.

Can anyone help?

Calculating pensions rate
 

See response in worksheet functions


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Pasty" wrote in message
...
Salary DOB Age Date Date of employment 7.5% 10%


Hi there I have the above headings (Columns a-g) what I need it to do is
when employees are over 41 their pension increases to 10% rather than 7.5%
so
what it needs to do is give a number in 7.5% for how long they've been in
employment and below 41 years old and how long they've been in employment
and
41 and above.

Can anyone help?