Error in calculation

Copper Contributor

IN THIS SHEET IF I CHANGE VALUE OF J10 TO =B10/C10 THE RESULT IS SAME BUT J15 SHOWS TOTAL 204.65 WHICH IS ERROR CAN SOMEBODY EXPLAIN WHY?

2 Replies

@ZeeRemixes Hello! You've posted this in the Microsoft Mechanics content, which is a space for discussing Microsoft Mechanics content. I'm moving this to the Excel discussion space - please post Excel questions there in the future.

Because B10/C10 is not exactly 17.67, but 17.665. You can round it, if you prefer:

=ROUND(B10/C10,2)