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

A	B	C	D	E	F	Combined A-F	New Value
True	False	False	False	False	False	=IF(AND(A2={"True"},B2={"False"},C2={"True"},D2={"False"}),TRUE,FALSE)	FALSE
True	False	True	False	True	True		TRUE

<tbody>
</tbody>

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)