| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Programming - Formula Assistance
I have a salary schedule that begins with $40,000 and has 40 steps down each
with in increase of $1,000 and 19 lanes wide each with an increase of $2,000. So the schedule is ascending down and to the right. I am given a salary amount and the step the individual should be placed on. I must find the appropriate lane so that the individual would not lose salary. I believe this must be done with a MATCH and HLOOKUP but I cannot figure it out. Any help will be greatly appreciated. Thank you. -- James D. Sheehan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Programming - Formula Assistance
I'm confused..........if you are given the salary, and the table contains
only salaries in steps, what information are you trying to retrieve? Vaya con Dios, Chuck, CABGx3 "James D. Sheehan" wrote: I have a salary schedule that begins with $40,000 and has 40 steps down each with in increase of $1,000 and 19 lanes wide each with an increase of $2,000. So the schedule is ascending down and to the right. I am given a salary amount and the step the individual should be placed on. I must find the appropriate lane so that the individual would not lose salary. I believe this must be done with a MATCH and HLOOKUP but I cannot figure it out. Any help will be greatly appreciated. Thank you. -- James D. Sheehan |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Programming - Formula Assistance
We know who, salary amount, and step but we don't know "LANE"?
-- Don Guillett Microsoft MVP Excel SalesAid Software "James D. Sheehan" wrote in message ... I have a salary schedule that begins with $40,000 and has 40 steps down each with in increase of $1,000 and 19 lanes wide each with an increase of $2,000. So the schedule is ascending down and to the right. I am given a salary amount and the step the individual should be placed on. I must find the appropriate lane so that the individual would not lose salary. I believe this must be done with a MATCH and HLOOKUP but I cannot figure it out. Any help will be greatly appreciated. Thank you. -- James D. Sheehan |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Programming - Formula Assistance
I need to find the appropriate salary schedule lane. I know the salary
amount and the step placement...and I need to find the lane. -- James D. Sheehan "CLR" wrote: I'm confused..........if you are given the salary, and the table contains only salaries in steps, what information are you trying to retrieve? Vaya con Dios, Chuck, CABGx3 "James D. Sheehan" wrote: I have a salary schedule that begins with $40,000 and has 40 steps down each with in increase of $1,000 and 19 lanes wide each with an increase of $2,000. So the schedule is ascending down and to the right. I am given a salary amount and the step the individual should be placed on. I must find the appropriate lane so that the individual would not lose salary. I believe this must be done with a MATCH and HLOOKUP but I cannot figure it out. Any help will be greatly appreciated. Thank you. -- James D. Sheehan |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Programming - Formula Assistance
The question is:
What is the criteria to determine the lane? -- Don Guillett Microsoft MVP Excel SalesAid Software "James D. Sheehan" wrote in message ... We know the amount and we know the step placement...now we must find the lane for this schedule amount so that the employee is placed correctly at either the exact amount or the amount slightly greater. -- James D. Sheehan "Don Guillett" wrote: We know who, salary amount, and step but we don't know "LANE"? -- Don Guillett Microsoft MVP Excel SalesAid Software "James D. Sheehan" wrote in message ... I have a salary schedule that begins with $40,000 and has 40 steps down each with in increase of $1,000 and 19 lanes wide each with an increase of $2,000. So the schedule is ascending down and to the right. I am given a salary amount and the step the individual should be placed on. I must find the appropriate lane so that the individual would not lose salary. I believe this must be done with a MATCH and HLOOKUP but I cannot figure it out. Any help will be greatly appreciated. Thank you. -- James D. Sheehan |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Programming - Formula Assistance
The criteria to determine the lane is... Given the step and the amount...go
across a schedule on the step until you find an amount = to or than the salary amount. Then just tell me what lane this is in the schedule. Is there a way to post an excel file that portrays this problem? -- James D. Sheehan "Don Guillett" wrote: The question is: What is the criteria to determine the lane? -- Don Guillett Microsoft MVP Excel SalesAid Software "James D. Sheehan" wrote in message ... We know the amount and we know the step placement...now we must find the lane for this schedule amount so that the employee is placed correctly at either the exact amount or the amount slightly greater. -- James D. Sheehan "Don Guillett" wrote: We know who, salary amount, and step but we don't know "LANE"? -- Don Guillett Microsoft MVP Excel SalesAid Software "James D. Sheehan" wrote in message ... I have a salary schedule that begins with $40,000 and has 40 steps down each with in increase of $1,000 and 19 lanes wide each with an increase of $2,000. So the schedule is ascending down and to the right. I am given a salary amount and the step the individual should be placed on. I must find the appropriate lane so that the individual would not lose salary. I believe this must be done with a MATCH and HLOOKUP but I cannot figure it out. Any help will be greatly appreciated. Thank you. -- James D. Sheehan |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Programming - Formula Assistance
Send your file to my address below NOT to an attachment here.
-- Don Guillett Microsoft MVP Excel SalesAid Software "James D. Sheehan" wrote in message ... The criteria to determine the lane is... Given the step and the amount...go across a schedule on the step until you find an amount = to or than the salary amount. Then just tell me what lane this is in the schedule. Is there a way to post an excel file that portrays this problem? -- James D. Sheehan "Don Guillett" wrote: The question is: What is the criteria to determine the lane? -- Don Guillett Microsoft MVP Excel SalesAid Software "James D. Sheehan" wrote in message ... We know the amount and we know the step placement...now we must find the lane for this schedule amount so that the employee is placed correctly at either the exact amount or the amount slightly greater. -- James D. Sheehan "Don Guillett" wrote: We know who, salary amount, and step but we don't know "LANE"? -- Don Guillett Microsoft MVP Excel SalesAid Software "James D. Sheehan" wrote in message ... I have a salary schedule that begins with $40,000 and has 40 steps down each with in increase of $1,000 and 19 lanes wide each with an increase of $2,000. So the schedule is ascending down and to the right. I am given a salary amount and the step the individual should be placed on. I must find the appropriate lane so that the individual would not lose salary. I believe this must be done with a MATCH and HLOOKUP but I cannot figure it out. Any help will be greatly appreciated. Thank you. -- James D. Sheehan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| programming assistance | Excel Discussion (Misc queries) | |||
| How can I get assistance on Excel Formula? | Excel Worksheet Functions | |||
| I was looking to get assistance with a formula in Excel 2002 | Excel Worksheet Functions | |||
| need assistance setting up formula in excel for number x 15%? | Excel Discussion (Misc queries) | |||
| I need assistance with wrting an Excel formula | Excel Worksheet Functions | |||
Linear Mode
