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
Bookmarks