Comparing contents in three cells

[gcotterl]

B1, D1 and F1 contain alphanumeric data. For example:

123456789-1


A1 contains this formula:

=IF(B1=D1=F1,"YES","NO")


But "NO" is displayed in A1


How can verify whether the contents of B1, D1 and F1 are identical?

 

[zvkmpw]

How can verify whether the contents of B1, D1 and F1 are identical?

One way:
=IF(AND(B1=D1,B1=F1),"YES","NO")