Compare cells on many pages

[MartinFilteau]

Hi,
I would like to compare if a cell has the same value (text) on each
spreadsheets.
If on each sheet we get at A1 "ABCD"
=Sheet1!A1=Sheet2!A1 --> Give me True
=Sheet1!A1=Sheet2!A1=Sheet3!A1 --> Give me False.

Any suggestions.

Martin

 

[JohnI in Brisbane]

Martin,

Try-

=AND(Sheet1!A1=Sheet2!A1,Sheet1!A1=Sheet3!A1)

regards,

JohnI