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

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

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

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Narnimar" wrote in message
...
My A1=B1=C1=D1=1 but why formula A1=B1=C1=D1excel2007 return as false?

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

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

--
Gary''s Student - gsnu200903


"Narnimar" wrote:

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

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

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 wrote:
My A1=B1=C1=D1=1 but why formula A1=B1=C1=D1excel2007 return as false?

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

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

"Dana DeLouis" wrote:

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 wrote:
My A1=B1=C1=D1=1 but why formula A1=B1=C1=D1excel2007 return as false?