G
gcotterl
B1, D1 and F1 contains 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?
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?