=IF(A1>=90,"优",IF(A1>=80,"良",IF(A1>=70,"中","")))
其他空白了。
=IF(A1>=70,(IF(A1>=80,IF(A1>=90,"优","良"))),"中")
在b1单元格 输入公式
=IF(A1>=90,"优",IF(A1>=80,"良",IF(A1>=70,"中","")))
额,主要是不确定A1如果<70或者是>100的话是什么结果,所以用if判断了一下
=IF(AND(A1>=70,A1<=100),LOOKUP(A1,{70,"中";80,"良";90,"优"}) ,"超出范围")
不会可以hi我