Precision

When working with numbers and formulas in Excel, you may occasionally find your results to be a little different than you expected. This could be due to how Excel computes and rounds values. Check out the following articles to understand how Excel treats numbers and how you can get the most precise results possible.

Tips, Tricks, and Answers

The following articles are available for the 'Precision' topic. Click the article''s title (shown in bold) to see the associated article.

   Avoiding Rounding Errors in Formula Results
Some formulas just don't give the results you expect. Sometimes this is due to the way that Excel handles rounding. Here's what you can do to avoid rounding errors in your formulas.

   Errors When Subtracting
When you subtract two numbers from each other, you have a certain expectation of what Excel should deliver. What if you get something that is not quite what you expected, however?

This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing