How To Round To 2 Decimal Places In Excel

If you don't want to show decimal values in Excel, you can simplify your numerical data using the ROUND functions. Excel offers iii functions: Round, ROUNDUP, and ROUNDDOWN. Permit's take a expect at how they piece of work.

Using the ROUND functions in Excel is different than changing the number's format. When yous change how a number is formatted, yous're just changing how it looks in your workbook. When yous change a number using the Round functions, you're changing how it looks and how information technology's stored.

The Round function rounds numbers to a specified number of decimal places. Information technology rounds a number down if the digit in the adjacent decimal place to the right is between aught and four, and information technology rounds upwards if that digit is five to nine. And every bit you might expect, the ROUNDUP office e'er rounds upwardly and the ROUNDDOWN function always rounds down.

Round Off Decimal Values Using the Round Function

The Circular role rounds numbers to a sure number of decimal places that you configure. If the adjacent digit to the right is between zero and 4, it rounds downward. So, for example, if you were rounding downward to two decimal places, eight.532 would get viii.53. If the next digit is betwixt v and nine, it rounds upwards. Then, viii.538 would become 8.54. The ROUND part can round numbers to the right or left of the decimal betoken.

You lot can utilise the format to empty cells or to cells that already accept numbers in them. You can likewise use Round as office of a more complicated formula if y'all want to. For example, you lot could create a formula that adds 2 columns together using the SUM function, and then rounds the result.

For this example, we've got a column of numbers named "Values" that contains our raw numbers. We're creating a second column named "Results" that we're going to apply to round down the numbers in the "Values" column to three digits.

Select the jail cell where you want your rounded results to become.

Navigate to the "Formulas" menu on the main ribbon.

Click the "Math & Trig" formulas drop-downwardly menu.

On the "Math & Trig" drop-down menu, click the "Circular" function.

This pops up the Role Arguments window with the fields yous'll utilise for setting the Circular function.

Utilise the "Number" field for the number you lot want to round. You lot tin can apply type a straight upwardly number in this field to circular it, simply more oftentimes you lot'll want to call a number from an existing jail cell in your canvass. Here, we're using B6 to specify the top cell in our "Values" column.

Utilize the "Num_Digits" field to specify how many digits the resulting number should have. You accept some choices here:

Positive Integer: Use a positive integer (such equally 1, 2, and then on) to specify the number of digits afterthe decimal place to which you want to circular. For example, inbound "3" would round to iii places after the decimal point.
Zero: Enter "0" to circular to the nearest integer.
Negative Integer: Employ a negative integer (such as -1, -2, and and then on) to round to left of the decimal place. For example, if you were rounding the number 328.25 and input "-1" here, information technology would round you number to 330.

In our example, we're inputting "3" and so that it will round our result to three places after the decimal point.

When you're washed, click the "OK" button.

And equally you can encounter, our number is at present rounded in the Results column.

You lot tin easily apply this formula to the rest of the numbers in your set by beginning clicking on the lesser correct corner of the cell.

Then dragging to select the residuum of the rows that y'all want to round.

All of your values will now exist rounded using the same properties you selected. Yous can as well copy the cell to which you've already practical rounding, and and then paste to other cells to re-create the formula there.

You can also do all this just using Excel's Function bar if you want.

Select the cavalcade where you want your rounded numbers to go.

Click the Role bar to activate information technology.

Type in your formula using the syntax:

=ROUND(number,num_digits)

Where "number" is the prison cell you desire to round and "num_digits" identifies the number of digits to which you desire to circular.

For example, hither's how we'd type the same rounding formula nosotros previously applied using the dialog box.

Hit Enter (or Return) later on typing your formula, and your number is now rounded.

Circular Numbers Up or Down Using the ROUNDUP or ROUNDDOWN Functions

Sometimes, y'all may want your numbers to but round numbers upwardly or downwardly instead of having the next digit determine that for y'all. That's what the ROUNDUP and ROUNDDOWN functions are for, and and using them is pretty much identical to using the ROUND function.

Click the jail cell where you want your rounded outcome to become.

Head to Formulas > Math & Trig, and then cull either the "ROUNDUP" or "ROUNDDOWN" function from the dropdown bill of fare.

Enter the number (or cell) you lot want to round in the "Number" field. Enter the number of digits to which you desire to circular in the "Num_digits" field. And the same rules apply as with the ROUND function. A positive integer rounds to the right of the decimal point, zero rounds to the nearest integer, and a negative integer rounds to the left of the decimal point.

Click "OK" when you lot've got things set upwardly.

And just like with the Circular part, you lot can too set the ROUNDUP and ROUNDDOWN functions past typing them into the Part bar, and you tin can use them as parts of a larger formula.