View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
The Mysterious J The Mysterious J is offline
external usenet poster
 
Posts: 6
Default Logical Test Question

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

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