compare three cells

[gcotterl]

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?

 

[Gord Dibben]

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