If you don't want to show decimal values in Excel, you can simplify your numerical data using the ROUND functions. Excel offers three functions: ROUND OUT, ROUND and ROUND. Let's take a look at how they work.
Using the ROUND functions in Excel is different from changing the number format. When you change the format of a number, you are simply changing its appearance in your workbook. When you change a number using the ROUND functions, is changing its appearance and how it is stored.
The ROUND function rounds numbers to a specified number of decimal places. Rounds a number down if the digit of the next decimal to the right is between zero and four, and round up if that digit is five to nine. And how could we expect, the ROUND function always rounds up and the ROUND function always rounds down.
Round decimal values through the ROUND function
The ROUND function rounds numbers to a certain number of decimal places that you set. If the next digit to the right is between zero and four, rounds down. Then, as an example, if i were rounding down to two decimal places, 8.532 would become 8.53. If the next digit is between five and nine, rounds up. Then, 8.538 would become 8.54. The ROUND function can round numbers to the right or left of the decimal point.
You can apply the format to empty cells or cells that already have numbers. You can also use ROUND as part of a more complicated formula if you want.. As an example, you can create a formula that adds two columns using the SUM function and then rounds the result.
For this example, tenemos una columna de números denominada “Values” que contiene nuestros números sin procesar. Estamos creando una segunda columna llamada “Results” que usaremos para redondear los números en la columna “Values” a tres dígitos.
Select the cell where you want the rounded results to go.
Navigate to the menu “Formulas” on the main tape.
Haz un clic en el menú desplegable de fórmulas “Math & Trig”.
In the drop-down menu “Math & Trig”, haga clic en la función “ROUND OUT”.
The Function Arguments window will appear with the fields you will use to configure the ROUND function.
Utilice el campo “Number” para el número que desea redondear. You can use enter a direct number in this field to round it, but more often you will want to call a number from an existing cell on your sheet. Here, estamos usando B6 para especificar la celda superior en nuestra columna “Values”.
Utilice el campo “Num_Digits” para especificar cuántos dígitos debe tener el número resultante. You have some options here:
- Positive integer: Use a positive integer (What 1, 2, etc.) to specify the number of digits after the decimal place you want to round to. As an example, get into “3” se redondearía a tres lugares después del punto decimal.
- Zero: Please enter “0” para redondear al número entero más cercano.
- Negative integer: Use a negative integer (What -1, -2, etc.) to round to the left of the decimal place. As an example, if i rounded the number 328.25 and enter "-1" here, would round your number to 330.
In our example, estamos ingresando “3” para que redondee nuestro resultado a tres lugares después del punto decimal.
When it's over, Click the button “To accept”.
And as you can see, our number is now rounded in the Results column.
You can easily apply this formula to the rest of the numbers in your set by first clicking the lower right corner of the cell.
And then drag to choose the rest of the rows that you want to round.
All your values will now be rounded using the same properties you selected. You can also copy the cell that you have already applied rounding to and then paste it into other cells to copy the formula there.
You can also do all of this simply by using the Excel function bar if you wish..
Select the column where you want your rounded numbers to go.
Click on the function bar to activate it.
Write your formula using the syntax:
=ROUND(number,num_digits)
Where “number” es la celda que desea redondear y “num_digits” identifica el número de dígitos a los que desea redondear.
As an example, this is how we would write the same rounding formula that we applied previously using the dialog box.
Press enter (o Return) after writing your formula, and your number is now rounded.
Round numbers up or down with the ROUND or ROUND functions
Sometimes, you might want your numbers to just round numbers up or down instead of the next digit deciding for you. That's what the ROUND and ROUND functions are for, and using them is practically identical to using the ROUND function.
Click the cell where you want your rounded result to go.
Go to Formulas> Math and Trig, y después elige la función “ROUND OUT” O “ROUND OUT” in the drop-down menu.
Enter the number (or cell) que desea redondear en el campo “Number”. Ingrese el número de dígitos al que desea redondear en el campo “Num_digits”. And the same rules apply as with the ROUND function. A positive whole number is rounded to the right of the decimal point, zero is rounded to the nearest whole number and a negative whole number is rounded to the left of the decimal point.
Click on “To accept” cuando haya configurado las cosas.
And in the same way as with the ROUND function, you can also configure the ROUND and ROUND functions by typing them in the function bar, and you can use them as parts of a larger formula.
