=if(H3>80,"优秀",if(H3>70,"良好",if(H3>60,"中等","较差"))) J3输入 下拉=if(H3>90,800,if(H3>80,500,0)) K3 输入 下拉=if(K3>=800,k3*0.05,0)L3输入 下拉合计很简单自己做就好了
