I have a customer who wants calculations Rounded per the requirements of
ASTM E29. Does anyone know if Microsoft Excel complies with ASTM E29 when
numbers are rounded?
Thanks
Paul
Excel does not, but I believe VBA does. If it does, then you could use this
UDF:
To enter the UDF, <alt-F11> opens the VBEditor. Ensure your project is
highlighted in the Project Explorer window, then Insert/Module and paste the
code below into the window that opens.
To use this, enter the formula
=bRound(num, numdigits)
into some cell where num is either the number you want to round, or a cell
reference containing that number; numdigits is the number of decimals to round
to (0 by default).
=========================
Function bRound(num As Double, Optional numdigits As Long = 0) As Double
bRound = Round(num, numdigits)
End Function
==========================================
--ron