Forum Discussion
Compare two cells FALSE and TRUE problem
Dear all, I have a problem when comparing two cells (let's say A10 and D22). The number in A10 results from a sum of several cells (TTL is 121,355), the figure in D22 is just this number (121,355)....
ChantalH Perhaps the summed number isn't exactly 121,355. Increase the number of decimals displayed to 15 and you might find that it's not all zeroes. To fix that, use ROUND(SUM( - - - -- ),0) to be sure that the summed value is rounded to zero decimals.
Dear Riny, you were right, there were some decimals, which were just not shown in the cell. So now my formula does work and says TRUE.
Thank you very much for your prompt and accurate reply.
Thank you very much for your prompt and accurate reply.