How To Set Rounding In Excel

The Rounding Precision feature in Excel can be used to prepare the issue of rounding or floating betoken errors in Microsoft Excel. You will find below the steps to set Rounding Precision in Excel.

Set Rounding Precision in Excel

As yous must be enlightened, Microsoft Excel displays rounded numbers (for example 4.56) and not the bodily numbers (iv.557321) in Excel spreadsheets.

However, when it comes to calculations, Excel uses the bodily numbers (which tin can be up to 15 decimal points) and non the rounded numbers every bit displayed in the worksheet.

This results in Excel rounding errors, which can lead to cases of clients/customers claiming errors in Excel spreadsheets, based on their transmission spot checks using calculators.

A solution to such rounding or floating indicate errors in Excel is to forcefulness Microsoft Excel to use displayed numbers in all calculations, instead of using the actual numbers.

This can be accomplished using the "Rounding Precision" feature equally bachelor in "Advanced options" in Microsoft Excel.

Dangers of Using Rounding Precision in Excel

Before going ahead with the steps to set Rounding Precision in Excel, you lot demand to exist enlightened that setting Rounding Precision on an already built spreadsheet can permanently impact its accuracy.

Hence, employ this characteristic only if you are trying to match numbers and you are OK with Excel spreadsheet losing its default (fifteen decimal places) accuracy.

Steps to Set Rounding Precision in Excel

Follow the steps beneath to Set Rounding Precision in Excel.

1. Open Microsoft Excel and click on the File tab located in the elevation-left corner of your screen.

2. On the side by side screen, scroll downwardly to the bottom in side-bill of fare and click on the Options tab.

three. On Excel Options screen, click on the Advanced tab in the left-pane. In the correct-pane, scroll all the way down and select Set Precision Equally Displayed option located under "When Calculating This Workbook" department.

Annotation: You can select current or unlike Excel Workbook by using the downwards arrow located adjacent to "When calculating this workbook" entry.

4. Once yous check "Set precision as displayed" box, yous will meet a warning pop-upwards. Click on OK to confirm.

v. Click on the OK button in the Advanced tab (encounter epitome in stride#three) to save the to a higher place changes.

6. Next, click on the Home Tab and select your desired number of decimal places (2 or more) for this particular worksheet.

After this, Microsoft Excel will set Rounding precision for this particular worksheet to two decimal places.

How to AutoFit Column Width and Row Meridian in Excel
How to Automatically Fill-in Files in Excel