News for hackers. Stuff that matters.
Re:42 is found to be the sum of three cubes by Tuna-Fish on Friday September 06, 2019 @10:54AM (#20896179)
Because the numbers cubed are way larger than the numbers that Excel can represent precisely. Excel uses 64-bit IEEE 754 floats for all arithmetic. They can be used to accurately describe integers smaller than 2^53, or ~10^16. The first number cubed is ~-5*10^50, so you are very clearly outside the range where excel is precise.

You should not use Excel to do any serious mathematics, or really anything else where numerical precision is important.

Re:42 is found to be the sum of three cubes by colejohnson66 on Friday September 06, 2019 @02:25PM (#20898313)
Why is it that a program that people use for accounting doesn’t use arbitrary precision arithmetic?
Re:42 is found to be the sum of three cubes by jz391 on Friday September 06, 2019 @02:44PM (#20898540)
Because for accounting the numbers easily fit in the supported range; even the US National Debt (https://www.usdebtclock.org/)...