Logical Test Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 23 May 2008 22:52 GMT

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.

Reply to this Message

The Mysterious J - 23 May 2008 23:04 GMT

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."

> 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
[quoted text clipped - 3 lines]
>
> Thanx for the help.

Reply to this Message

Ron Rosenfeld - 24 May 2008 00:06 GMT

>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
[quoted text clipped - 3 lines]
>
>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

Reply to this Message