R
Rick A
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.
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.