Is there a function to do ASTM-29-67 rounding ?
Hope to find a readyly available function or program to perform rounding
using ASTM-29-67 (1973) methodlogy in Excel. |
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. |
Is there a function to do ASTM-29-67 rounding ?
"EC" wrote:
Hope to find a readyly available function or program to perform rounding using ASTM-29-67 (1973) methodlogy in Excel. Just speculating.... The title of ASTM 29-67 (1973) is "Standard Recommended Practice for Indicating which Places of Figures are to be Considered Significant in Specified Limiting Values", according to a citation in an EPA regulation. I do not know the contents of that standard. But since a previous thread indicated that the EPA recommends the use of ASTM E29-93 (1993; replaced by E29-02e1) for rounding -- which apparently specifies the use of the so-called "banker's rounding" method -- I suspect that you are interested in using "banker's rounding" in conjunction with the number of significant places recommended by ASM 29-67. If my supposition is correct, there is no standard Excel function that will do the task. However, Jerry Lewis has offered a VBA function that he says will do the job. You might take a look at http://groups.google.com/group/micro...7fce6145b70d69 .. Apologies in advance if this is an over-complicating misdirection. Again, I am not familiar with any of the ASTM standards or the EPA regulations. |
All times are GMT +1. The time now is 09:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com