How to use the Excel ROUND function

ROUND Excel function is an inbuilt function in excel which is used to calculate the round number of a given number with the number of digits to be provided as an argument, this function takes two arguments one which is the number itself and the second argument is the number of digits we want the number to be rounded up to.

Syntax: =ROUND(number, num_digits)

The ROUND function syntax has the following arguments:

  • number    Required. The number that you want to round.
  • num_digits    Required. The number of digits to which you want to round the number argument.

Example: Let’s look at some Excel ROUND function examples and explore how to use the ROUND function as a worksheet function in Microsoft Excel:

Excel ROUND function - How to use the Excel ROUND function

Syntax:  =ROUND(A2,B2)

Result:

ROUND function 1 - How to use the Excel ROUND function

Based on the Excel spreadsheet above, the following ROUND examples would return:

Syntax: =ROUND(A3,B3)
Result: 80.76

Syntax: =ROUND(A4,B4)
Result: 80.759

Syntax: =ROUND(A5,B5)
Result: 88

Syntax: =ROUND(A6,B6)
Result: 0

Syntax: =ROUND(A7,B7)
Result: -100

Syntax: =ROUND(A8,B8)
Result: 46000

Syntax: =ROUND(A9,B9)
Result: 50000

Syntax: =ROUND(A10,B10)
Result: 5.2

Syntax: =ROUND(A11,B11)
Result: 5.7

Syntax: =ROUND(A12,B12)
Result: -22.48

Note:

  1. The ROUND function in Excel works by rounding the numbers 1-4 down and rounding the numbers 5-9 up.
  2. You can use the ROUND function in excel for rounding numbers to a specified level of precision. ROUND can be used for rounding to the right or left of the decimal point.
  3. If num_digits is greater than 0, number will be rounded to the specified decimal places to the right of the decimal point. For example, =ROUND (216.55, 1) will round 216.55 to 216.6.
  4. If num_digits is less than 0, number will be rounded to the left of the decimal point (i.e. to the nearest 10, 100, 1000, and so on). For example, =ROUND (16.55, -1) will round 16.55 to the nearest 10 and return 20 as the return value or result.
  5. If num_digits = 0, number will be rounded to the nearest integer (no decimal places). For example, =ROUND (16.55, 0) will round 16.55 to 17.

Add a Comment

Your email address will not be published. Required fields are marked *