How to round up numbers in Excel
The ROUNDUP function in Excel is used to round a number up to its nearest integer, away from 0 (zero).
The syntax of the ROUNDUP function is =ROUNDUP(number, num_digits).
This function has the following arguments:
- Number – Any real number you want to round up.
- Num_digits – The number of digits to which you want to round the number to.
Let’s go! ROUND 1. 🥊
Let’s use the value of pi (π = 3.14159265359) for our example.
Here’s how to round up this number to your desired number of digits.
- In cell B2, type =ROUNDUP(
- The first argument of the ROUNDUP function is the number. Type the number or click on the cell address of the number you want to round up.
- The next argument is num_digits. It is the number of digits you want to round the number to.
Let’s use 1 for our first example. 1 means to round a number to one decimal place after the decimal point.
Simply put, round to the nearest tenths. Close the function with a right parenthesis.
The number ROUNDED UP.
Since the num_digits is 1, the number is rounded up to the nearest tenths (the first decimal place to the right after the decimal point).
1 being the tenths decimal place value rounds up to 2, resulting to 3.2
Great job! 👍
Let’s try to input 2 as our num_digits. This means that the number rounds up to two decimal places (round to the nearest hundredths).
In cell B3, type =ROUNDUP(A3,2)
The number is now rounded up to two decimal places. The hundredths decimal place rounds up to 5, resulting to 3.15
What a good starting ROUND! 🙌