The syntax is IF(AND(A2=A3,A2=A10,D2=D3,D2=C5))
I am guessing that your A2=A3,A10 means A2 must equal both A3 and A10
Since AND is a function we must use NAME (argument1, argument2,....)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Big Jones" <Big
wrote in message
...
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