You have to have the formula actually in B2, and it would need to look like the
following, with the 'Something Else' bit being whatever formula you currently
have in there.

=IF(AND(C1=C2,B1=B2),0,'Something Else')

eg

=IF(AND(C1=C2,B1=B2),0,D22/G66)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------



wrote in message
...
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

.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003