Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Calculation to return number of weeks and days | Excel Worksheet Functions | |||
# of weeks left based upon a date? | Excel Discussion (Misc queries) | |||
return calculation every four weeks | Excel Discussion (Misc queries) | |||
Years of Service Calculation | Excel Worksheet Functions | |||
Weeks of Supply Calculation | Excel Discussion (Misc queries) |