Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bonus Calculation
I have a spreadsheet where I would like to pay a bonus based on hours worked.
A B C D E F G H 1 Limits Bonus Rate Hours Amount 2 0 ‰¤ 20 0% $20 17 $ 3 20 ‰¤ 40 5% $20 23 $ 4 40 10% $20 23 $ A2 to D4 is the limits to be applied. The limits can be changed. E2 to E4 is the percentage bonus. The percentage can be changed. F2 to F4 is the hourly rate. G2 to G4 are the hours worked Require the spreadsheet to calculate the amount based on applied limits. Many thanks for any assistance that you can provide. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bonus Calculation
If you change row 4 to
, 40,blank,blank,10% you can use =F2*G2*INDEX($E$2:$E$4,MATCH(G2,$B$2:$B$4)) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "zephyr" wrote in message ... I have a spreadsheet where I would like to pay a bonus based on hours worked. A B C D E F G H 1 Limits Bonus Rate Hours Amount 2 0 ? 20 0% $20 17 $ 3 20 ? 40 5% $20 23 $ 4 40 10% $20 23 $ A2 to D4 is the limits to be applied. The limits can be changed. E2 to E4 is the percentage bonus. The percentage can be changed. F2 to F4 is the hourly rate. G2 to G4 are the hours worked Require the spreadsheet to calculate the amount based on applied limits. Many thanks for any assistance that you can provide. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bonus Calculation
Hi
B2:B4 needs to be 0, 20, 40 C2:D4 are superfluous in H2 =G2*F2*(1+VLOOKUP(G2,$B$2:$E$4,4)) -- Regards Roger Govier "zephyr" wrote in message ... I have a spreadsheet where I would like to pay a bonus based on hours worked. A B C D E F G H 1 Limits Bonus Rate Hours Amount 2 0 ? 20 0% $20 17 $ 3 20 ? 40 5% $20 23 $ 4 40 10% $20 23 $ A2 to D4 is the limits to be applied. The limits can be changed. E2 to E4 is the percentage bonus. The percentage can be changed. F2 to F4 is the hourly rate. G2 to G4 are the hours worked Require the spreadsheet to calculate the amount based on applied limits. Many thanks for any assistance that you can provide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
Formula to figure bonus | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |