Comparing contents in three cells

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?
 
Z

zvkmpw

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

Comparing contents in three cells 0
compare three cells 1
Conditional Formatting Formula 3
Merging cells and formats 8
somewhat complicated conditional formula 2
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Combining several cells into single equasion? 1
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3

Top