I have already posted this problem but I have tried to better describe it here and attached an example of the spread sheet -
excel forum example.xlsx
I have a complicated IF function problem I'm struggling with...
I need to say-
IF = (K10=1) look at value in column C. If mean value between C10:C20 is larger than value found in C10, then look at mean value between L10:L20, if this value is larger than L10 then insert a '1' into column M, if not insert a '0'.

Thanks in advance, I'm stuck with this one!