Rounding Numbers in Excel Online

Excel Online ROUND Function

Rounding Numbers with Excel Online's ROUND Function
Rounding Numbers with Excel Online's ROUND Function. © Ted French

ROUND Function Overview

The ROUND function can be used to reduce a number by a specific number of digits on either side of the decimal point.

In the process, the final digit, the rounding digit, is rounded up or down based on the rules for rounding numbers that Excel Online follows.

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 ROUNDDOWN function is:

= ROUND ( number, num_digits )

The arguments for the function are:

number - (required) the value to be rounded

num_digits - (required) the number of digits to leave in the value specified in the number argument:

  • if num_digits is a positive value, only digits in the number argument located to the right of the decimal point are rounded;
  • if num_digits is negative, only digits in the number argument located to the left of the decimal point are rounded -  any and all decimals are removed without rounding.

Examples

  • if num_digits is set to 1 the function leaves only one digit to the right of the decimal point and rounds it up or down - row 4 above;
  • if num_digits is set to 2 the function leaves two digits to the right of the decimal point and rounds the last one up or down - row 5 above;
  • if num_digits is set to -1, the function will remove all digits to the right of the decimal point and round the first digit to the left of the decimal point up or down to the nearest multiple of 10 - row 6 above;
  • if num_digits is set to -2, the function will remove all digits to the right of the decimal point and round the first and second digits to the left of the decimal point up or down to nearest multiple of 100 - row 7 above;

Round Numbers in Excel Online Example

The instructions below detail the steps taken to reduce the number 17.568 in cell A5 in the image above to two decimal places using the ROUND function.

Excel Online does not use dialog boxes to enter a function's arguments as can be found in the regular version of Excel. Instead, it has an auto-suggest box that pops up as the name of the function is typed into a cell.

  1. Click on cell C5 to make it the active cell - this is where the results of the first ROUND function will be displayed;
  2. Type the equal sign ( = ) followed by the name of the function round;
  3. As you type, the auto-suggest box appears with the names of functions that begin with the letter R;
  4. When the name ROUND appears in the box, click on the name with the mouse pointer to enter the function name and open parenthesis into cell C5;
  5. With the cursor located after the open round bracket, click on cell A1 in the worksheet to enter that cell reference into the function as the number argument;
  6. Following the cell reference, type a comma ( , ) to act as a separator between the arguments;
  7. After the comma type a one " 2 " as the num_digits argument to reduce the number of decimal places to two;
  8. Press the Enter key on the keyboard to add the closing parenthesis and to complete the function;
  9. The answer 17.57 should appear in cell C5;
  10. When you click on cell C5 the complete function = ROUND ( A5 , 2 ) appears in the formula bar above the worksheet.

    The ROUND Function and Calculations

    Unlike formatting options that allow you change the number of decimal places displayed without actually changing the value in the cell, the ROUND function, alters the value of the data.

    Using this function to round data could, therefore, significantly affect the results of calculations.