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.

Formula for Cell Calculations
 

=J44*MEDIAN(100%,K44,175%)
--
David Biddulph

"Rick A" <Rick wrote in message
...
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.