If/then for three items

[Wynn]

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

Why can't I do:

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

 

[Trevor Shuttleworth]

Wynn

one way:

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

Regards

Trevor

 

[Guest]

Thank you very much!

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

one way:

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

Regards

Trevor





.

 

[Frank Kabel]

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