MID:=REF(高+低,1)/2;
CR:=SUM(MAX(0,中高),26)/SUM(MAX(0,中低),26)* 100;
MA1:=REF(MA(CR,10),10/2.5+1);
MA2:=REF(MA(CR,20),20/2.5+1);
MA3:=REF(MA(CR,40),40/2.5+1);
MA4:=REF(MA(CR,62),62/2.5+1);
SX:=MAX(MAX(MAX(MA1,MA2),MA3),MA4);
購買:CROSS(CR,SX);
那很好。