=MIN(51,A1*.034)

--
Kind regards,

Niek Otten

"Sharon D." wrote
in message ...

I need to do a formula as follows.

If the amount in column A is < $1500 calculate it by .034. If the
amount is $1500 then they get .00 of only the amount over %1500.

Know how to do IF statements but can't seem to figure out how to
calculate only on the amount under a certain value and not on the
amount over that value.

So results should be $1500*.034 = $51.00
00-1700 *.00 = $00.00

Total Commission $51.00

Help!!!!
Thanks if you can do this.


--
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