Excel > Functions

ROUND Function

The Excel ROUND function is used to round a number to a specified number of digits.For example, round a number to the one decimal place.

The syntax for the ROUND function is:

=ROUND(number,num_digits)

Argument

Purpose

Number

The number you want to round

num_digits

The number of digits you want to round the number to.

  • If the num_digits is greater than 0, the number is rounded to the specified number of decimal points
  • If the num_digits is 0, the number is rounded to the nearest integer
  • If num_digits is less than 0, the number is rounded to the left of the decimal point

Below are examples of the ROUND function being used to round numbers to a various number of digits.

Data to use for ROUND function

Function

Result

=ROUND(A1,2)

5.33

=ROUND(A2,0)

3

=ROUND(A3,1)

4.6

=ROUND(A4,-1)

20

Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.

Follow us on

Facebook  Twitter  You Tube 

Other Mathematical Functions