Multiple IF statements

[Ruth_07]

Hi,

Can somebody please help me with the below:


If I have 3 columns of text in Excel and I want it to check if they all match and return a certain phrase if they all match if not return an alternative phrase. How would I go about setting up a multiple IF statement for this?

It is important that they match for the specific phrase in the column.

Thanks,

Ruth

 

[njimack]

=IF(COUNTIF(A1:C1,A1)=COLUMNS(A1:C1),"They all match","They don't match")

 

[texasalynn]

does this work?

=IF(OR(A2=B2,B2=C2),"All match","Doesn't match")

if not post a small sample of your data and the expected results.

 

[Ruth_07]

Thank you,

That works great

 

[taurean]

does this work?

=IF(OR(A2=B2,B2=C2),"All match","Doesn't match")

if not post a small sample of your data and the expected results.

I guess you wanted to say:
=IF(AND(A2=B2,B2=C2),"All match","Doesn't match")

 

[njimack]

Thank you,

That works great

Glad to be of service!