This post will guide you how to **avoid rounding errors** in floating point arithmetic in excel. How do I avoid rounding errors in formula results in excel. Many combinations of arithmetic operations on floating point numbers may produce results that appear to be incorrect by very small amounts or rounding errors in cell, how to avoid this error.

**Avoiding Rounding Errors**

You can use the Precision as displayed option to avoid rounding errors for floating point arithmetic in excel. Just do the following steps:

** #1** go to

**tab, click**

**File****, the Excel Options dialog will appear.**

**Options****#2** click ** Advanced **tab, select the workbook that you want in the

**, check the**

**When calculating this workbook****box, and click**

**Set precision as displayed****button.**

**OK**** #3** right click the cells that you want to format, and click

**from the drop-down menu list. The**

**Format Cells****dialog will appear.**

**Format Cells**** #4** switch to

**tab, click**

**Number****under**

**Number****list, then type a number into the**

**Category****box to set the number of decimal places that you want. Click**

**Decimal places**

**O**

**K****button.**

** #5** let’s see the result.

## Leave a Reply

You must be logged in to post a comment.