Re: 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
dguillett1@xxxxxxxxxxxxx
"James D. Sheehan" <jim@displayname@discussions.microsoft.com> wrote in
message news:249460B2-8B9C-4B2A-8397-14DC62D24FBC@xxxxxxxxxxxxxxxx
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
dguillett1@xxxxxxxxxxxxx
"James D. Sheehan" <jim@displayname@discussions.microsoft.com> wrote in
message news:36719621-9D9A-4FC5-AEA9-1AF78E44ECF6@xxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: Excel Programming - Formula Assistance
    ... Don Guillett ... Microsoft MVP Excel ... salary amount. ... Then just tell me what lane this is in the schedule. ...
    (microsoft.public.excel.misc)
  • Re: Excel Programming - Formula Assistance
    ... What is the criteria to determine the lane? ... Microsoft MVP Excel ... for this schedule amount so that the employee is placed correctly at either ... the exact amount or the amount slightly greater. ...
    (microsoft.public.excel.misc)
  • Re: interesting article on quantum cryptography
    ... Get your most smoothing revelation concerning my schedule. ... Georgette, still ... begining, adds almost about, as the lane cheers off their retreat. ...
    (sci.crypt)
  • They did it again!
    ... taking into account the amount of work ... rather I intend to suggest that if for whatever reason it is not ... official publication schedule. ... strictly regular schedule, so long as you retain ftp access to the ...
    (rec.games.roguelike.angband)
  • Re: $40 Billion for US highways in 2008, not exactly out of money
    ... lane. ... someone else's schedule every day and eliminates the time it takes to drive ... Shits his pants all over your nice leather seats? ...
    (misc.transport.road)