合并两个逗你玩的公式:
SRYL1:=REF(C,1)>REF(C,2)*1.095 AND REF(C,1)=REF(H,1)
AND C>REF(C,1)*1.095 AND C=H;
YB:=COUNT(C>=REF(C,1)*1.099 AND C=H,3)>=1;
TK:=COUNT(L>REF(C,1)*1.005,3)>=3;
LB:=COUNT(C>=REF(C,1)*1.099 AND C=H,3)>=3;
SP:=COUNT(H>=REF(C,1)*1.095 AND C>REF(C,1)*1.035,3)>=3;
SRYL2:=YB AND (TK OR LB) AND SP;
SRYL1 OR SRYL2; |