在excle中怎么进行编辑与基准值一致得39分,每低于基准值1%减0.1分,减到38.5为止,

2025-03-05 00:54:51
推荐回答(1个)
回答1:

C12=AVERAGE(C2:C11)

D2=39-ROUND(IF((C2/$C$12-1)*100>0,MIN(0.5,(C2/$C$12-1)*100*0.2),IF((C2/$C$12-1)*100<0,MIN(2.5,(1-C2/$C$12)*100*0.1),0)),1)向下复制