Some ways of rounding numbers in Excel

By cuongbv.com Updated: 05 Oct, 2018

For the office workers to work the calculations, Excel tools are used a lot. In the calculation of multiplication, the result can not be rounded and rounding is necessary. To round numbers in Excel is beyond the function ROUND Many other functions will be introduced in the article "Some ways to round numbers in Excel" by Congnghe3s.com.


1. Round the number using the ROUND function


Rounding with ROUND is commonly used with the following syntax:


Formula: = ROUND (number, num_digits)

With:



  • number: number wants to round

  • num_digits: Number of digits to be rounded.


so-so-in-excel-1


If value num_digits is a positive number, the number is rounded up after the decimal. In contrast, value num_digits is negative, the number will be rounded to tens, hundreds, thousands, ...


2. Rounded using the ROUDUP function


The name will probably help you visualize the rounding of this function. If using the ROUDUP function, the number of rounds received will be greater than the original number.


so-so-in-excel-2


The ROUDUP formula is similar to the ROUND function:


Formula: = ROUNDUP (number, num_digits)

With:



  • number: number wants to round

  • num_digits: number of digits to be rounded.


If value num_digits is a positive number, the number is rounded up after the decimal. In contrast, value num_digits The numbers are rounded up to tens, hundreds, thousands, etc. But all are rounded up.


3. Rounded with the ROUNDDOWN function


Formula: = ROUNDDOWN (number, num_digits)

The formulas and meanings of the ROUDDOWN function are similar ROUND but the way rounded to the jaw ROUNDUP. Number of rounds received from the function ROUNDDOWN will be smaller than the original.


mot-so-in-excel-so-in-excel-3


4. Round to MROUND


Formula: = MROUND (number, multiple)

With:



  • number: number wants to round

  • Multiple: The number you need to round to its multiple.


Note:



  • The function will report #NUM! If number and multiple are different.

  • The result will return the same number if the number and the multiple are equal.


so-so-in-excel-4


When number / multiple is greater than or equal to multiple / 2, the result is rounded up. Conversely, the result will be rounded down.


5. CEILING function and FLOOR function


Syntax:
= CEILING (number to round, significance)
= FLOOR (number, significance)


  • Significance: the number you need to round to its multiple.

  • The function will report an error #NUM If number and Significance left.

  • The result will return that number if the number is a multiple of Significance.


so-so-in-excel-5


These two functions are different MROUND at the point function CEILING round up some away from 0 while the FLOOR function rounds back number 0.


Hope the article of Congnghe3s.com help you understand how to use rounding functions in Excel and apply accordingly depending on the need to use!


Good luck!


The post A number of ways round numbers in Excel appeared first on Congnghe3s.com - Tips computer life and technology.