Excel Forum



Excel Magic Trick 521: Bankers Rounding (Half-Way-Even) vs. Arithmetic Rounding


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





Got a Question? Ask it Here in the Forum.