IF AND OR

[rodkuusinen]

How do I combine the results of C and D columns and generate a true/false statement in column E Column C =IF(A2<A1,TRUE,FALSE) Column D =IF(B2<B1,TRUE,FALSE) I have tried this formula but it always generates a FALSE STATEMENT Column E =IF(AND(C2="TRUE",D2="FALSE"),TRUE, FALSE) Once this is correct I need to take it further. I need to create a true statement for any combination of results except for TRUE AND TRUE or FALSE AND FALSE So If Column C = TRUE but Column D = FALSE Column E = TRUE If Column C = FALSE but Column D = TRUE Column E = TRUE If Column C = TRUE but Column D = TRUE Column E = FALSE If Column C = FALSE but Column D = FALSE Column E = FALSE Im 68 and should know better but what the heck I don't. Your help is appreciated 11​ 11​ 10​ 12​ TRUE​ FALSE​ FALSE​ 13​ 3​ FALSE​ TRUE​ FALSE​ 2​ 4​ TRUE​ FALSE​ FALSE​ 5​ 3​ FALSE​ TRUE​ FALSE​ 6​ 6​ FALSE​ FALSE​ FALSE​ 7​ 7​ FALSE​ FALSE​ FALSE​

 

[Joe4]

Welcome to the Board!

How do I combine the results of C and D columns and generate a true/false statement in column E Column C =IF(A2<A1,TRUE,FALSE) Column D =IF(B2<B1,TRUE,FALSE)​

Does this give you what you are looking for?

=AND(A2<A1,B2<B1)

 

[Peter_SSs]

Welcome to the MrExcel board!

The way I understand it ..
If you still want those column C and D formulas, then use the column E formula below.
If you want the final result directly then use the column F formula.

21 12 06.xlsm
	A	B	C	D	E	F
1	11	11
2	10	12	TRUE	FALSE	TRUE	TRUE
3	13	3	FALSE	TRUE	TRUE	TRUE
4	2	4	TRUE	FALSE	TRUE	TRUE
5	5	3	FALSE	TRUE	TRUE	TRUE
6	6	6	FALSE	FALSE	FALSE	FALSE
7	7	7	FALSE	FALSE	FALSE	FALSE
TF

Cell Formulas
Range	Formula
C2:D7	C2	=A2<A1
E2:E7	E2	=C2<>D2
F2:F7	F2	=(A2<A1)<>(B2<B1)