Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT516-523.xls

See how to Round numbers two different ways:
1.School Rounding: 5 or greater add 1, 4 or less leave as is.
2.Bankers Rounding : 5 round to nearest even, 6 or greater add 1, 4 or less leave as is.
See four methods:
1.EXCEL ROUND Function
2.User Defined Function VBA ROUND
3.Access Database Round Function
4.MOD, ROUND functions formula Barry Houdini

Bill Mr Excel Jelen video: ASTM E29 Rounding - 1046 - Learn Excel from MrExcel Podcast

John Pfeffer Highline Community College Chemistry teacher