I have a complicated IF function problem I'm struggling with...
I need to say-
IF = (K1=1) look at value in column C. If mean value between C1:C10 is larger than value found in C1, then look at mean value between K1:K10, if this value is larger than K1 then insert a '1', if not insert a '0'.
Thanks in advance, I'm stuck with this one!
Bookmarks