LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Calculation based on numbers of weeks service

Hi

I need a formula to calculate redundancy in on cell. The current
methodology is

for year 1 you receive 7 weeks pay

Between Year 2 an 10 you receive 4 weeks pay

Between year 11 and 16 year 3 weeks pay

from yr 17 to 25 2 weeks pay, capped at 25 years service.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Calculation to return number of weeks and days Lisa D Excel Worksheet Functions 8 December 30th 08 05:22 PM
# of weeks left based upon a date? ASI Excel Discussion (Misc queries) 5 November 14th 07 11:54 PM
return calculation every four weeks [email protected] Excel Discussion (Misc queries) 1 May 11th 06 12:15 PM
Years of Service Calculation JS Excel Worksheet Functions 2 April 24th 06 07:47 PM
Weeks of Supply Calculation Langrbj Excel Discussion (Misc queries) 4 March 12th 06 05:46 PM


All times are GMT +1. The time now is 07:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"