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.