Excel ROUND Function

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

Related Tutorial: Using Rounded Numbers in Calculations

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

For help with this example, see the image above.

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

• Excel MROUND Function
• Excel FLOOR Function
• Excel CEILING Function