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?