excel公式表达如果大于等于40且小于90为30%;如果大于等于90且小于140为...答:=lookup(a1,{0,40,90,140},{0,30,60,100}%)=if(a1>=140,100%,if(a1>=90,60%,if(a1>=40,30%,0)))
lf函数,"期未成绩"大于等于80,则为优良,如果等于60但又小于80则为合格...答:由于提问没有实际表格的数据截图,只好按我这边的设定举例了。C2公式下拉:=IF(B2>=80,"优良",IF(B2>=60,"合格","不合格"))或者用这公式也行:=IF(B2<60,"不合格",IF(B2<80,"合格","优良"))