Excel calculations

%3CLINGO-SUB%20id%3D%22lingo-sub-901919%22%20slang%3D%22en-US%22%3EExcel%20calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901919%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22pagination-view%22%3E%3CDIV%20class%3D%22identityBanner%20no-margin-bottom%22%3E%3CDIV%20class%3D%22identity%22%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EWhy%20does%20Excel%20give%20the%20answer%20as%200%20for%201234567893*1234567894%20-%201234567892*1234567895%20as%20it%20is%202%3F%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EExcel%20is%20correct%20with%20123*124-122*125%20and%201233*1234-1235*1232%20and%2012343*12344-12345*123452%20up%20to%2012345673*12345674-12345675*12345672%20but%20123456783*123456784-123456785*123456782%20it%20gets%20it%20wrong%20as%200%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EExcel%20rounds%20the%20answer%20for%2012345678%20and%20123456789%20up%20to%20the%20next%2010%20000%20on%20the%20last%20two%20-%20why%3F%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-901919%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901938%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422843%22%20target%3D%22_blank%22%3E%40Japie41026%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20keeps%20first%2017%20digits%20of%20the%20number%20(show%2015)%20and%20cut%20the%20rest.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
 
Why does Excel give the answer as 0 for 1234567893*1234567894 - 1234567892*1234567895 as it is 2?
Excel is correct with 123*124-122*125 and 1233*1234-1235*1232 and 12343*12344-12345*123452 up to 12345673*12345674-12345675*12345672 but 123456783*123456784-123456785*123456782 it gets it wrong as 0
Excel rounds the answer for 12345678 and 123456789 up to the next 10 000 on the last two - why?
1 Reply
Highlighted

@Japie41026 

Excel keeps first 17 digits of the number (show 15) and cut the rest.