Hi Bud

I agree with Biff; Excel is correct in rounding 100.4658 up to 100.47
if using ROUND. If you specifically want to round down to 100.46 use
ROUNDDOWN instead of ROUND.

Stu


--
stuarthow
------------------------------------------------------------------------
stuarthow's Profile: http://www.excelforum.com/member.php...o&userid=25417
View this thread: http://www.excelforum.com/showthread...hreadid=487849