Advice 1: How to round all numbers in Excel

Automatic implementation of arithmetic operations in Excel is certainly a convenient feature that considerably facilitates work with large data sets. However, as a result, for example, division can get a number with lots of decimal places. In this situation it is necessary to do the rounding.
How to round all numbers in Excel
The operation of rounding numbers in Excel are fairly simple, so it will not cause special difficulties even for the beginner. At the same time, like most other operations, it can be applied to individual numbers or to the whole array of the desired numbers.

The choice of array for rounding


In order to give the program to understand what part of the database should extend the operation of rounding, it is necessary to allocate a portion of the array, subject to its implementation. This can be done by clicking the left mouse button on the desired cell and stretching the field highlight to the desired number of cells. However, in the process you may find that the array to be rounded is discrete, i.e., discontinuous. One of the most obvious but also the most time consuming of the options in this case will alternate rounding in each part of the array. You can do it simpler: when implementing the selection, press and hold the Ctrl key. This will allow you to select with the mouse the intermittent data sets, against which you can later implement a common operation. Finally, the third way is to set the data array to be rounded up with a formula.

The operation of rounding fractions


In order to produce the rounding of allocated numbers, should click on one of the cells in the region subjected to selection with the left mouse button. This will bring up a menu, one of which is "Format cells" - it should select. In the menu in turn, you will see several tabs: the settings you want are located under the tab "Number." This section allows you to select the type of numbers that is in the selected cells. In order to carry out the operation of rounding, it is necessary from the offered list to choose the format labeled "Numeric". Selecting this format will bring up a menu with additional settings. One of the items on this menu is the number of decimal places, which you can choose on your own. In this case the number written in each of the rounded cells, will not change as a result of this operation, since only changes the format of his images. Thus, you can likewise go back to the original format or select another type of rounding.

Rounding integers


In order to carry out the rounding of integers, use the round function. In parentheses after the symbol add function the first argument is the name of the cell or specify the dataset to which to apply the operation, and the second argument is the number of significant digits to be used when rounding. The same method can be used for rounding off fractions. So, bit 0 will cause the rounding of a number to an integer value. The discharge equal to 1, rounded to 1 digit after the decimal point. Category -1 - rounding up to the first ten. Suppose you want to round the number 1003, located in cell A2 to the nearest thousand. In this case, the function will look like this: =round(A2,-3). The result in the specified cell will display the number 1000.

Advice 2 : How to round numbers in Excel

Excel is a convenient program designed for processing digital arrays. One of the useful functions available in this program is the possibility of rounding of individual numbers and entire numeric arrays.
How to round numbers in Excel
Rounding is a mathematical operation that allows to reduce the number of digits used to record a number, at the expense of some reduction of accuracy. In Excel, the rounding operation can be done automatically. While it allows you to round decimal and whole numbers.

Rounding fractions


Rounding decimals allows the user to set a specified number of decimal places in decimal fractions, which appears in the cell regardless of the actual number of such marks that you made in the program. In order to carry out the operation of rounding, you must use the left mouse button to select a cell or numeric array in respect of which it should be done. If you want rounding two or more numbers or array located in different parts of the table, highlight them by holding the CTRL key.

To carry out the operation of rounding fractional numbers by choosing in the top menu tab "Format" and clicking the left mouse button at the position of the "Cell". This action will bring up the menus necessary to perform the operation. In addition, go to this menu and other method: right click mouse on a selected area of the table and selecting "Format cells".

In this menu you should choose the number format of cells in a window to mark the right number of decimal places. For example, if this parameter is set in the form of figure 2, the original fraction of the form 1,58165874 subjected to rounding takes the form of 1.58.

Rounding integers


In addition, Excel also allows you to perform the operation of rounding for whole numbers, making them easier to understand. You can do this through the use of special functions, referred to rounded. It should be borne in mind that the same way to perform the necessary actions you can use in relation to fractions.

The function has two arguments. First of all, the cell or numeric array in respect of which it is necessary to carry out the operation of rounding. The second argument of this function is the number of digits for rounding. Positive discharges are used for rounding floating point numbers, and the number representing the category, in this case equal to the number of decimal places. Zero discharge will entail rounding the number to an integer value, and a negative rounding to a certain digit. For example, the discharge of -1 will cause rounding to tens, -2 will round the number to hundreds, and so on.

As a result, the function used to implement this operation, would look like the following. For example, there is a need to round numbers 101, located in cell A3, to hundreds. In this case, you should write a function like this: =round(A2, -2). This feature will provide the display in cell A3 the number specified in the form of 100.

Advice 3 : How to round numbers in Excel - different ways

Rounding is a mathematical operation that reduces the number of significant digits in a number. It's easy to do in Excel, and in different ways, depending on the desired result.
How to round numbers in Excel - different ways

The first method. Highlight one or more cells that contain numbers that should be rounded. On the Home tab under "Number" select "Decrease a bit". Press the desired number of times. With each click after the decimal point will remain at one digit less.

The second method. Highlight one or more cells that contain numbers that should be rounded. Click the right mouse button, choose "Format cells". On the tab "Number" choose the format "Numeric", to specify the number of decimal places (decimal places).

The third way. Use the "rounded". Put the cursor in the cell where you wish to get a result – for example, near the original number. Type the formula: =round(number; chiseled), where number is a reference to the original number, chiseled – the number of digits after the decimal point. In this case, if the number of digits to put a negative, the number will be rounded to a certain digit. For example, cell A1 is the number 314. If we write the formula =round(A1, -1), the result is 310, if you write the formula =round(A1, -2), the result is 300.

The fourth method. Using OKRUGLI" rounds a number to the desired precision. For example, if a given formula =OKRUGLI(A1;10) our number 314 will be rounded up to 310, with a given formula =OKRUGLI(A1;100) number 314 will be rounded to 300.

Is the advice useful?
Search