完成率在A列,B1输入=LOOKUP(A1,{0,0;0.35,60;0.4,70;0.45,80;0.5,90;0.55,100})或=IF(A1<0.35,"",IF(A1<0.4,60,IF(A1<0.45,70,IF(A1<0.5,80,IF(A1<0.55,90,IF(A1<0.6,100,""))))))回车并向下填充。