Reveal 5 Ways To Round Numbers In Excel With Round, Roundup Functions

For those of you who are using Excel, perhaps the decimal number is nothing too strange, but sometimes the number is too long, making you feel uncomfortable and find a way to round it, shorten the column.  So  WebTech360  will show you  how to round numbers in Excel  so you can easily continue your work.

Round Numbers in Excel with the Round . Function

Each data will have ways of rounding to different values ​​using different function tools. As a result, they will display in the excel sheet different results. The rounding display functions from the Round function will also give different results than the other functions. So, we will come to how to round numbers in Excel using the Round function.

The Round function, also known as the Round function, has the effect of pushing the rounded number to the nearest specified number. They only need 1 statistical step and simple formula:

= ROUND(number, n)

- number: Number to round.

- n: As an argument, n can be negative or positive

Example: The following formula:

= ROUND( 2.15, 1) , round 2.15 to 1 decimal place, the result will be 2.2

= ROUND( 2.149, 1) , round 2.149 to 1 decimal place, the result will be 2.1

In addition, the ROUND function includes two ways of rounding, including: Rounding the number to the nearest fraction and rounding the number to significant digits.

How to round a number to the nearest fraction in the Round . function

This way of rounding numbers in Excel of the ROUND function has been specified as above. Their general formula is:

= ROUND( number, num_digits)

In there:

- Number: is a required number when you want to round on Excel.

- Num_digits: This is also the required number, the number of digits that you want to round up in Excel.

Note:

- num_digits greater than 0 is rounded to the specified number.

- Num_digits is 0, then it is rounded to the nearest integer.

- num_digits less than 0 is rounded to the number to the left of the decimal point

(e.g. = ROUND( 21.5, -1) will result in 20).

How to round a number to 1 significant digit with the Round . function

Digits in Excel mean those that have the exact contribution to a number. Use the Round function to talk about methods of rounding to positive negative numbers, decimals. Shows a small part of the situation that is also possible.

Here are some rules for rounding numbers to 1 significant place when using the Round function:

- The Round function is used to round a number with a decimal part as follows: If the decimal part is greater than or equal to 0.5, the number will be rounded up. If it is smaller, it will be rounded down.

- The Round function is used to round integers up or down with the same rules as decimals. However, replace the number 0.5 with a multiple of 5

How to round up in Excel using the Roundup function

How to round up in excel with the Roundup function is a pretty easy way to round up numbers in Excel . The function has the effect of making the number to be rounded larger than the original number, the higher value. How high the value is will depend on how your function is used, for example:

- If the number to be rounded has a positive value, the number following will push the rounded number to decimals

- Otherwise, the number to be made in has a negative value, the value will be rounded to tens or hundreds.

The formula for rounding the number of the Roundup function is as follows:

= ROUNDUP(number, value to round)

For example: = ROUNDUP(456.458, 1) the result will be 456.5

How to round down in Excel using the Rounddown function

How to round numbers in Excel also has a way to round down with the Rounddown function. This function has the effect of producing results that need to be rounded with a value smaller than the old value according to the appropriate requirements. The result given will depend on the function according to the formula:

= ROUNDDOWN(number, value to round down)

For example:

= ROUNDDOWN(456.458,1) the result will be 456.4

= ROUNDDOWN(456.458,2) the result will be 456.45

The Roundup and Rounddown functions are two opposite functions. One function pushes the number to be rounded down and the other pushes the number up.

How to round a number to a preselected multiple

In addition to the ways to round numbers in Excel as above, there is also a way to round numbers to a pre-selected multiple. The Roundup function also rounds to multiples of other data parameters in the spreadsheet. The number to be rounded in multiples is denoted by multiple, giving the rounding value number. The calculation formula is also very simple:

=MROUND(rounded value, number to round in multiples)

For example:

= MROUND(5,2) the result will be 6

= MROUND(12,5) the result will be 10

If you get the formula wrong, the result will be #NUM. The number to round will not be displayed on the results table, because they are having different signs. They are only displayed when the results have the same sign.

Sign difference occurs when number and multiple have different signs, 1 negative and 1 positive. For example:=MROUND(-5,2) the result will be #NUM!

Professional PC configuration for Office People

In addition, you can refer to the following configuration for smooth basic excel work, this is the minimum configuration to help you do Excel well.

🔵 Configure OFFICE PC - INTEL CORE i3 10100 | RAM 8G 

➤ MAINBOARD: MSI H410M-A PRO
➤ CPU: INTEL CORE i3 10100 up to 4.3G | 4 CORE | 8 THREAD
➤ RAM: LEXAR 8GB DDR4 2666MHz (1x8GB)
➤ SSD: GIGABYTE SSD 240G SATA III
➤ HDD: CUSTOMER OPTIONS 
SOURCE: AEROCOOL VX PLUS 400 400W
➤ CASE: JETEK KAMADO ( NO FANS )

That's  how to round numbers in Excel , to help you avoid confusion in the process of working with excel tools. If you are looking for more great tutorials, follow and support  WebTech360 .