Excel doesn't round correctly

[Omar_Muhammad]

Excel doesn't round correctly like in red cells.

The equation in the third row.

What's the reason?

I want it to be normal round

If the third number after comma >=5 round it up, if<5 round down.

the round worked for some numbers but not to another

[#2]

@Omar_Muhammad 
Actually the result is

That is floating point error

Floating-point arithmetic may give inaccurate result in Excel - Office | Microsoft Docs

Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?” | Micr...