Behaviour of VBA ROUND function

  • Thread starter Thread starter Microsoft Forum
  • Start date Start date
M

Microsoft Forum

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.
 
Back
Top