Question

if公式问题=IF(E3≤0," ",IF(E3≤60,"不合格供应商",IF(E3≤75,"辅导级供应商",IF(E3

Answer 1

=IF(E3≤0," ",IF(E3≤60,"不合格供应商",IF(E3≤75,"辅导级供应商",IF(E3≤90,"合格供应商",IF(E3≤100,"优秀供应商")))))

看看你的和我的有什么区别：=IF(E3≤0," ",IF(E3≤60,"不合格供应商",IF(E3≤75,"辅导级供应商",IF(E3≤90,"合格供应商",IF(E3≤100,"优秀供应商"))))“),引号引用有错误,如果这样不行的话,你试试把前面的引号去掉.