View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James D. Sheehan James D. Sheehan is offline
external usenet poster
 
Posts: 17
Default 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