Try this, Peter:

=ROUNDUP(MIN((0.4*A1)+0.15*MIN(3500,A1),3500),0)

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=394278