Re: Excel Programming - Formula Assistance

Send your file to my address below NOT to an attachment here.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"James D. Sheehan" <jim@displayname@discussions.microsoft.com> wrote in message news:8CCAD2DA-6174-488A-BA29-FD1A2C3580F9@xxxxxxxxxxxxxxxx
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
>>
>>



.