B1, D1 and F1 contains alphanumeric data. For example: 123456789-1

A1 contains =IF(A1=C1=E1,"YES","NO")

But "NO" is returned.

How can verify whether or the contents of contains of cells B1, D1 and
F1 are the same?

Looks like some typos.

How can you have a formula in A1 refer to A1?

What do C1 and E1 have to do with anything?

Perhaps you meant something like this...........

Entered in A1...................=IF(AND(B1=D1,B1=F1),"yes","no")


Gord Dibben MS Excel MVP


On Thu, 9 Sep 2010 17:24:09 -0700 (PDT), gcotterl <(E-Mail Removed)>
wrote:

>B1, D1 and F1 contains alphanumeric data. For example: 123456789-1
>
>A1 contains =IF(A1=C1=E1,"YES","NO")
>
>But "NO" is returned.
>
>How can verify whether or the contents of contains of cells B1, D1 and
>F1 are the same?