Rounding - a mathematical operation that reduces the number of characters used for the fixation of a number by a certain reduction of its accuracy.In Excel rounding operation can be carried out automatically.At the same time it allows you to round off both fractional and integer.

Rounding fractions


rounding of fractional numbers allows the user to set a specified number of decimal places in the decimal to be displayed in the cell, regardless of the actual number of characters included in the program.In order to carry out the operation of rounding, you must using the left mouse button to select a cell or a numeric array, in respect of which it should be produced.If you want to round two or more numbers or an array, located in different parts of the table, you can select them by holding down CTRL.

Conduct operation of rounding a fractional number by selecting from the top menu tab "Format" and then clicking the left mouse button on the position of "Cell."This action will bring up the menu required for the transaction.In addition, go to this menu it is possible and in another way: by right-clicking on the highlighted section of the table and selecting the "Format Cells."

In this menu, select the number format of the cell and in a special box, note the required number of decimal places.For example, if this parameter was set to a value of 2, the initial fraction of the form 1.58165874, rounded off has undergone, will take the form of 1.58.

Rounding integers


In addition, the program also allows you to make an Excel rounding operation in respect of integers, making them easier to understand.This can be done by resorting to the use of special function denoting rounded.It should be borne in mind that the same way of performing the desired action and can be used in relation to fractions.

This function takes two arguments.The first of them - a numeric array or a cell in respect of which it is necessary to carry out an operation of rounding.The second argument to this function - the number of places for rounding.Positive bits are used for fractional rounding of numbers, and the numeral indicating the category, in this case is the number of decimal places.Zero discharge entail rounding the number to an integer value, and the negative - rounding up to a certain discharge.For example, the discharge of -1, will cause rounding to dozens, -2 rounds the number to the hundreds, and so on.

As a result, a function used for this operation is as follows.For example, there is a need rounding number 101 located in cell A3, to hundreds.In this case, the function should be written as follows: = ROUND (A2; -2).The use of this function will provide display in cell A3 as a specified number 100.