Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Cell Calculations
G44 I44 J44 K44
L44 Revenue Total Revenue Quota At Risk $ % of Quota Commissions $1,937.00 $675.00 $1,100.00 286.96% $1,925.00 I need to calculate the data for Commissions: Formula to check If "K44" is less than, or equal to 100%, then "L44" is equal to "J44". If "K44 is greater than 100%, but less than 175%, then "L44" is equal to "J44" times "K44". If "K44" is greater than 175%, then "L44" will always a MAXIMUM of "J44" times 175% Short explanation: Salesperson gets the At Risk amount for anything 100% of quota, or less. They can make extra commissions, but NOT TO EXCEED 175% of the AT Risk Amount. The Quota and At Risk amounts change monthly. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Cell Calculations
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Calculations in a Formula | Excel Discussion (Misc queries) | |||
I need a formula to do some calculations with time. | Excel Worksheet Functions | |||
Calculations Using the =IF formula | Excel Worksheet Functions | |||
Countif Formula with 2 calculations | Excel Discussion (Misc queries) | |||
Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions |