Comparing 3 columns

[chariot]

I have columns A B and C that I would like to compare - if they all match then I'd like a result of TRUE/MATCH etc if they don't all match then I'd like a result of FALSE/NO MATCH etc

Usually for two values I'd use A1=B1 and get TRUE or FALSE but this does not work for 3 values.

Thanks!

 

[VoG]

Try

=AND(A1=B1,B1=C1)

 

[chariot]

Thanks, but will this compare A1 to C1?

 

[VoG]

If A1=B1 and B1=C1 they must all be the same, surely?

 

[chariot]

Aha yes, thanks, sorry I had not changed the cell ref!!
Many thanks for your help, much appreciated!