Formula help for multiple conditions

[Sunshine8790]

I need a formula in column L that returns a value of "TRUE" if:
Cell in column G is "No Match" (or cell in H is "False")
AND
Cell in K is "False"

I'm at my wits end.

KC1 Compare Practice.xlsx
	G	H	I	J	K	L	M	N
1	Emp ID Match	Id is num	Badge Match	Badge is num	Need Added?	ID need Update?	ID need update?	Badge need update?
2	309	TRUE	309	TRUE	FALSE		FALSE	FALSE
3	No Match	FALSE	No Match	FALSE	TRUE		TRUE	TRUE
4	310	TRUE	310	TRUE	FALSE		FALSE	FALSE
5	No Match	FALSE	No Match	FALSE	TRUE		TRUE	TRUE
6	No Match	FALSE	No Match	FALSE	TRUE		TRUE	TRUE
7	311	TRUE	311	TRUE	FALSE		FALSE	FALSE
8	2	TRUE	2	TRUE	FALSE		FALSE	FALSE
9	No Match	FALSE	No Match	FALSE	TRUE		TRUE	TRUE
10	3	TRUE	3	TRUE	FALSE		FALSE	FALSE
11	312	TRUE	312	TRUE	FALSE		FALSE	FALSE
12	313	TRUE	313	TRUE	FALSE		FALSE	FALSE
13	No Match	FALSE	No Match	FALSE	TRUE		TRUE	TRUE
14	4	TRUE	No Match	FALSE	FALSE		FALSE	TRUE
15	5	TRUE	5	TRUE	FALSE		FALSE	FALSE
16	No Match	FALSE	No Match	FALSE	TRUE		TRUE	TRUE
Brivo Data

Cell Formulas
Range	Formula
G2:G16	G2	=IFERROR(MATCH(A2,'User Import Template'!A:A,0),"No Match")
H2:H16,J2:J16	H2	=ISNUMBER(G2)
I2:I16	I2	=IFERROR(MATCH(D2,'User Import Template'!D:D,0),"No Match")
K2:K16	K2	=AND(G2="No Match",I2="No Match")
M2:M16	M2	=IF(G2="No Match","TRUE","FALSE")
N2:N16	N2	=IF(I2="No Match","TRUE","FALSE")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H:N	Cell Value	contains "TRUE"	text	NO

 

[DRSteele]

I Think this will do it, although none of your records meets the criteria.

=IF(((G2="No Match")+(H2=FALSE))*(K2=FALSE),TRUE)

 

[GuzmanServices]

Let us know if the following formula does the trick, starting on Cell L2:

=IF(AND(OR($G2="No Match",$H2=FALSE),$K2=FALSE),"True","False")

 

[Sunshine8790]

I Think this will do it, although none of your records meets the criteria.

=IF(((G2="No Match")+(H2=FALSE))*(K2=FALSE),TRUE)

Thank you for your help.
Records not meeting criteria is probably because I didn't include Columns A-F (Sensitive Data).
I tried your formula and it DOES work.

I found another solution that works as well.
=IF(AND(ISNUMBER(SEARCH("FALSE",H2)),ISNUMBER(SEARCH("FALSE",K2))),"TRUE","FALSE")

 

[Sunshine8790]

Let us know if the following formula does the trick, starting on Cell L2:

=IF(AND(OR($G2="No Match",$H2=FALSE),$K2=FALSE),"True","False")

This is the kind of logical string I was looking for - thank you!

 

[Fluff]

For what it's worth, there is no need to use IF if you want True or False, you can just use

=AND(OR($G2="No Match",$H2=FALSE),$K2=FALSE)