Tips, Tricks, and Answers

The following articles are available. 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?