compare three cells

G

gcotterl

B1, D1 and F1 contains alphanumeric data. For example: 123456789-1

A1 contains =IF(A1=C1=E1,"YES","NO")

But "NO" is returned.

How can verify whether or the contents of contains of cells B1, D1 and
F1 are the same?
 
G

Gord Dibben

Looks like some typos.

How can you have a formula in A1 refer to A1?

What do C1 and E1 have to do with anything?

Perhaps you meant something like this...........

Entered in A1...................=IF(AND(B1=D1,B1=F1),"yes","no")


Gord Dibben MS Excel MVP
 

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 1
COUNTING THE SAME VALUES IN A SHEET 3
Combining several cells into single equasion? 1
cells with one to multiple lines 1
Cells with varying number of lines 1
Rows with cells of varying number of lines 5
Nested IF statement 5
Combining text from several cells into 1 cell 4

Top