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