Hi
I got lost () while trying to modify the formula to compare different columns:
=IF(AND(A3=B3;NOT(A3<>C3);A3<>E3);IF(I3="--";"MAYBE";TRUE);FALSE)
I would need to get a statement by using multiple match horizontal criteria.
1) variable "up/down" in Column A must match with variable "up/down" in Column B;
2) if the result of (1) is FALSE, then print "No Match" in Column F;
3) if the result of (1) is TRUE, then match with variable "up/down" in Column C and D;
4) if (C and D) are the opposite of (A=B), then print "Best" in Column F
5) if C and/or D is "--" (and A = B), then print "Possible" in Column F
6) if (A <> B) = C or D, then print "No good" in F
Please, find attached the file with the example and criteria.
Thank you very much for any suggestion
Maurizio
Bookmarks