In the second example you have shown, I would have thought that the $5
would apply to 6 units (100-94), and that the $15 would apply to 5
units (105-100).

Am I missing something - further examples might help!

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=527325