This might be of interest as well:


http://support.microsoft.com/default...b;en-us;196652
How To Implement Custom Rounding Procedures

--
Regards,
Tom Ogilvy


"Microsoft Forum" wrote in message
...
Hi all,

I have a question of dealing with VBA ROUND function, the question is that
it doesn't do the rounding consistently.

For example:

ROUND(100.5) - 100
ROUND(100.6) - 101
ROUND(100.55,1) - 100.6

Why is that? Is it a bug? Please advise.

Frederick Chow
Hong Kong.