发布网友 发布时间:2024-10-21 18:24
我来回答
共3个回答
热心网友 时间:2天前
可试一下这个能否符合你的要求:=if(A1>=90,"A",IF(A1<80,"C","B"))之后向下复制便可!
=IF(A1>=90,"A",IF(A1>=80,"B","C"))
=if(A1>=90,"A",IF(A1<80,"C","B"))下拉!