"Arvind Mane" wrote in message
...
Please go through the following excel Macro

Sub Arvind()
a = 1.845
b = Round(a, 2)
End Sub


i want "b" value as 1.85 but the macro is giving me 1.84.
What can i do for this ?


If you'r only ever working with 3 decimal places, you could try :-

Sub Arvind()
a = 1.845
b = Round(a - 0.0001, 2)
End Sub

--
Rich
http://www.richdavies.com/excel.htm
http://www.richdavies.com/mp3-downloads.htm





** Posted from http://www.teranews.com **