Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with IF Statement
I am wanting to create a statement that will look at the employees number of
years that they are working, and then look at their grade level, and then determine the number of vacation days they are warranted. I have tried the basic =IF(AND(C16<=9, T16=1), "10", "0")+IF(AND.... but that statet gets too long with more than 47 +IF statements which are not allowed. Need if I have included an example chart. Length of Service Grades 1-9 Grades 10-15 Grades 16+ At least 1 but < 2 years 10 days 15 days 20 days At least 2 but < 3 years 12 days 16 days 20 days At least 3 but < 5 years 13 days 17 days 20 days At least 5 but < 7 years 15 days 18 days 20 days At least 7 but < 10 years 17 days 19 days 20 days 10 years or more 20 days 20 days 20 days Basically if they are a grade 11 with 7 years of service, I want it to say 19. For a Grade 14 with 5 years of service, to say 18 days. I can do the less than 9 years, but can't figure out to check grades 10-15, and 3-4 years. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions |