Rounding a number to the nearest integer or the nearest 0.5 or 5 or 10 is a common task for many people.

For example, if you're a project manager involved in effort estimate, you can't have 12.7 full-time resources working on a project.

You need to round this number to 13 (the nearest integer).

Similarly, if you're buying stocks that are sold in a batch of 5, and you can afford a maximum of 123 shares only, you need to round it down to 120 (i.e., the nearest 5).

While you can do this manually for a couple of values, doing it for hundreds of such value could become tedious and highly prone to errors.

There are a couple of great functions in Excel that allows you to quickly round to the nearest integer or the nearest 0.5 or 5 or 10 value.

In this video, I will show you how to use the MROUND, CEILING, and FLOOR functions to do this type of rounding in Excel.

In this video, I cover the following topics:
-- Round to the Nearest Integer in Excel
-- Round to the Nearest 0.5 in Excel
-- Round to the Nearest 5 in Excel
-- Round-Up to the Nearest 5
-- Round Down to the Nearest 5
-- Round to the Nearest 10 in Excel

You can read more about this here: https://trumpexcel.com/round-to-neare...



Let's Connect:
Google+ ► https://plus.google.com/+Trumpexcel
Facebook ►   / trumpexcel  
Twitter ►   / trumpexcel  
Pinterest ►   / trumpexcel  
Youtube Channel ►    / trumpexcel  

Round to the Nearest Integer in Excel, Round to the Nearest 0.5 in Excel, Round to the Nearest 5 in Excel, Round Up to the Nearest 5, Round Down to the Nearest 5, Round to the Nearest 10 in Excel #Excel #ExcelTips #ExcelTutorial