Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() The zero indicates the number of decimal places. If you use =ROUND(A1,1) it will round A1 to 1 decimal place, e.g. for your example 76.3 if you use -1 it rounds to the nearest multiple of 10 so if A1 contains 76.25 =ROUND(A1,-1) would give you 80 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=522886 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Averaging and Rounding problem | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
problem office assistant | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |