Excel Forum
Similar Content
Round Numbers Up or Down in Excel
Tutorial: How to round a number up or down and also to a specified number of decimal places in Excel...
Introduction to Using Filters to Refine Data in Excel
Tutorial: Filtering allows you to hide rows of data which you are not interested in so that you can ...
Performing Calculations in Excel - Order of Operations Explained
Tutorial: In this tutorial I am going to cover how to perform calculations in Excel. Calculations in...



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.