Hello, and welcome to Mark’s Excel Tips. Today, I will show you how to round numbers in Excel. Let’s get started.
Click here to view our video tutorial.
Click here to download our PDF tutorial.
Today, I will show you how to round up, round down, and round up or down depending on the first number following the decimal point.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide2-4-1024x576.jpg)
To round up a number, click on the cell that you want your rounded up number to show up in.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide3-4-1024x576.jpg)
Next, click on Formulas.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide4-3-1024x576.jpg)
In the Function Library, Click on Math & Trig.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide5-5-1024x576.jpg)
In the dropdown list, scroll down and click on ROUNDUP.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide6-3-1024x576.jpg)
In the window that opens, you will need to input two numbers.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide7-3-1024x576.jpg)
In the first box, you want to put in the number that you want to round up.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide8-2-1024x576.jpg)
To do this, all you need to do is click on the cell that contains the number that you are rounding up and Excel will place that cell number in the box.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide9-2-1024x576.jpg)
The next box, is for telling Excel the number of digits that you want to round up to. Placing a zero in this box will round up to the next whole number. Placing a 1 here, will round up to one number past the decimal point, and a 2 will round up to two decimal points.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide10-2-1024x576.jpg)
You can change this number, to see what the different results will be.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide11-2-1024x576.jpg)
We will place a zero here, and round up to the next whole number.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide12-2-1024x576.jpg)
Once you have both boxes filled out, click OK.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide13-2-1024x576.jpg)
Excel has rounded up your number to the next whole number.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide14-2-1024x576.jpg)
To round down, we will follow the same process as we did to round up, by clicking on the cell that we want our rounded number to be in.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide15-1-1024x576.jpg)
Click on Formulas.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide16-1-1024x576.jpg)
Click on Math & Trig.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide17-1024x576.jpg)
Scroll down, and click on ROUNDDOWN.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide18-1024x576.jpg)
Click on the cell that contains the number, that you want to round down.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide19-1024x576.jpg)
We will enter a zero in the number of digits box, to round down to a whole number.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide20-1024x576.jpg)
Click OK.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide21-1024x576.jpg)
Excel has rounded our number down to the nearest whole number.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide22-1024x576.jpg)
Now the round function, is used when you want to round a number up, or down, based on the value after the decimal point.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide23-1024x576.jpg)
If the first number after the decimal point is a number 5 or higher, the number will be rounded up.
If the first number after the decimal point is a number 4 or lower, the number will be rounded down.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide24-1024x576.jpg)
We will start by selecting the cell, where we want our first value to be.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide25-1-1024x576.jpg)
Select Formulas.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide26-1024x576.jpg)
Select Math & Trig.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide27-1024x576.jpg)
Scroll down and choose ROUND.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide28-1024x576.jpg)
Select the cell where the number is, that you want to round up or down, to populate the number box.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide29-1024x576.jpg)
We will use the number zero, to round up or down to a whole number.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide30-1024x576.jpg)
Click OK.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide31-1024x576.jpg)
Excel has rounded this number up due to the first number after the decimal point being the number 5.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide32-1024x576.jpg)
Now, we just need to grab the bottom right corner of the cell containing the formula and drag it down to the next cell.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide33-1024x576.jpg)
Excel has rounded this number down due to the first number after the decimal point is the number 4.
![](https://marksexceltips.com/wp-content/uploads/2023/03/Slide34-1024x576.jpg)
View the Video Tutorial.
Download this tutorial in PDF by clicking the Download link below.