Multipe criteria to result in yes

[runner]

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.

[leelnich]

Hi runner- Could you please expand on your description:
1) C2 = C:C Do you mean "if C2 = C1", that is, the cell directly above?
2) if C2=C:C,02>.10, N2=0, and m2>6&n2>1,"yes") These can't both be TRUE. Is there a logical branch here, or what?

[runner]

Column see is location Id and I want to evaluate each location separately. Maybe c2= c2:c1000 or however many rows are in report?

[runner]

Column n is the capacity of an item, the first run I want to identify items with 0 capacity which would not be displayed and then I want to know if items that are displayed more than 1 have a supply greater than 6. This will identify items not on display while identifying items on display with 2 facings that would be cut to 1 facing so backroom items can be displayed

[leelnich]

I'm not sure what you mean by the "first run", but maybe this works. Paste in P2 and copy down:

Please Login or Register  to view this content.

This says:
IF (capacity =0 AND total_unit_movement >.1 AND there's at least 1 product at this location with capacity>1 AND DOS>6) THEN "yes", ELSE "-""

Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-Lee