Discussion Proper IF function - I can't figure this one out in Excel
https://techcommunity.microsoft.com/t5/excel/proper-if-function-i-can-t-figure-this-one-out/m-p/331120#M25113
<P>I am trying to figure out a revenue projection and I can't figure this one out. I collect a % of my sales person's commission but IF they reach $12,000 in commission paid I stop collecting the %</P><P> </P><P>I know I need the product of the commission x % but how do I say to use the actual total if it is under $12000 but to stop at $12,000 if the total exceeds $12,000?</P><P> </P><P>Thanks for the help, I'm stumped </P>Tue, 05 Feb 2019 16:42:49 GMTRobE5142019-02-05T16:42:49ZProper IF function - I can't figure this one out
https://techcommunity.microsoft.com/t5/excel/proper-if-function-i-can-t-figure-this-one-out/m-p/331120#M25113
<P>I am trying to figure out a revenue projection and I can't figure this one out. I collect a % of my sales person's commission but IF they reach $12,000 in commission paid I stop collecting the %</P><P> </P><P>I know I need the product of the commission x % but how do I say to use the actual total if it is under $12000 but to stop at $12,000 if the total exceeds $12,000?</P><P> </P><P>Thanks for the help, I'm stumped </P>Tue, 05 Feb 2019 16:42:49 GMThttps://techcommunity.microsoft.com/t5/excel/proper-if-function-i-can-t-figure-this-one-out/m-p/331120#M25113RobE5142019-02-05T16:42:49ZRe: Proper IF function - I can't figure this one out
https://techcommunity.microsoft.com/t5/excel/proper-if-function-i-can-t-figure-this-one-out/m-p/331143#M25116
<P>Does an If statement work here, such that if your commission > $12,000, take the original value?</P><P> </P><P>Here's a formula I put together in C2: =IF(A2*B2 > 12000, A2, A2+(A2*B2)) where I have the sale in A2 and a commission percentage in B2.</P><P> </P><P>If the total commission is > 12,000, then C2 is just the original sale without commission. If the total commission is < 12,000, then I add the original sale + commission amount (A2 * B2).</P>Tue, 05 Feb 2019 17:00:26 GMThttps://techcommunity.microsoft.com/t5/excel/proper-if-function-i-can-t-figure-this-one-out/m-p/331143#M25116MattHong2019-02-05T17:00:26ZRe: Proper IF function - I can't figure this one out
https://techcommunity.microsoft.com/t5/excel/proper-if-function-i-can-t-figure-this-one-out/m-p/331145#M25118
<P>Other words you'd like to pay MIN(12000, Sales*Percent), correct?</P>Tue, 05 Feb 2019 17:02:40 GMThttps://techcommunity.microsoft.com/t5/excel/proper-if-function-i-can-t-figure-this-one-out/m-p/331145#M25118Sergei Baklan2019-02-05T17:02:40ZRe: Proper IF function - I can't figure this one out
https://techcommunity.microsoft.com/t5/excel/proper-if-function-i-can-t-figure-this-one-out/m-p/331166#M25122
<BLOCKQUOTE><HR /><LI-USER uid="521"></LI-USER> wrote:<BR /><P>Other words you'd like to pay MIN(12000, Sales*Percent), correct?</P><P> </P><P>Actually, I want the maximum company split (take) to be 12,000 from each sales person</P><HR /></BLOCKQUOTE><P> </P>Tue, 05 Feb 2019 17:25:21 GMThttps://techcommunity.microsoft.com/t5/excel/proper-if-function-i-can-t-figure-this-one-out/m-p/331166#M25122RobE5142019-02-05T17:25:21ZRe: Proper IF function - I can't figure this one out
https://techcommunity.microsoft.com/t5/excel/proper-if-function-i-can-t-figure-this-one-out/m-p/331177#M25124
<P>I tried that but it did not work. Here's a screenshot. In the highlighted cell I am trying to take the $29700 x the company split (that's easy enough) but have it max out at $12,000. So, in the pic below, The commission is F26 and the company split is C37</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/72009i65E8CD3F8B364493/image-size/large?v=1.0&px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P>Tue, 05 Feb 2019 17:34:21 GMThttps://techcommunity.microsoft.com/t5/excel/proper-if-function-i-can-t-figure-this-one-out/m-p/331177#M25124RobE5142019-02-05T17:34:21Z