TRUE, FALSE - IF condition

[avenkat]

Hi,

I have a bunch of IF conditions which have given me TRUE or FALSE values. I am trying to combine False values derived to conjoin with another IF statement but I am getting a FALSE value for all the data .
For eg

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]Combined A-F[/TD]
[TD]New Value[/TD]
[/TR]
[TR]
[TD]True[/TD]
[TD]False[/TD]
[TD]False[/TD]
[TD]False[/TD]
[TD]False[/TD]
[TD]False[/TD]
[TD]=IF(AND(A2={"True"},B2={"False"},C2={"True"},D2={"False"}),TRUE,FALSE)

[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]True[/TD]
[TD]False[/TD]
[TD]True[/TD]
[TD]False[/TD]
[TD]True[/TD]
[TD]True[/TD]
[TD][/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am getting all New value columns as "False" , any help on a better solution for this sort of IF statement?
TIA

 

[Eric W]

Maybe:

=AND(A2,B2=FALSE,C2,D2=FALSE)

Excel has different types of values, even if they look the same. FALSE is not the same as "FALSE", which is not the same as {"FALSE"}.

 

[jtakw]

Hi,

You can try it this way:

Book1
	A	B	C	D	E	F	G	H
1								New Value
2	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE		FALSE
3	TRUE	FALSE	TRUE	FALSE	TRUE	TRUE		TRUE
Sheet110

Cell Formulas
Range	Formula
H2	=AND(A2,C2,--OR(B2,D2)=0)