Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |