| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If And/Or statement for comm calc criteria
This is to calculate a 2-part commission payment.
A1 Monthly Target = $1,000 A2 Performance % = 168% A3 Payout up to 100% (100% of target - $1,000) A4 Payout based of Performance % 100% up to 150% (2% of target for every % above 100% of plan up to 150% of plan - otherwise, even if performance is 200%, the commission is capped at 150% performance) I need a formula to calculate A4 - commission 100% up to 150% performance ================================================== = Results should be A1 - $1,000 / A2 - 168% / A3 - $1,000 / A4 - $1,000 A5 - $2,000 Total Commission -- Texas Wannano |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If And/Or statement for comm calc criteria
A3:
=A1*MIN(A2,1) A4: =2*(A21)*MIN(MOD(A2,1),0.5)*A1 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Wannano" wrote in message ... This is to calculate a 2-part commission payment. A1 Monthly Target = $1,000 A2 Performance % = 168% A3 Payout up to 100% (100% of target - $1,000) A4 Payout based of Performance % 100% up to 150% (2% of target for every % above 100% of plan up to 150% of plan - otherwise, even if performance is 200%, the commission is capped at 150% performance) I need a formula to calculate A4 - commission 100% up to 150% performance ================================================== = Results should be A1 - $1,000 / A2 - 168% / A3 - $1,000 / A4 - $1,000 A5 - $2,000 Total Commission -- Texas Wannano |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If And/Or statement for comm calc criteria
1 less function call for A4:
=2*(A21)*MIN(A2-1,0.5)*A1 -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "RagDyeR" wrote in message ... A3: =A1*MIN(A2,1) A4: =2*(A21)*MIN(MOD(A2,1),0.5)*A1 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Wannano" wrote in message ... This is to calculate a 2-part commission payment. A1 Monthly Target = $1,000 A2 Performance % = 168% A3 Payout up to 100% (100% of target - $1,000) A4 Payout based of Performance % 100% up to 150% (2% of target for every % above 100% of plan up to 150% of plan - otherwise, even if performance is 200%, the commission is capped at 150% performance) I need a formula to calculate A4 - commission 100% up to 150% performance ================================================== = Results should be A1 - $1,000 / A2 - 168% / A3 - $1,000 / A4 - $1,000 A5 - $2,000 Total Commission -- Texas Wannano |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If And/Or statement for comm calc criteria
That worked. Thanks!
-- Texas Wannano "RagDyeR" wrote: 1 less function call for A4: =2*(A21)*MIN(A2-1,0.5)*A1 -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "RagDyeR" wrote in message ... A3: =A1*MIN(A2,1) A4: =2*(A21)*MIN(MOD(A2,1),0.5)*A1 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Wannano" wrote in message ... This is to calculate a 2-part commission payment. A1 Monthly Target = $1,000 A2 Performance % = 168% A3 Payout up to 100% (100% of target - $1,000) A4 Payout based of Performance % 100% up to 150% (2% of target for every % above 100% of plan up to 150% of plan - otherwise, even if performance is 200%, the commission is capped at 150% performance) I need a formula to calculate A4 - commission 100% up to 150% performance ================================================== = Results should be A1 - $1,000 / A2 - 168% / A3 - $1,000 / A4 - $1,000 A5 - $2,000 Total Commission -- Texas Wannano |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If And/Or statement for comm calc criteria
You're welcome and appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Wannano" wrote in message ... That worked. Thanks! -- Texas Wannano "RagDyeR" wrote: 1 less function call for A4: =2*(A21)*MIN(A2-1,0.5)*A1 -- Regards, RD -------------------------------------------------------------------------- --------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------------- --------------------- "RagDyeR" wrote in message ... A3: =A1*MIN(A2,1) A4: =2*(A21)*MIN(MOD(A2,1),0.5)*A1 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Wannano" wrote in message ... This is to calculate a 2-part commission payment. A1 Monthly Target = $1,000 A2 Performance % = 168% A3 Payout up to 100% (100% of target - $1,000) A4 Payout based of Performance % 100% up to 150% (2% of target for every % above 100% of plan up to 150% of plan - otherwise, even if performance is 200%, the commission is capped at 150% performance) I need a formula to calculate A4 - commission 100% up to 150% performance ================================================== = Results should be A1 - $1,000 / A2 - 168% / A3 - $1,000 / A4 - $1,000 A5 - $2,000 Total Commission -- Texas Wannano |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| my ? is this problem=E11-backword commaBikes Madeupside down comm. | Excel Worksheet Functions | |||
| auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
| I have pop-up post-it notes on my excel sheets!! they are not comm | Excel Discussion (Misc queries) | |||
| How do I use a "check(ed) box" as a criteria in an "=if" statement | Excel Worksheet Functions | |||
| If Statement Criteria | Excel Worksheet Functions | |||
Linear Mode
