Rounding Numbers in Excel, Part 2

 Sep 04, 2015

In Part 1 of this series I discussed the worksheet functions ROUND, ROUNDUP and ROUNDDOWN. They will truly round numbers to a certain number of decimal places. But what if you want to round numbers to a certain “multiple of significance”? For example, if you want to round numbers to the nearest .05 there are the functions CEILING, FLOOR and MROUND.

The CEILING Function

CEILING rounds numbers up to the nearest multiple of significance. For example:

= CEILING(3.1415,0.05) gives the result 3.15

=CEILING(1.02,0.05) gives the result 1.05

The FLOOR Function

FLOOR rounds numbers down to the nearest multiple of significance. For example:

= FLOOR(3.1415,0.05) gives the result 3.10

=FLOOR(1.07,0.05) gives the result 1.05

The MROUND Function

MROUND rounds numbers up or down to the nearest multiple of significance. For example:

=MROUND(3.1415,0.05) gives the result 3.15

=MROUND(3.185,0.05) gives the result 3.20

There are a great number more worksheet functions explored in the New Horizons Excel 2010 and 2013 Level 4 courses.

How do your Excel skills stack up?   

Test Now  

About the Author:

Ben Kirk  

With over 16 years of experience working as a Desktop Applications specialist for a number of large education services providers, Ben is one of New Horizons most skilled and dynamic instructors. With his Advanced Diploma of Business Skills alongside his practical experience and expertise, Ben is able to provide insight and guidance to students at all skill levels across the entire Microsoft Office suite.

Read full bio
top