| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding
I have this code and I need to Round Time1 to two dec places.
Time1 = Lastcell * 12 / 60 / 60 Thanks in advance! Aaron |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Rounding
Time1 = Round(Lastcell * 12 / 60 / 60,2)
Cheers Nigel "Aaron" wrote in message ... I have this code and I need to Round Time1 to two dec places. Time1 = Lastcell * 12 / 60 / 60 Thanks in advance! Aaron |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| rounding | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Rounding up or down | Excel Discussion (Misc queries) | |||
| Rounding | Excel Worksheet Functions | |||
Linear Mode
