True/false

[peri1224]

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?

[zbor]

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

[peri1224]

Thanks, works perfectly.
Can't seem to find the Edit button to change the thread to Solved.
Also how to give credit?

[dilipandey]

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>