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)....
Hi ChantalH
as you write the value in A10 is the result of the sum some other cells, I suspect that there might be some decimals, which are just not shown in the cell. You can easily find out if you click in the formula bar in hit the F9-key:
(After that, just hit ESC to get the formula back).
Another option would be that the figure in the other cell is not a number, but formatted as a text:
Dear DTE,
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.
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.