Q:

# How do you round numbers in Excel?

A:

Though there are several functions in Excel for rounding numbers, the ROUND function is the most basic and the most commonly used. Keep in mind that when using any rounding function, its result is always treated as rounded by any formulas that reference it and can potentially alter calculations.

## Keep Learning

1. Type the start of the function in the cell of your choice

Select a cell to display the rounded figure. If the cell is not empty, it must be cleared of its contents so that it can accept the necessary function. Once clear, type "=ROUND(".

2. Input a number to round or a cell reference

Type the number you would like to round as the first argument of the ROUND function. Alternatively, you can choose to round data from another part of your spreadsheet by entering a cell reference. Follow this first argument with a comma.

3. Enter the number of digits to round the number to

For the second argument, enter the number of digits to round the number up or down to. Then, close the function with a closed parenthesis. Use positive integers to round to a decimal place and negative integers to round a numbers place. For example, "=ROUND(123.456, 2)" outputs 123.46, whereas "=ROUND(123.456, -2)" outputs 100.

Sources:

## Related Questions

• A: The average function on Excel allows you to find the average of a list of numbers, named ranges, arrays or cell references. This project takes just a few m... Full Answer >
Filed Under:
• A: Add values in Microsoft Excel using the SUM function =SUM ( Number1, Number2, ... Number255 ), which adds up columns or rows of numbers. "Number" represent... Full Answer >
Filed Under:
• A: There are two basic ways of calculating variance in Excel using the function VAR or VAR.S. These functions can then calculate variance in several ways: use... Full Answer >
Filed Under:
• A: Use the DATE function in Excel to list dates. Use the TODAY function to list the current date or the NOW function to list current date and time.... Full Answer >
Filed Under:
PEOPLE SEARCH FOR