Logical Test Question

  • Thread starter Thread starter Tom
  • Start date Start date
T

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.
 
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
the others.

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

Thanx for the help.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Lists 1
Please help on formula that will not work (If-And formula) 3
"If" Formula Error 3
If statement for a range of cells 3
Ms Excel Multiple Logical Test Function 0
nested IF without repeating the condition to be tested 6
2 IF Statements not mutually exclusive 2
if(a1=b1=c1,1,0) is 0 when should be 1, why? 3

Back
Top