Craigc3814
Board Regular
- Joined
- Mar 7, 2016
- Messages
- 217
Seniority Range Low High Score
0-2 0 1.99 1
3-4 2 3.99 2
4-8 4 7.99 3
8-12 8 11.99 4
12-16 12 15.99 5
16-20 16 19.99 6
20-24 20 23.99 7
24-28 24 27.99 8
28-32 28 31.99 9
32-36 32 100 10
I have the above table, On another sheet I have a seniority number we will use 9.01 for example. If Someone has worked here 9 years I want the value of 4 returned. I was going to do this with nested if(and but didn't realize there was a limit of 7 nested ifs. How can I get around that? I feel like it should be easier than I am making it.
0-2 0 1.99 1
3-4 2 3.99 2
4-8 4 7.99 3
8-12 8 11.99 4
12-16 12 15.99 5
16-20 16 19.99 6
20-24 20 23.99 7
24-28 24 27.99 8
28-32 28 31.99 9
32-36 32 100 10
I have the above table, On another sheet I have a seniority number we will use 9.01 for example. If Someone has worked here 9 years I want the value of 4 returned. I was going to do this with nested if(and but didn't realize there was a limit of 7 nested ifs. How can I get around that? I feel like it should be easier than I am making it.