K
kimkay
I need help with a formula to return a value based on a range of numbers, ie:
Cell C3 will contain the number of years an employee has worked for a
company; cell D3 needs to show the number of leave days that employee is
entitled to based on their years of employment. If the employee has worked
0-2 years, leave is 10 days, 2-6 years equals 15 days, 7-14 years = 20 days,
15-24 years = 25 days, and from 25 years up is a flat 30 days of leave. I've
tried several nested if/then statement variations and can't get it to return
all numbers correctly. My programming skills are rudimentary, but I'm a good
copier if someone can help me!
The ranges would actually need to be in decimals, as in 0 - 1.99, 2.00 -
6.99, 7.00 - 14.99, etc.
Any help would be greatly appreciated! The spreadsheet would look like the
following example. Thanks in advance...
Hire Date Tenure in Years Leave Days
5/21/2007 0.07
5/15/2006 1.10
5/15/2003 4.14
Cell C3 will contain the number of years an employee has worked for a
company; cell D3 needs to show the number of leave days that employee is
entitled to based on their years of employment. If the employee has worked
0-2 years, leave is 10 days, 2-6 years equals 15 days, 7-14 years = 20 days,
15-24 years = 25 days, and from 25 years up is a flat 30 days of leave. I've
tried several nested if/then statement variations and can't get it to return
all numbers correctly. My programming skills are rudimentary, but I'm a good
copier if someone can help me!
The ranges would actually need to be in decimals, as in 0 - 1.99, 2.00 -
6.99, 7.00 - 14.99, etc.
Any help would be greatly appreciated! The spreadsheet would look like the
following example. Thanks in advance...
Hire Date Tenure in Years Leave Days
5/21/2007 0.07
5/15/2006 1.10
5/15/2003 4.14