| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and Then Formula Help Needed Please
I need some assistance. Here's what I'm trying to do:
I have a column with years of service for all our employees, say it's column D. Column E needs to say what their accural rate for vacation time is depending on their length of service. So if the years of service is less than 3, accural is 4.62. If it's between 3 and 7 years, accural rate is 5.54. If it's between 7 and 14 years, accural rate is 6.46. If years of service are greater then 14, accural rate is 7.39. Here's what I have, but it's not working: IF(D3<3,4.62),IF(3.1<D3<7,5.54),IF(7.1<D3<14,6.46) ,IF(14.1<D3,7.39) Please help. Thank you, Dimple |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF and Then Formula Help Needed Please
=IF(D3="","",LOOKUP(D3,{0,3,7,14},{4.62,5.54,6.46, 7.39}))
"Dimple" wrote: I need some assistance. Here's what I'm trying to do: I have a column with years of service for all our employees, say it's column D. Column E needs to say what their accural rate for vacation time is depending on their length of service. So if the years of service is less than 3, accural is 4.62. If it's between 3 and 7 years, accural rate is 5.54. If it's between 7 and 14 years, accural rate is 6.46. If years of service are greater then 14, accural rate is 7.39. Here's what I have, but it's not working: IF(D3<3,4.62),IF(3.1<D3<7,5.54),IF(7.1<D3<14,6.46) ,IF(14.1<D3,7.39) Please help. Thank you, Dimple |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF and Then Formula Help Needed Please
First, Thank you for responding. But I'm not quite sure what the "" are
suppose to mean. I tried entering this as is and nothing came up. "Teethless mama" wrote: =IF(D3="","",LOOKUP(D3,{0,3,7,14},{4.62,5.54,6.46, 7.39})) "Dimple" wrote: I need some assistance. Here's what I'm trying to do: I have a column with years of service for all our employees, say it's column D. Column E needs to say what their accural rate for vacation time is depending on their length of service. So if the years of service is less than 3, accural is 4.62. If it's between 3 and 7 years, accural rate is 5.54. If it's between 7 and 14 years, accural rate is 6.46. If years of service are greater then 14, accural rate is 7.39. Here's what I have, but it's not working: IF(D3<3,4.62),IF(3.1<D3<7,5.54),IF(7.1<D3<14,6.46) ,IF(14.1<D3,7.39) Please help. Thank you, Dimple |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF and Then Formula Help Needed Please
"" is also known as double quotes. It just means blank cell, null, no data,
etc. You are saying, if the cell is blank, return a blank, otherwise do the Lookup operation, which assigns the criteria in the first set of curly brackets to the criteria in the second set of curly brackets. Just try a few different scenarios and see the the results are. I think you will figure it out pretty quickly. Regards, Ryan-- -- RyGuy "Dimple" wrote: First, Thank you for responding. But I'm not quite sure what the "" are suppose to mean. I tried entering this as is and nothing came up. "Teethless mama" wrote: =IF(D3="","",LOOKUP(D3,{0,3,7,14},{4.62,5.54,6.46, 7.39})) "Dimple" wrote: I need some assistance. Here's what I'm trying to do: I have a column with years of service for all our employees, say it's column D. Column E needs to say what their accural rate for vacation time is depending on their length of service. So if the years of service is less than 3, accural is 4.62. If it's between 3 and 7 years, accural rate is 5.54. If it's between 7 and 14 years, accural rate is 6.46. If years of service are greater then 14, accural rate is 7.39. Here's what I have, but it's not working: IF(D3<3,4.62),IF(3.1<D3<7,5.54),IF(7.1<D3<14,6.46) ,IF(14.1<D3,7.39) Please help. Thank you, Dimple |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF and Then Formula Help Needed Please
"" is an empty string, and the first part of the formula is saying that if
D3 is empty, the result is empty. Without that you can get problems with the lookup if you put an empty string as the input to the lookup function. What do you mean by "nothing came up"? Have you pasted the formula directly from the NG into your formula bar, or have you mistyped it? What number do you have in D3 and what result does your formula give? -- David Biddulph "Dimple" wrote in message ... First, Thank you for responding. But I'm not quite sure what the "" are suppose to mean. I tried entering this as is and nothing came up. "Teethless mama" wrote: =IF(D3="","",LOOKUP(D3,{0,3,7,14},{4.62,5.54,6.46, 7.39})) "Dimple" wrote: I need some assistance. Here's what I'm trying to do: I have a column with years of service for all our employees, say it's column D. Column E needs to say what their accural rate for vacation time is depending on their length of service. So if the years of service is less than 3, accural is 4.62. If it's between 3 and 7 years, accural rate is 5.54. If it's between 7 and 14 years, accural rate is 6.46. If years of service are greater then 14, accural rate is 7.39. Here's what I have, but it's not working: IF(D3<3,4.62),IF(3.1<D3<7,5.54),IF(7.1<D3<14,6.46) ,IF(14.1<D3,7.39) Please help. Thank you, Dimple |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF and Then Formula Help Needed Please
Thank you so much. I had just tried it to the one scenario I shouldn't have.
I applied to the correct info and it worked beautifully!! Thanks so much!! Dimple "David Biddulph" wrote: "" is an empty string, and the first part of the formula is saying that if D3 is empty, the result is empty. Without that you can get problems with the lookup if you put an empty string as the input to the lookup function. What do you mean by "nothing came up"? Have you pasted the formula directly from the NG into your formula bar, or have you mistyped it? What number do you have in D3 and what result does your formula give? -- David Biddulph "Dimple" wrote in message ... First, Thank you for responding. But I'm not quite sure what the "" are suppose to mean. I tried entering this as is and nothing came up. "Teethless mama" wrote: =IF(D3="","",LOOKUP(D3,{0,3,7,14},{4.62,5.54,6.46, 7.39})) "Dimple" wrote: I need some assistance. Here's what I'm trying to do: I have a column with years of service for all our employees, say it's column D. Column E needs to say what their accural rate for vacation time is depending on their length of service. So if the years of service is less than 3, accural is 4.62. If it's between 3 and 7 years, accural rate is 5.54. If it's between 7 and 14 years, accural rate is 6.46. If years of service are greater then 14, accural rate is 7.39. Here's what I have, but it's not working: IF(D3<3,4.62),IF(3.1<D3<7,5.54),IF(7.1<D3<14,6.46) ,IF(14.1<D3,7.39) Please help. Thank you, Dimple |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA NEEDED | Excel Worksheet Functions | |||
| Formula Needed | Excel Discussion (Misc queries) | |||
| IF-THEN Formula help needed | Excel Worksheet Functions | |||
| Formula needed | Excel Discussion (Misc queries) | |||
| formula needed | New Users to Excel | |||
Hybrid Mode
