I'm a little confused if you want the A2=A3 to be included in the AND
statement, and also don't know what you want to display if the conditions are
not met (I think you want the value in C5 to display if the conditions are
met?) Here is the formula if you want the value in C5 to display if 3
conditions are satisfied:

=IF(AND(A2=A3,A10=D3,D2=D3),C5,"")

Reply a little more specifically if this isn't what you were after,
--
Regards,

David Billigmeier



"Big Jones" wrote:

Can someone help me with a logic test using the AND function.
IF(A2=A3,A10 AND D2=D3,C5)

The above is what I am trying to achieve, can someone show me how to do it
correctly.
Thanx
BJ