View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Is there a function to do ASTM-29-67 rounding ?

=ROUND(A1/2,1)*2

I think this is what you want, but, as always, I could be waaaaaay wrong. This will always round to
an even last digit. Replace the 1 with the number of decimal places you want...

HTH,
Bernie
MS Excel MVP


"EC" wrote in message
...
Hope to find a readyly available function or program to perform rounding
using ASTM-29-67 (1973) methodlogy in Excel.