Excel doesn't round correctly

%3CLINGO-SUB%20id%3D%22lingo-sub-2618669%22%20slang%3D%22en-US%22%3EExcel%20doesn't%20round%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2618669%22%20slang%3D%22en-US%22%3E%3CDIV%3EExcel%20doesn't%20round%20correctly%20like%20in%20red%20cells.%3C%2FDIV%3E%3CDIV%3EThe%20equation%20in%20the%20third%20row.%3C%2FDIV%3E%3CDIV%3EWhat's%20the%20reason%3F%3C%2FDIV%3E%3CDIV%3EI%20want%20it%20to%20be%20normal%20round%3C%2FDIV%3E%3CDIV%3EIf%20the%20third%20number%20after%20comma%20%26gt%3B%3D5%20round%20it%20up%2C%20if%26lt%3B5%20round%20down.%3C%2FDIV%3E%3CDIV%3Ethe%20round%20worked%20for%20some%20numbers%20but%20not%20to%20another%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2618669%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2618715%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20doesn't%20round%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2618715%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1122000%22%20target%3D%22_blank%22%3E%40Omar_Muhammad%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EActually%20the%20result%20is%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20373px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301041i7257294FE83C9912%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThat%20is%20floating%20point%20error%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Ffloating-point-arithmetic-inaccurate-result%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EFloating-point%20arithmetic%20may%20give%20inaccurate%20result%20in%20Excel%20-%20Office%20%7C%20Microsoft%20Docs%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fblog%2F2008%2F04%2F10%2Funderstanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EUnderstanding%20Floating%20Point%20Precision%2C%20aka%20%E2%80%9CWhy%20does%20Excel%20Give%20Me%20Seemingly%20Wrong%20Answers%3F%E2%80%9D%20%7C%20Microsoft%20365%20Blog%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
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
 
1 Reply