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?

See response in worksheet functions


--
HTH

Bob

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

"Pasty" <(E-Mail Removed)> wrote in message
news:85D1D430-A199-4082-ADAD-(E-Mail Removed)...
> 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?