第1个回答 2010-07-27
A1 是分数
B1=
IF(A1>=80,"强",if(a1<60,"弱","中"))
忘了 如果是60分这样的格式
你用
=IF(VALUE(SUBSTITUTE(A1,"分",""))>=80,"强",IF(VALUE(SUBSTITUTE(A1,"分",""))<60,"弱","中"))本回答被提问者和网友采纳
第2个回答 2010-07-27
喔,这个没有问题的啥,就是在If中再写if就是了哈
第3个回答 2010-07-27
=IF(A1>=80,"强",IF(AND(A1>=60,A1<80),"中",IF(A1<=60,"弱",)))
第4个回答 2010-07-27
=if(A1>=80,"强",if(A1>=60,"中","弱"))