Re: <<Need Formula For Lookup With 2 Variables>>

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 11/12/04 

Date: Fri, 12 Nov 2004 17:02:16 +0100

Hi
you have already received two answers to your original thread. Have you
tried Aladin's or my suggestion?. If yes what does not work with them?

P.S.: always better to stay in the original thread and post a follow-up
:-)) 

--
Regards
Frank Kabel
Frankfurt, Germany
"Scooterdog" <jon-simek@hot.rr.com> schrieb im Newsbeitrag
news:m2m9p0pmlvof5vp6lm17f3a16qr7id5gd0@4ax.com...
> My job has 2 seperate pay scales.  Let me call 1 pay scale "c".
> The other pay scale called "b".
> My worksheet looks something like this:
> a b
> 1 b pay scale
> 2 55 car rate
> 3      $65.00 total pay
>
> I need a formula that will allow me to type in either "b" or "c"
> in cell a1 and in cell a2 type in a car rate like 55.
> Now, my car rate is in cells a18 to a22 on my worksheet.
> The higher the car rate, the more the pay.
> Example:
> If my pay scale is "b" and I handle from 0 to 80 cars,
> my total pay would be $65.00.  IF my pay scale is "b"
> and I handle from 81 to 105 cars, my total pay would
> be $75.00.
>
> Now, if my pay scale is "c" and I handle from 0 to 80 cars,
> my total pay would be $80.00. IF my pay scale is "c" and I
> handle 81 to 105 cars, my total pay would be $90.00.
> Thank you for your time and help.

Relevant Pages