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