Thread: True/false

When comparing two cells, e.g. =J369=P407, to show if they are the same, the result is sometimes FALSE, even though the numbers look identical (displaying 2 decimals). I suspect that one of the numbers has a different 3rd decimal due to rounding.
Is it possible to tell him to look only at the 2 displayed decimals when making the comparison, and disregard the other decimals?

Try: =ROUND(J369,2)=ROUND(P407,2)

Hi peri,

another option could be to use Trunc function if you want to completely ignore the decimal part, see below:-

=trunc(J369)=trunc(p407)

Regards,
DILIPandey

<click on below 'star' if this helps>