Comparing contents in three cells

  • Thread starter Thread starter gcotterl
  • Start date Start date
G

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?
 
How can verify whether the contents of B1, D1 and F1 are identical?

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