Precision

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.

Understanding Apparent Math Errors
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?

Understanding Negative Zero Amounts in Excel
There are negative numbers, positive numbers, and zero—which is neither positive or negative. So why does Excel sometimes show a negative sign in front of a zero value?