Return true if multiple cells are the same

[Guest]

I have cells A1 to E1 with same values. In cell F1, I want to return "true"
if cell A1=B1=C1=D1=E1. The result I get was #N/A when I enter the formula
"=A1=B1=C1=D1=E1". Anyone knows the answer?

 

[R..VENKATARAMAN]

try this formula

=IF(AND(A1=B1,A1=C1,A1=D1,A1=E1),TRUE,FALSE)

 

[Biff]

Another way:

=COUNTIF(A1:E1,A1)=5

Biff