check three values

[clares]

Hi there

I want to be able to test three cells (C2, D2, E2) to ensure that each cell has the same numerical value in it. If it were just two cells I could use a simple If statement. Has anybody got a simple formula that would test the three cells. My spreadsheet has 52003 rows and I don't want to check manually. I would need some text value to say check if all three cells don't match?

As per usual thank you in advance.

Kind regards

Peter

 

[VoG]

Try

=IF(AND(C2=D2,D2=E2),"","Check")

 

[clares]

Thank you so very much...

Kind Regards

Peter

 

[T. Valko]

Hi there

I want to be able to test three cells (C2, D2, E2) to ensure that each cell has the same numerical value in it. If it were just two cells I could use a simple If statement. Has anybody got a simple formula that would test the three cells. My spreadsheet has 52003 rows and I don't want to check manually. I would need some text value to say check if all three cells don't match?

As per usual thank you in advance.

Kind regards

Peter

One way...

Book1
	C	D	E	F
2	98	98	98	TRUE
3	10	0	10	FALSE
4	0	0	10	FALSE
5	1	1	1	TRUE
Sheet1

This array formula** entered in F2 and copied down:

=AND(C2:E2=C2)

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.