How To Use Roundup In Excel

Download Commodity

This wikiHow teaches you how to round the value of a cell using the Circular formula, and how to use jail cell formatting to display cell values as rounded numbers.

i

Enter the data into your spreadsheet.
ii

Highlight any jail cell(s) y'all want rounded. To highlight multiple cells, click the top left-nigh cell of the data, then elevate your cursor down and to the right until all cells are highlighted.

Advertisement
3
Click the Decrease Decimal button to show fewer decimal places. Information technology's the button that says .00 → .0 on the Habitation tab on the "Number" panel (the last button on that panel).
- Example: Clicking the Decrease Decimal button would modify $four.36 to $four.4.
4
Click the Increase Decimal button to show more than decimal places. This gives a more precise value (rather than rounding). Information technology's the button that says ←.0 .00 (likewise on the "Number" console).
- Case: Clicking the Increase Decimal button might change $2.83 to $two.834.
Advert

i

Enter the data into your spreadsheet.
2

Click a prison cell next to the ane y'all desire to round. This allows yous to enter a formula into the jail cell.
iii

Type "Circular" into the "fx" field. The field is at the acme of the spreadsheet. Type an equal sign followed past "Round" like this: =ROUND.
4

Type an open parenthesis after "Circular." The content of the "fx" box should now look similar this: =ROUND(.
v

Click the prison cell that you want to round. This inserts the prison cell's location (e.g., A1) into the formula. If you clicked A1, the "fx" box should at present look like this: =ROUND(A1.
six
Type a comma followed by the number of digits to round to. For example, if you wanted to round the value of A1 to 2 decimal places, your formula would so far wait like this: =Circular(A1,2.
- Use 0 equally the decimal place to circular to the nearest whole number.
- Employ a negative number to circular past multiples of 10. For instance, =Round(A1,-anewill circular the number to the next multiple of 10.
vii

Type a airtight parenthesis to end the formula. The final formula should look like this (using the example of rounding A1 2 decimal places: =Circular(A1,two).
8
Press ↵ Enter or ⏎ Return . This runs the Circular formula and displays the rounded value in the selected cell.
- You can supplant ROUND with ROUNDUP or ROUNDDOWN if yous know you want to circular up or round down to a certain number of decimal points.^[1]
- Similarly, the formula MROUND will round to the nearest multiple of any specified number.^[2]
Advertising

1

Enter your data series into your Excel spreadsheet.
two

Highlight whatever cell(s) you want rounded. To highlight multiple cells, click the top left-virtually cell of the information, then drag your cursor down and to the right until all cells are highlighted.
3

Right-click any highlighted cell. A menu volition appear.
4

Click Number Format or Format Cells . The name of this option varies by version.
five

Click the Number tab. It's either on the top or side of the window that popped upward.
half dozen

Click Number from the category list. It's on the side of the window.
seven
Select the number of decimal places yous want to round to. Click the downwards-arrow next to the "Decimal places" bill of fare to display the list of numbers, then click the one you lot want to select.
- Example: To round 16.47334 to 1 decimal place, select 1 from the menu. This would cause the value to be rounded to 16.v.
- Instance: To round the number 846.19 to a whole number, select 0 from the menu. This would cause the value to be rounded to 846.
8
Click OK . It's at the bottom of the window. The selected cells are at present rounded to the selected decimal place.
- To apply this setting to all values on the canvas (including those you add in the future), click anywhere on the sheet to remove the highlighting, and so click the Home tab at the top of Excel, click the drop-down menu on the "Number" panel, then select More Number Formats. Set up the desired "Decimal places" value, then click OK to make it the default for the file.
- In some versions of Excel, y'all'll accept to click the Format carte du jour, then Cells, followed by the Number tab to detect the "Decimal places" menu.
Advertising

Add New Question

Question

How do you round to ii decimal places in Excel?

This answer was written by one of our trained team of researchers who validated it for accuracy and comprehensiveness.

wikiHow Staff Editor

Staff Respond

Become to the "Math & Trig" menu in the "Formulas" tab. Select "Round" from the drib-down menu. In the "Number" field, enter the number you want to the circular or the ID of the cell containing the number. In the "Num_Digits" field, enter the positive integer "two" to bespeak that you want ii digits to appear after the decimal point.
Question

How do you round to the nearest whole number in Excel?

This reply was written by one of our trained team of researchers who validated it for accurateness and comprehensiveness.

wikiHow Staff Editor

Staff Answer

When you employ the "Circular" function, enter a -1 in the "Num_Digits" field. This indicates that you desire the rounding to happen just to the left of the decimal signal, and then yous will round to a whole number instead of a decimal.
Question

How practice you lot prove ii decimal places in Excel without rounding?

This answer was written past 1 of our trained squad of researchers who validated it for accuracy and comprehensiveness.

wikiHow Staff Editor

Staff Answer

To practice this, you can use the TRUNC ("Truncate") role. Write the formula =TRUNK, followed by 2 numbers in parentheses. The first is the number y'all desire to truncate, the 2nd is the decimal identify you'd like to display. Then, for example, =TRUNC(27.3476,ii) would give you 27.34, with no rounding.