Are you staring at your Microsoft Excel spreadsheet wondering why the calculations are not adding up properly?
Here are a few things to find out if your Excel spreadsheet is calculating wrong.
You will need to find and unhide these rows if they are causing your spreadsheet to calculate unexpected totals.
An example of a hidden row causing confusion with math.
At first it looks like the sum should be shown as 1050.
Check to see if decimals are hidden by highlighting all cells with numbers, then selecting Format Cells.
Increase the Decimal places to 30 to see everything.
you’re able to learn more about Circular References in Excelon Microsofts website.
