Excel Formula doesn't calculate correctly

Question

Hope someone can help point me in the right direction.

This formula is not calculating correctly in my Excel 2010  workbook.

  =SUM(B10:E10)-G10 

Evaluate formula shows:

           1st                    =SUM(B10:E10)-G10    

           2nd                              =2,340.28-G10

           3rd                               =2,340.28-0

           4th                               =2,331.31

Total should be   2,340.28

  The workbook is set to automatically calculate  and is the only workbook open.  Hitting F9 does nothing.  Closing and re-opening does nothing.  If I re-enter or change one of the amounts from the input cells the formula will automatically recalculate correctly.  If after making a change I hit undo the formula stays correct and does not go back to the incorrect calculation.

Can any one tell me what may be causing this problem?   My concern is that I have hundreds of workbooks with formulas that I assume are calculating correctly and it was only dumb luck that I happened to notice this slight discrepancy shown above.

Thank you.

Answer 1

I do not have many workbooks but having erroneous returns on simple, basic formulas is very annoying.  I have noticed dysfunction on the most basic of worksheets, like arriving at a sum total that has a $xxx.57 answer when every one of the the numbers to be added is a straightforward round Dollar amount, formatted as Accounting with 2 decimals, and not a single one of the numbers is a calculation.

Can I trust this program AT ALL?  Does Microsoft take any action on this kind of problem?  What risk is there that the same issue continues with Office 365?

Answer 2

I do not have many workbooks but having erroneous returns on simple, basic formulas is very annoying.  I have noticed dysfunction on the most basic of worksheets, like arriving at a sum total that has a $xxx.57 answer when every one of the the numbers to be added is a straightforward round Dollar amount, formatted as Accounting with 2 decimals, and not a single one of the numbers is a calculation.

Can I trust this program AT ALL?  Does Microsoft take any action on this kind of problem?  What risk is there that the same issue continues with Office 365?

What you describe is unusual.  Kindly post a copy of your workbook, showing the dysfunctional results, to a public site such as OneDrive, and post a link here, so one of us can see exactly what is going on.