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 |
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 |