Displaying decimals versus Rounding in Excel

This article describes a situation where there was a significant difference between the calculated and expected values.

The problem was caused by the way that Excel rounds values for display purposes, but the formula is calculating using the actual cell content.

Using the ROUND function can help resolve this type of problem.