Excel calculations

Copper Contributor
 
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

@Japie41026 

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