Sorry like this

A B C
113 123 15
10 123 15

I want to get B2 to equal 0 if and only if c1=c2 and b1=b2

-----Original Message-----
can AND be put into an IF statment to make two arguments.

Like If C2=C3 AND B2=B3 ,B3=0,...

any suggestions

.