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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compare three cells 1
Combining several cells into single equasion? 1
Empty cells 1
Merging cells and formats 8
Nested IF statement 5
Worksheet to Worksheet skip blanks 3
Rolling totals 1
adding every other column 7

Back
Top