Rounding a number means altering it to a specific size. Rounding integers (whole numbers) involves rounding them up or down to the nearest multiple of 10, while rounding decimals reduces them to a set number of decimal places.
The syntax for the ROUND function is:
=ROUND( Number, Num_digits )
Num_digits = the number of digits or the number of decimal places that the number is to be rounded to.
Rounding Decimals Example in Excel 2007:
Note: For help with this example, see the image to the right.
- Click on cell E1.
- Click on the Formulas tab.
- Click on the Math & Trig option on the ribbon to open the Function drop down list.
- Scroll down through the list and click on the ROUND option to bring up the Function Arguments dialog box.
- Type 356.6789054 in line one of the dialog box.
- Type a 3 in line two of the dialog box.
- Click OK.
- The number 356.679 should appear in cell E1.
- Click on cell E1 and you should see the function
=ROUND( 356.6789054, 3 ) in the formula bar.