Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

FLOOR

Round to Nearest Multiple (Up or Down or Both)

By Jeff Lenning | December 19, 2023 |

Welcome to our blog post on rounding to the nearest multiple in Excel. In this tutorial, we will explore three different functions that can assist you in rounding numbers up or down to the nearest multiple: FLOOR, CEILING, and MROUND. Whether you need to calculate the number of product bundles or adjust sales targets, these…

Read More
Woman sitting on couch with a laptop giving a high five sign after learning how to round to the nearest 5 in Excel

Round to the Nearest 5 in Excel Using 3 Different Functions

By Excel University | February 14, 2023 |

Whether you’re working with something like test scores, tracking expenses, or any other type of data, being able to round numbers to the nearest 5 in Excel is a handy skill. This is helpful when you need to round to the nearest multiple (like 5) instead of simply to the nearest whole number.  Here are…

Read More