Hi,

I wonder if someone can help me.

I have the following formula:

=IF('Sheet 1 '!E7=PRODUCTS!$C$4,1,0)

and what i want the formula to do is when isheet 1 e7 is the same as product c4 AND when the value in that row in column J is bigger than 0, then put 1 if not 0.

I only want a zero in that cell when both conditions are true.

Thanks