software

I guess I haven't explained my first questions very well. The answer
will vary depending on what amount the formula is being calculated
against. The answer will not always be same. I need to have a formula
that calculates commission on the first $1500 and not any additional
money on anything over $1500. So if a person raises $1300. The
percentage is .034 - the commission would be $44.20.

If a person raises 1500. the percentage is still .034 the commission
would be $51.00.

If the person raises 1600, the percentage is .034 for the first $1500
and the commission is still $51.00 because he doesn't get paid on the
extra $100 over

I need a formula that calcuates commission of the first $1500 and not
any additional money on anything over $1500.--
Sharon D.
------------------------------------------------------------------------
Sharon D.'s Profile: www.excelforum.com/member.php...oamp;userid=29841
View this thread: www.excelforum.com/showthread...hreadid=495492
Something like

=IF(A1gt;1500,1500,A1)*0.034--
y_not
------------------------------------------------------------------------
y_not's Profile: www.excelforum.com/member.php...oamp;userid=19947
View this thread: www.excelforum.com/showthread...hreadid=495492One way:

=0.034*MIN(A1,1500)

In article gt;,
Sharon D. gt;
wrote:

gt; I guess I haven't explained my first questions very well. The answer
gt; will vary depending on what amount the formula is being calculated
gt; against. The answer will not always be same. I need to have a formula
gt; that calculates commission on the first $1500 and not any additional
gt; money on anything over $1500. So if a person raises $1300. The
gt; percentage is .034 - the commission would be $44.20.
gt;
gt; If a person raises 1500. the percentage is still .034 the commission
gt; would be $51.00.
gt;
gt; If the person raises 1600, the percentage is .034 for the first $1500
gt; and the commission is still $51.00 because he doesn't get paid on the
gt; extra $100 over
gt;
gt; I need a formula that calcuates commission of the first $1500 and not
gt; any additional money on anything over $1500.

=min(1500,a3)*.034

hth

quot;Sharon D.quot; wrote:

gt;
gt; I guess I haven't explained my first questions very well. The answer
gt; will vary depending on what amount the formula is being calculated
gt; against. The answer will not always be same. I need to have a formula
gt; that calculates commission on the first $1500 and not any additional
gt; money on anything over $1500. So if a person raises $1300. The
gt; percentage is .034 - the commission would be $44.20.
gt;
gt; If a person raises 1500. the percentage is still .034 the commission
gt; would be $51.00.
gt;
gt; If the person raises 1600, the percentage is .034 for the first $1500
gt; and the commission is still $51.00 because he doesn't get paid on the
gt; extra $100 over
gt;
gt; I need a formula that calcuates commission of the first $1500 and not
gt; any additional money on anything over $1500.
gt;
gt;
gt; --
gt; Sharon D.
gt; ------------------------------------------------------------------------
gt; Sharon D.'s Profile: www.excelforum.com/member.php...oamp;userid=29841
gt; View this thread: www.excelforum.com/showthread...hreadid=495492
gt;
gt;

....The IF formula below is the only thing that will work. the quot;MINquot; formulas
mentioned will hold the sales value at 1500.

quot;y_notquot; wrote:

gt;
gt; Something like
gt;
gt; =IF(A1gt;1500,1500,A1)*0.034
gt;
gt;
gt; --
gt; y_not
gt; ------------------------------------------------------------------------
gt; y_not's Profile: www.excelforum.com/member.php...oamp;userid=19947
gt; View this thread: www.excelforum.com/showthread...hreadid=495492
gt;
gt;

Huh?

The IF and MIN formulae return exactly the same results. Did you try
them?

In article gt;,
quot;JRquot; gt; wrote:

gt; ...The IF formula below is the only thing that will work. the quot;MINquot; formulas
gt; mentioned will hold the sales value at 1500.

On Thu, 22 Dec 2005 07:39:02 -0800, quot;JRquot; gt; wrote:

gt;...The IF formula below is the only thing that will work. the quot;MINquot; formulas
gt;mentioned will hold the sales value at 1500.

Why do you write that?

The MIN formula will return the lesser of the sales value or 1500, which is
what the OP wrote she wanted.
--ron

quot;JRquot; gt; wrote in message
...

gt; quot;y_notquot; wrote:
gt; gt; Something like
gt; gt;
gt; gt; =IF(A1gt;1500,1500,A1)*0.034

gt; ...The IF formula below is the only thing that will work. the quot;MINquot;
formulas
gt; mentioned will hold the sales value at 1500.

???
--
David Biddulph
....I tried the MIN and found that it doesn't account for amounts under 1500.
If you had say, 1385, instead of giving you 1385*.034, it would give you
1500*.034.

quot;JE McGimpseyquot; wrote:

gt; Huh?
gt;
gt; The IF and MIN formulae return exactly the same results. Did you try
gt; them?
gt;
gt; In article gt;,
gt; quot;JRquot; gt; wrote:
gt;
gt; gt; ...The IF formula below is the only thing that will work. the quot;MINquot; formulas
gt; gt; mentioned will hold the sales value at 1500.
gt;

Sorry guys, I must have typed it incorrectly... it does work. At any rate,
Sharon will never know that either of them works until she tries it.

quot;JE McGimpseyquot; wrote:

gt; One way:
gt;
gt; =0.034*MIN(A1,1500)
gt;
gt; In article gt;,
gt; Sharon D. gt;
gt; wrote:
gt;
gt; gt; I guess I haven't explained my first questions very well. The answer
gt; gt; will vary depending on what amount the formula is being calculated
gt; gt; against. The answer will not always be same. I need to have a formula
gt; gt; that calculates commission on the first $1500 and not any additional
gt; gt; money on anything over $1500. So if a person raises $1300. The
gt; gt; percentage is .034 - the commission would be $44.20.
gt; gt;
gt; gt; If a person raises 1500. the percentage is still .034 the commission
gt; gt; would be $51.00.
gt; gt;
gt; gt; If the person raises 1600, the percentage is .034 for the first $1500
gt; gt; and the commission is still $51.00 because he doesn't get paid on the
gt; gt; extra $100 over
gt; gt;
gt; gt; I need a formula that calcuates commission of the first $1500 and not
gt; gt; any additional money on anything over $1500.
gt;