Multipe criteria to result in yes

if C2=C:C,02>.10, N2=0, and m2>6&n2>1,"yes")

If location is the same- column C, I want to look at product in column n with 0 value and column 0 with a value greater than .10, any item meeting this criteria I then want to look at column M for any item greater than 6 and column n greater than 1 to return a value of yes.

Basically if a product has a column n valude of 0 and is greater than 10 in column 0, I then want to know if there are products that have a value greater than 6 in column m and greater than 1 in column n.