excel is adding extra numbers in the 16 decimals when summing

i am dealing with excell to check calculation of students and i do all basic calculations and the checks using AND and IF formulas , i discovered many times the logical check of some SUMS were false even it was visible up to 4 decimal points that is correct i wanted to check further so i increased the decimals to 25 and i saw extra numbers are added in the 16decimal digit even if you do the summation with calculator or hand you will not reach this decimal point 16th .... it happens many times with , i hope any one can help , its weired
as you can see in attachment the circled part in check row is the subraction of the two cells above directly and non of the two numbers have a 16decimal number yet the value in sustraction is showing extra number 9 , also its repeated in the other next columns put with number 45 , and the last column in check row showing false is the result check of the previous numbers are they equal or no and it was false , so from this check i discovered something wrong .
if any one has similar issue let me know and is there a solution


excel decimal error.JPG

Welcome to the forum.

This is a long-known issue - it's a floating point error. See here: https://www.microsoft.com/en-us/micr...wrong-answers/

Round your values to the required/justifiable degree of precision

=ROUND(formula,6) will round to 6 decimal places. Adjust as needed.

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.