N
Narnimar
My A1=B1=C1=D1=1 but why formula A1=B1=C1=D1excel2007 return as false?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
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
This is:
=AND(A1=1,B1=1,C1=1,D1=1)
and it returns TRUE
G
Gary''s Student
=(A1=B1)=(C1=D1)
D
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
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
N
Narnimar
Dana DeLouis,
Thanks for your appropriate answer with explenation to why.
Thanks for your appropriate answer with explenation to why.