13 ms·
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 t
by thunfischtoast 3y 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.
- tombert 3y agoShot 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.
- airstrike 3y agoanother 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