A1:=REF(C,2)-REF(C,3)>0;B1:=REF(C,1)-REF(C,2)<0 AND C-REF(C,1)<0;V1:=VOLREF(VOL,1);A1 AND V1 AND B1;直接粘贴过去就好了!