Sharon, the formula that Pinmaster gave you is EXACTLY what you need.
Anything 1500 or less gets multiplied by .034 and anything over 1500 shows
only the maximum commission, which is 1500*.034. Just type it in and test
it... trust me.

"Sharon D." wrote:


I guess I haven't explained it very well. The answer will vary
depending on what amount the formula is being calculated against. The
answer will not always be $51.00. 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 1500.


--
Sharon D.
------------------------------------------------------------------------
Sharon D.'s Profile: http://www.excelforum.com/member.php...o&userid=29841
View this thread: http://www.excelforum.com/showthread...hreadid=495470