How to round result in Excel – formulas

One of the popular mathematical procedures that people often use when working with Excel spreadsheets is rounding numbers. Some beginners try to use the number format, but it is not designed to display exact numbers in cells, which results in errors. To get the desired result after rounding, you must use special functions that are designed for this mathematical operation. You need to get to know each of them in more detail.

ROUND function

The simplest function with which you can round a numeric value to the required number of digits is ROUND. The simplest example is rounding a decimal from two decimal places to one.

It is important to remember that this function only rounds away from zero.

The appearance of the ROUND formula: ROUND(number, number of digits). Argument expansion:

1. Number of digits – here you must specify the number of digits to which the numeric value will be rounded.
2. Number – this place can be a numeric value, a decimal fraction, which will be rounded.

The number of digits can be:

• negative – in this case, only the integer part of the numerical value (the one to the left of the decimal point) is rounded;
• equal to zero – all digits are rounded to the integer part;
• positive – in this case, only the fractional part, which is to the right of the decimal point, is rounded.

Setting methods:

1. In order to get a number rounded to tenths as a result, you need to open a window with setting the function arguments, enter the value “1” in the “number of digits” line.
2. To round a numerical value to hundredths, you need to enter the value “2” in the function arguments settings window.
3. To obtain a numerical value rounded to the nearest thousand, in the window for setting arguments in the line “number of digits” you must enter the number “3”.

ROUNDUP and ROUNDDOWN functions

Two more formulas that are designed to round numerical values ​​in Excel are ROUNDUP and ROUNDDOWN. With their help, you can round fractional numbers up or down, regardless of which last digits are in the numerical value.

KRUGLVVERH

With this function, you can round a numeric value from 0 up to a given number. The appearance of the formula: ROUNDUP(number, number of digits). The decoding of the formula is the same as that of the ROUND function – the number is any numeric value that needs to be rounded, and in place of the number of digits, the number of the number of characters to which the general expression needs to be reduced is set.

ROUND DOWN

Using this formula, the numerical value is rounded down – starting from zero and below. Function appearance: ROUNDDOWN(number, number of digits). The decoding of this formula is the same as that of the previous one.

ROUND function

Another useful formula that is used to round various numerical values ​​is ROUND. It is used to round a number to a certain decimal place in order to obtain an accurate result.

Rounding instructions

The most common example of a formula for rounding numeric values ​​is the following expression: Function(numeric value; number of digits). Rounding example from a practical example:

1. Select any free cell with the left mouse button.
2. Write the sign “=”.
3. Select one of the functions – ROUND, ROUNDUP, ROUNDDOWN. Write it right after the equal sign.
4. Write the required values ​​in brackets, press the “Enter” button. The cell should display the result.

Any functions can be set through the “Function Wizard” to a specific cell, prescribe them in the cell itself or through the line for adding formulas. The latter is indicated by the symbol “fx”. When you independently enter a function into a cell or line for formulas, the program will display a list of possible options to simplify the user’s task.

Another way to add functions to perform various mathematical calculations is through the main toolbar. Here you need to open the “Formulas” tab, select the option of interest from the list that opens. After clicking on any of the proposed functions, a separate window “Function Arguments” will appear on the screen, in which you need to enter a numerical value in the first line, the number of digits for rounding – in the second.

It is possible to automatically display the results by rounding all numbers from one column. To do this, it is necessary to perform the calculation for one of the topmost cells, in the cell opposite it. When the result is obtained, you need to move the cursor to the edge of this cell, wait for the black cross to appear in its corner. Holding LMB, stretch the result for the entire duration of the column. The result should be a column with all the necessary results.

Important! There are several other formulas that can be used in the process of rounding various numerical values. ODD – rounds up to the first odd number. EVEN – Rounding up to the first even number. REDUCED – using this function, a numeric value is rounded to a whole number by discarding all digits after the decimal point.

Conclusion

To round numerical values ​​in Excel, there are a number of tools – individual functions. Each of them performs a calculation in a certain direction (below or above 0). At the same time, the number of digits is set by the user himself, due to which he can get any result of interest.