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 ...
Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface
Tutorial: Learn to make a beautiful and intuitive date filtering interface for your data in Excel t...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.