Round Function Error

A

Arvind Mane

Please see the following Macro

Sub Data1()

a = 1.845
a = Round(a, 2)

End Sub

i am getting "a" value as 1.84 instead of 1.85.
What should i do?
 
G

Gary''s Student

You don't need to do anything.

The value of 1.85 is correct (at least consistent with the worksheet function)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top