How to use ROUND function in Microsoft Excel

0
163

This tutorial illustrates the syntax and examples of Excel ROUND function. You will also learn how to use this function on the real-life data.

The ROUND function returns a supplied number rounded to a specified number of digits. The function follows the general math’s rules for rounding, where the number followed by a rounding digit determines whether the rounding digit is rounded upwards or downwards. The number can be rounded to the nearest integer or to a certain number of decimal places.

Uses: ROUND Function

Number rounding is a very common practice in everyday life and you may require converting long decimal numbers shorter. Suppose, you are performing division calculation or multiplying a number column with a column having percentage entries. The result may appear in mixed decimal that you further like to display after rounding off to certain digits or to the nearest integer.

For example, the function =ROUND (19.528272, 2) rounds to 19.53.

Syntax:

ROUND (number, num_digits)

Arguments:

  • number: the number you want to round.
  • num_digits: The number of decimal places to round the number to.

Examples: ROUND Function

Let’s take a few examples of ROUND function. The following screenshot illustrates several examples in column C.

The following function in row 2, rounded the number to the three decimal places since the num_digit supplied 3.

=ROUND (A2, B2)

Excel Round Function

On row 5, the number was rounded to the nearest integer as ‘0’ was provided as num_digit.

Lastly, on row 6 & 7, when num_digit was supplied as ‘-1’ and ‘-2’, the numbers rounded to the nearest ‘10’ and ‘100’ to the left of the decimal respectively.

Additional Notes: –

  • The number argument can be a number, reference to a numeric cell or number returned by Excel function or formula.
  • The ROUND function returns #VALUE! error when a non-numeric value is supplied to either argument.
  • The function returns the answer in the same sign as the number
  • The function works rounding numbers 1-4 down and 5-9 up.
    • For example; if the digit followed by rounding digit is between 0-4, the rounding digit remains unchanged.
    • If rounding digit is followed by digit value 5-9, the rounding digit is increased by one, and the number is rounded up.
  • The Excel ROUND function can either round to the right or left of the decimal places based on the num_digit value:
    • If num_digit is greater than zero (0), the number is rounded to the specified number of decimal places to the right of decimal point.
      • For example, =ROUND (19.527, 2) rounds 19.527 to 19.53.
    • If num_digit is equal to 0, the number is rounded to the nearest integer.
      • For example, =ROUND (19.527, 0) returns 20 after rounding 19.527 to the closest integer (without any decimals).
    • If num_digit is less than 0, the number is rounded to the left of the decimal point.
      • For example, =ROUND (19.527, -1) rounds 19.527 to the nearest ‘10’ as 20.

Related Functions:-

INT | ROUNDUP | ROUNDDOWN | MOD

LEAVE A REPLY

Please enter your comment!
Please enter your name here