=If (need 2 criterias), true, false

S

serve

=IF(a=b and c=d, place value for true, place value for false). I need to
have 2 criteria in the logical section, right now you can only use 1 logical
statement
 
S

serve

Thank you.
next scenario, if you are trying to match A with all of column B (meaning
that value should equal a cell in column B) and match C with all of column D
(same as column B), TRUE, FALSE.... can we do that, like comparing to an
array?
 
S

Sloth

=IF((COUNTIF(B:B,A1)>0)*(COUNTIF(D:D,C1)>0),TRUE,FALSE)

your nomenclature is a little funny, but I think I understand what you want.
If A1 is found at least once in column B, and C1 can be found at least once
in column D, then this statement will return true.

You might want to start a new post detailing this question if I am not
understanding you correctly. Be sure to provide a sample of the data you
have, and the results you want. Be as detailed as possible.

For Example:
A B C D E
1 apple orange red red TRUE
2 orange apple yellow duck FALSE
3 banana apple purple purple FALSE
4 pineapple pineapple duck blue TRUE

E1 is TRUE because "apple" can be found in column B, and "red" can be found
in column D.
E2 is FALSE because "yellow" can not be found in column D.
E3 is FALSE because "banana" can not be found in column B.
 
Top