Thread: if statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WaqB WaqB is offline
external usenet poster
 
Posts: 7
Default if statements

I am trying to find a formula/function that will calculate redundancy pay
using the following criteria

Up to 10 years service, 1 month pay per years service.

After 10 years, 1.25 months pay per years service.

After 15 years, 1.5 months pay per years service

Therefore if an individual has 20 years service the firstt 9.99 years would
receive 1 months pay per years service years 10 to 15 would receive 1.25
months pay per years service and 15+ would receive 1.5 months pay per years
service

I hope somenone can help