orilan 发表于 2015-6-3 12:59
小于60%则是0 嵌套进去还是出问题
=IF(A1>=120,130,IF(A1>=115,125,IF(A1>=110,120,IF(A1>=105,115,IF(A1>=100,110,IF(A1>=90,105,IF(A1>=80,100,IF(A1>=70,90,IF(A1>=60,80,"比率对应得分未设置"))))))))) |
=IF(A1>=120,130,IF(A1>=115,125,IF(A1>=110,120,IF(A1>=105,115,IF(A1>=100,110,IF(A1>=90,105,IF(A1>=80,100,IF(A1>=70,90,IF(A1>=60,80,0)))))))))
|