Sharon

Try:

=IF(A1<1500,A1*.034,1499*.034)

if A1 is under $1500 it will multiply that value by .034 if A1 is over
$1500 it will only multiply the first $1499 by .034, change $1499 to
you max value.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495470