Thread
:
Formula for Cell Calculations
View Single Post
#
2
Posted to microsoft.public.excel.misc
David Biddulph[_2_]
external usenet poster
Posts: 8,651
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.
Reply With Quote
David Biddulph[_2_]
View Public Profile
Find all posts by David Biddulph[_2_]