Ho To Correct Underbite

How rounding a value in Excel? Nobody

How to round a number in Excel?

To round a number in Excel will propose 2 methods:

1. default Menu
2. ROUND function

DEFAULT MENU

This method is the most direct and convenient to do so. All you have to do is the following:
a) Once you select the cell or range of cells, go to Format Menu .
b) Select the submenu cells.

a) Select the Number tab .
b) selected in the box Category option Number .
c) label Now Show choose with the arrows, the decimal places, ie the number of decimal places you want to add the value.

ROUND function

Another different method to round a numeric value, but not more complex, is using the ROUND function . To explain this role and let me exemplify variables using 2 exercises:

1. Rounding value in a cell manual
2. Round output value a formula

1 .- Round value in a cell manual

Assume that particular cell has a value of 100.2356 . However, it would reduce the number of decimal places or set the value 100.2356 no tenth.

To resolve this problem I will use the ROUND function. The structure of the function is: = POWER (NUMBER, NUMBER OF DECIMAL) .

The procedure is as follows:

a) Writing in the cell where you want the result, the sign = ROUND (

b) Add the number or value you want Round. This can write it manually or you can select the cell where the value is. In this case the number 100.2356.

c) Add immediately after the number to round the sign, or ; this depending on the settings your keyboard.
d) Now add the number of tenths , ie the number of decimal places with which he intends round. For this example rounded 0 pp.

e) After adding the number of tenths close the function with parentheses ) and now you can press ENTER or OK.

The result of rounding to 0 tenths of 100.2356 is 100.
Other examples:
rounding to 1 decimal: = ROUND (100.2356,1). Result: 100.2
rounding to 2 decimal places: = ROUND (100.2356,2). Result: 100.23 Rounding to 3 decimal
: = ROUND (100.2356,3). Results: 100,235


2 .- Round output value from a formula
For this exercise, imagine that the value 100.2356 is the result of an arithmetic operation, the value 5.01178 (Located in cell A2 ) multiplied by the value 20 (Located in cell B2 ).
Note the formula in cell C2 , which is 100.2356 is the result of the multiplication = B2 * C2 :


For this problem once again be using the function ROUND. The structure of the function is: = ROUND (NUMBER, NUMBER OF DECIMAL) .


The procedure changes only slightly and would be:


a) Write the cell where you want the result, the sign = ROUND (
b) Add the number or value you want Round. The value after paretensis will, assuming they made directly in cell C2 , A2 * B2.
c) Add immediately after the number to round the sign, or ; this depending on the configuration of your keyboard.
d) Now add the number of tenths , ie the number of decimal places with which he intends round. For this example rounded 0 tenths.
e) After adding the number of tenths close the function with parentheses ) and now you can press ENTER or OK.

The result of rounding 0 tenths of A2 ( 5.01178) * B2 ( 20 ) = 100.2356 is 100 .
Other examples:
rounding to 1 decimal: = ROUND (A2 * B2, 1). Result: 100.2
rounding to 2 decimal places: = ROUND (A2 * B2, 2). Result: 100.23 Rounding to 3 decimal
: = ROUND (A2 * B2, 3). Results: 100,235


** The equivalent function ROUND in English is ROUND.

** Remember that the sign = should always be at the beginning of any formula.
** If your computer is configured in the language ENGLISH , you may need to use , instead of ; This observation, the stress for those who prefer to manually write the complete formula instead of using the mouse cursor or when choosing to join the ranks.
** ROUND only operate only with numeric values, but NEVER type characters TEXT .
** Remember that the wording of the formulas should never have spaces between one character to another.



Posted by: Julio Rosales V.