SOLVED
Home

Excel roundup decimal 0.15 problem

%3CLINGO-SUB%20id%3D%22lingo-sub-729749%22%20slang%3D%22en-US%22%3EExcel%20roundup%20decimal%200.15%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729749%22%20slang%3D%22en-US%22%3Ehi%20team%2C%20Kindly%20look%20out%20the%20excel%20which%20i%20have%20added.%20can%20u%20pls%20checked%20the%20calculation.when%20i%20subtracted%20cell%20C%20with%20cell%20D%20i%20have%20result%20in%20cell%20cell%20E(here%20no%20issues).but%20when%20i%20round%20of%20the%20result%20i%20got%20answer%20in%20cell%20F(here%20is%20the%20issue).look%20out%20when%20decimal%200.25%20will%20be%20round%20to%200.3%20%26amp%3B%200.35%20to%200.4%20but%20why%200.15%20to%200.1%3F(expected%20is%200.2)%20yellow%20highlighted%20provide%20the%20answer%2Freason%3Fwe%20hav%20pblm%20in%20business.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fmessages%2Fmedia%2F1145015162853662724%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftwitter.com%2Fmessages%2Fmedia%2F1145015162853662724%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-729749%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%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729784%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20roundup%20decimal%200.15%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729784%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368753%22%20target%3D%22_blank%22%3E%40Neelakandan2408%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20since%2020.15-20%20actually%20is%20equal%20to%26nbsp%3B%3C%2FP%3E%0A%3CTABLE%20width%3D%22130%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20width%3D%22130%22%3E0.14999999999999900%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%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%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EThe%20workaround%20is%3C%2FP%3E%0A%3CPRE%3E%3DROUND(B1%2C1)-ROUND(A1%2C1)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-815959%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20roundup%20decimal%200.15%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815959%22%20slang%3D%22en-US%22%3E%3CP%3EI%20also%20can%20confirm%20that%20the%20actual%20%23%20is%200.149%20which%20rounds%20down%20and%20needs%20to%20have%20a%20%22round%22%20function%20added.%20Please%20mark%20the%20first%20comment%20with%20this%20answer%20as%20correct!%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368753%22%20target%3D%22_blank%22%3E%40Neelakandan2408%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-Aron%3C%2FP%3E%3C%2FLINGO-BODY%3E
Neelakandan2408
New Contributor
hi team, Kindly look out the excel which i have added. can u pls checked the calculation.when i subtracted cell C with cell D i have result in cell cell E(here no issues).but when i round of the result i got answer in cell F(here is the issue).look out when decimal 0.25 will be round to 0.3 & 0.35 to 0.4 but why 0.15 to 0.1?(expected is 0.2) yellow highlighted provide the answer/reason?we hav pblm in business.


https://twitter.com/messages/media/1145015162853662724
2 Replies
Solution

@Neelakandan2408 

That's since 20.15-20 actually is equal to 

0.14999999999999900

https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision...

The workaround is

=ROUND(B1,1)-ROUND(A1,1)

I also can confirm that the actual # is 0.149 which rounds down and needs to have a "round" function added. Please mark the first comment with this answer as correct! @Neelakandan2408 

-Aron

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies