Home |
Search |
Today's Posts |
#1
|
|||
|
|||
<
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. |
#2
|
|||
|
|||
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" schrieb im Newsbeitrag ... 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. |
#3
|
|||
|
|||
yes sir, I did try yours first. The problem is:
I do not want 2 separate worksheets, just 1. Wife and I followed your instructions, and got window outlining full formula in black. I do appericate any help from you, but I (a rookie) had no luck. Does this new letter make better sense? Again, thank you and hope I hear from you again. On Fri, 12 Nov 2004 17:02:16 +0100, "Frank Kabel" wrote: 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 :-)) |
#4
|
|||
|
|||
Hi
you could of course put this lookup table on the same worksheet. If you like email me a test file and I'll insert it for you :-) email: frank[dot]kabel[at]freenet[dot]de -- Regards Frank Kabel Frankfurt, Germany "Scooterdog" schrieb im Newsbeitrag ... yes sir, I did try yours first. The problem is: I do not want 2 separate worksheets, just 1. Wife and I followed your instructions, and got window outlining full formula in black. I do appericate any help from you, but I (a rookie) had no luck. Does this new letter make better sense? Again, thank you and hope I hear from you again. On Fri, 12 Nov 2004 17:02:16 +0100, "Frank Kabel" wrote: 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 :-)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|