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.


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

Round to N Digits or Multiples

By Jeff Lenning | 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
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