Logical Test Question

[Tom]

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.

 

[The Mysterious J]

Formula written for the following columns & rows:

A B C D
1 2501 1201 2501 FALSE
2 2503 2503 2503 TRUE

The formula in D1 is:
=IF(AND(A1=B1,B1=C1),TRUE,FALSE)
Fill the formula to D2 and it will work there, to yield "TRUE."

 

[Ron Rosenfeld]

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