This should be an easy one, I guess

[ColdGeorge]

Hi all

I am looking for an easy -and working- formula to tell me when A1, B1 and C1 values are the same, after a search for help on the Internet I feel very confused, thanks in advance for your help.

ColdGeorge

 

[Robby19]

Try;

=IF(AND(A1=B1,A1=C1),"yes","no")

 

[ColdGeorge]

Try;

=IF(AND(A1=B1,A1=C1),"yes","no")

Thanks for answering Robby19, unfortunately, it does not work, when I enter same values your formula still says no (not the same).

ColdGeorge

 

[MARK858]

Just another option....

Excel 2010
	A	B	C	D	E
1	a1	b1	a1		No
2	a2	a2	a2		Yes
Sheet2

Cell Formulas
Range	Formula
E1	{=IF(AND(EXACT(A1:C1,A1)),"Yes","No")}
E2	{=IF(AND(EXACT(A2:C2,A2)),"Yes","No")}
Press CTRL+SHIFT+ENTER to enter array formulas.

By the way the formula from Robbie19 works for me. Are you sure that your data is an exact match including no leading or trailing spaces?