Rounding

A

Aaron

I have this code and I need to Round Time1 to two dec places.

Time1 = Lastcell * 12 / 60 / 60

Thanks in advance!

Aaron
 
J

JE McGimpsey

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