# 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.

# MROUND

## Round to Nearest Multiple (Up or Down or Both)

| 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

## Round to N Digits or Multiples

| November 7, 2023 |

In this tutorial, we will explore different methods of rounding values in Microsoft Excel. We will learn how to use various rounding functions and understand the difference between rounding through formulas and changing the displayed value through formatting. We will round by the number of decimals or whole numbers as well as to the nearest…

Read More

## Round to the Nearest 5 in Excel Using 3 Different Functions

| 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

### Learn by Email

###### Subscribe to Blog (free)
Something went wrong. Please check your entries and try again.