My A1,B1,C1&D1 are 1 but why excel2007 return as false?

[Narnimar]

My A1=B1=C1=D1=1 but why formula A1=B1=C1=D1excel2007 return as false?

 

[Niek Otten]

That is not a correct syntax for an Excel formula.

This is:

=AND(A1=1,B1=1,C1=1,D1=1)

and it returns TRUE

 

[Gary''s Student]

=(A1=B1)=(C1=D1)

 

[Dana DeLouis]

but why formula A1=B1=C1=D1excel2007 return as false?

Hi. Excel doesn't work like that as in other programs.

A1=B1 -> Returns True
then
True = C1 -> Returns False
False = D1 -> Returns False
etc...

One way...

=COUNTIF(A1:A4,1)=4


Excel tried with the 'Exact' function, but it's only limited to two
string variables.

= = = = =
Dana DeLouis

 

[Narnimar]

Dana DeLouis,
Thanks for your appropriate answer with explenation to why.