ZGZD0:=IF(C>4,0.0025*FLOOR(C),0.01);
ZGZD1:CONST(IF(COUNT(C>=CONST(HHV(C,0)),999)>=4,CONST(HHV(C,0)),IF(COUNT(C>=CONST(HHV(C,0))-ZGZD0,999)>=4,CONST(HHV(C,0))-ZGZD0,IF(COUNT(C>=CONST(HHV(C,0))-2*ZGZD0,999)>=4,CONST(HHV(C,0))-4*ZGZD0,IF(COUNT(C>=CONST(HHV(C,0))-3*ZGZD0,999)>=4,CONST(HHV(C,0))-3*ZGZD0,IF(COUNT(C>=CONST(HHV(C,0))-4*ZGZD0,999)>=4,CONST(HHV(C,0))-4*ZGZD0,CONST(HHV(C,0))-5*ZGZD0))))));
ZGZD2:CONST(IF(COUNT(C<=CONST(LLV(C,0)),999)>=4,CONST(LLV(C,0)),IF(COUNT(C<=CONST(LLV(C,0))+ZGZD0,999)>=4,CONST(LLV(C,0))+ZGZD0,IF(COUNT(C<=CONST(LLV(C,0))+2*ZGZD0,999)>=4,CONST(LLV(C,0))+4*ZGZD0,IF(COUNT(C<=CONST(LLV(C,0))+3*ZGZD0,999)>=4,CONST(LLV(C,0))+3*ZGZD0,IF(COUNT(C<=CONST(LLV(C,0))+4*ZGZD0,999)>=4,CONST(LLV(C,0))+4*ZGZD0,CONST(LLV(C,0))+5*ZGZD0))))));
202108201259.jpg
|