Hacker News new | ask | show | jobs
by thunfischtoast 831 days ago
Jokes on you, my Excel regularily thinks that two cells are not equal, despite both of them having exactly the same value and type (also no trailing spaces or these things). Copy and pasting it around sometimes solves the problem, but it never is apparent to me why that happens.
2 comments

Shot in the dark, but could this be some kind of IEEE floating point rounding shenanigans? Never had that issue in excel specifically, but I’ve certainly had that issue in C when trying to compare two floats that should be equal.
another shot in the dark but it could be different data types. some numbers can get stored as text when you import them. you can try wrapping your operands in VALUE() or TEXT() formulas accordingly

other than that, I agree with the other poster and the only issue I can think of is due to having a different number of digits after the decimal point causing some rounding error when comparing floats