View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pasty Pasty is offline
external usenet poster
 
Posts: 95
Default 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?