How to Round Numbers in Excel
Use the ROUND function to round numbers up or down.
These only change how the number appears in the worksheet.
When you round a number, you change how the number appearsandhow Excel stores the number.
Excel stores the number as the new rounded number, the original value is removed.
Thenum_digitsargument is the number of digits to which the number argument will be rounded.
When Excel uses the ROUND function to round numbers, it follows conventional rounding rules.
For values that are less than 5, Excel rounds down to the nearest number.
For values that are 5 or higher, Excel rounds up to the nearest number.
Toround all numbers up, use the ROUNDUP function.
Toround all numbers down, use the ROUNDDOWN function.
In the formula bar, enter=ROUND.
As you pop in, Excel suggests possible functions.
Enter the number you want to round, followed by a comma (,).
Enter the number of digits to which you want to round the value.
Enter a closing parenthesis and pressEnter.
The rounded number appears in the selected cell.
To use the Function Arguments dialog box to enter the ROUND function:
Enter the datayou want to round.
snag the first cell that will contain the result of the formula.
SelectFormulas>Math & Trig>Round.
opt for cell that contains the formula results.
Drag thefill handleto the bottom of the column of values.
The ROUND function is copied to the cells, and the rounded numbers for each value appear.
