If/then for three items

Wynn · Mar 3, 2004

IF(A1=A2,"dupe","unique")

Why can't I do:

IF(A1=A2=A3,"dupe","unique")

Trevor Shuttleworth · Mar 3, 2004

Wynn

one way:

=IF(OR(A1=A2,A1=A3,A2=A3),"dupe","unique")

Regards

Trevor

Guest · Mar 3, 2004

Thank you very much!

-----Original Message-----
Wynn

one way:

=IF(OR(A1=A2,A1=A3,A2=A3),"dupe","unique")

Regards

Trevor

.

Frank Kabel · Mar 3, 2004

Hi
try
=IF(COUNTIF(A2:A3,A1)>0,"dupe","unique")