Rounding
One way:
Time1 = Round(Lastcell/300, 2)
or, for MacXL/WinXL97:
Time1 = Application.Round(Lastcell/300,2)
Note the VBA's round works slightly differently than XL's ROUND(),
rounding a value ending in 5 to the nearest even number, rather than
always away from zero.
In article ,
"Aaron" wrote:
I have this code and I need to Round Time1 to two dec places.
Time1 = Lastcell * 12 / 60 / 60
Thanks in advance!
Aaron
|