Hi,

If you mean to say that the value in A2 is the same in B2, then you can use in C2 : =IF((A2=B2),1,IF((A2<>B2),0))

Please note the my formula still needs some amendment when the values in A2 & B2 is 0, i do not know how to make this amendment

Thanks every body for further assistance

Regards