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

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Value if two cells are true 2
[HELP]CLOCK TIMER USING ECXEL 0
IF 4
HOW TO CATCH A DIFFERENT/INCONSISTENT FORMULA 3
if(a1=b1=c1,1,0) is 0 when should be 1, why? 3
How to copy the function SUM but offseted in 7 columns 2
sum multiple columns with SUMIF or SUMPRODUCT 2
Return true if multiple cells are the same 2

Top