Home

Excel roundup decimal 0.15 problem

%3CLINGO-SUB%20id%3D%22lingo-sub-729748%22%20slang%3D%22en-US%22%3EExcel%20roundup%20decimal%200.15%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729748%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%22%3Ehttps%3A%2F%2Ftwitter.com%2Fmessages%2Fmedia%2F1145015162853662724%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-729748%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%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729787%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20roundup%20decimal%200.15%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729787%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%3EDuplication%20of%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FExcel-roundup-decimal-0-15-problem%2Fm-p%2F729749%23M33729%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FExcel-roundup-decimal-0-15-problem%2Fm-p%2F729749%23M33729%3C%2FA%3E%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
1 Reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies