View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default Rounding off problem..!


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