On Fri, 23 May 2008 14:52:00 -0700, Tom wrote:

I have three columns of text (4 digits each). I need a logical test that
show true if all three equal or false if any of the three are not equal to
the others.

I've played with If statements, but cant get it to resolve.

Thanx for the help.


Here are some simple formulas that will show TRUE or FALSE depending on whether
they meet your parameters:

=AND(A1=B1,B1=C1)

=COUNTIF(A1:C1,A1)=3
--ron