The ROUND function is used to reduce a given value to a specific number of decimal places.

The function will round the last number (the rounding digit) up or down depending on the value of the number to the right of the rounding digit.

- If the value of the number to the right of the rounding digit is less than five, the rounding digit is left unchanged
- If the value of the number to the right of the rounding digit is five or higher, the rounding digit is raised by one

Related Tutorial: **Using Rounded Numbers in Calculations**

### The ROUND Function's Syntax and Arguments

A function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.

The syntax for the ROUND function is:

**= ROUND ( Number, Num_digits )**

Number - the value to be rounded.

Num_digits - the number of decimal places to reduce the above number to.

**Example: Using Excel's ROUND Function**

As can be seen in the image above, this example we will use the ROUND function to reduce the number of decimal places of a value to one.

- Enter the following data into cell D1: 34.567
- Click on cell E1 in the worksheet - this is where the function will be located.
- Click on the
*Formulas*tab of the ribbon menu. - Choose
**Math & Trig**from the ribbon to open the function drop down list. - Click on
*ROUND*in the list to bring up the function's dialog box. - In the dialog box, click on the
*Number*line. - Click on cell D1 in the spreadsheet.
- In the dialog box, click on the
*Num_digits*line. - Type in a 1.
- Click OK.
- The answer 34.6 should appear in cell E1.
- When you click on cell E1 the complete function
**= ROUND ( D1 , 1 )**appears in the formula bar above the worksheet. - To remove all decimal places from a value, set the num_digits to 0.