"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 ?
"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 woorking 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 **