Error in calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-2247358%22%20slang%3D%22en-US%22%3EError%20in%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2247358%22%20slang%3D%22en-US%22%3E%3CP%3EIN%20THIS%20SHEET%20IF%20I%20CHANGE%20VALUE%20OF%20J10%20TO%20%3DB10%2FC10%20THE%20RESULT%20IS%20SAME%20BUT%20J15%20SHOWS%20TOTAL%20204.65%20WHICH%20IS%20ERROR%20CAN%20SOMEBODY%20EXPLAIN%20WHY%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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)