SOLVED
Home

A calculation bug for Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-364286%22%20slang%3D%22en-US%22%3EA%20calculation%20bug%20for%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364286%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20would%20like%20to%20report%20a%20bug%20occurred%20with%20my%20excel.%20Would%20very%20much%20like%20to%20know%20if%20others%20experience%20the%20same.%3C%2FP%3E%3CP%3EOpen%20a%20new%20spreadsheet%3C%2FP%3E%3CP%3EType%209.83%20on%20A1%3C%2FP%3E%3CP%3EType%209.03%20on%20B1%3C%2FP%3E%3CP%3EType%20%3DA1-A2%20on%20C1%2C%20and%20it%20returns%200.8%3C%2FP%3E%3CP%3EType%200.8%20on%20C2%3C%2FP%3E%3CP%3EType%20%3DC1%3DC2%2C%20and%20it%20returns%20FALSE%20(!!)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20type%20%3DLEN(C1)%20on%20D1%2C%20it%20returns%2017%20(%3F%3F)%3C%2FP%3E%3CP%3EThen%20I%20type%20%3DLEN(C2)%20on%20D2%2C%20it%20returns%203%3C%2FP%3E%3CP%3ENot%20sure%20it%20is%20the%20reason%20the%20numbers%20do%20not%20match.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20interesting%20thing%20is%20it%20does%20not%20happen%20to%20all%20numbers%2C%20but%20only%20several%20numbers.%20I%20tried%209.83%2F9.73%2F9.63%20they%20all%20have%2017%20digits.%20Then%20on%209.53%20it%20returns%20to%20the%20correct%20number%20of%20digit.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20enlighten%20me%20if%20I%20have%20any%20wrong%20steps.%20Many%20thanks!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJoshua%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-364286%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364305%22%20slang%3D%22en-US%22%3ERe%3A%20A%20calculation%20bug%20for%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364305%22%20slang%3D%22en-US%22%3EWow%20I%20have%20no%20idea%20about%20floating%20numbers%20before!%20Thanks%20for%20the%20explanations%20Detlef!%3CBR%20%2F%3EJoshua%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364295%22%20slang%3D%22en-US%22%3ERe%3A%20A%20calculation%20bug%20for%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364295%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Joshua%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DPZRI1IfStY0%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFloating%20Point%20Numbers%20-%20Computerphile%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
joshuabut
New Contributor

Hi, I would like to report a bug occurred with my excel. Would very much like to know if others experience the same.

Open a new spreadsheet

Type 9.83 on A1

Type 9.03 on B1

Type =A1-A2 on C1, and it returns 0.8

Type 0.8 on C2

Type =C1=C2, and it returns FALSE (!!)

 

I type =LEN(C1) on D1, it returns 17 (??)

Then I type =LEN(C2) on D2, it returns 3

Not sure it is the reason the numbers do not match.

 

The interesting thing is it does not happen to all numbers, but only several numbers. I tried 9.83/9.73/9.63 they all have 17 digits. Then on 9.53 it returns to the correct number of digit.

 

Please enlighten me if I have any wrong steps. Many thanks!!

 

Joshua

2 Replies
Wow I have no idea about floating numbers before! Thanks for the explanations Detlef!
Joshua
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies