Hi,

I have an issue with IF formula as explained below.

A1=102.10
B1=102.103

C1=IF(A1=B1,"EQUAL","UN EQUAL")

All the 3 cells are formatted to general.I just want excel to consider only 2 decimals for equation.I just want to ignore the 3rd decimal in Cell "B1".

If that's the case the result should show "EQUAL".

How can i achieve that? Can anyone help me?

Thanks,

Netaji