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

  • Thread starter Thread starter Narnimar
  • Start date Start date
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
 
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
 
Back
Top