Avoiding Rounding Errors in Floating Point Arithmetic

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 File tab, click Options, the Excel Options dialog will appear.

avoid round error1

#2 click Advanced tab, select the workbook that you want in the When calculating this workbook, check the Set precision as displayed box, and click OK button.

avoid round error2

#3 right click the cells that you want to format, and click Format Cells from the drop-down menu list. The Format Cells dialog will appear.

avoid round error3

#4 switch to Number tab, click Number under Category list, then type a number into the Decimal places box to set the number of decimal places that you want. Click OK button.

avoid round error5

#5 let’s see the result.

avoid round error4

Leave a Reply