问题解决啦!这是公式=IF(H6=1,CHOOSE(FIND("1",(I6>9.69)*1&(I6>9.09)*1&(I6>8.49)*1&(I6>7.89)*1&(I6>7.29)*1&(I6>6.69)*1&(I6>6.09)*1&(I6>5.49)*1&(I6<5.5)*1),10,9,8,7,6,5,4,3,2))+IF(H6=2,CHOOSE(FIND("1",(I6>6.49)*1&(I6>6.09)*1&(I6>5.69)*1&(I6>5.29)*1&(I6>4.89)*1&(I6>4.49)*1&(I6>4.09)*1&(I6>3.69)*1&(I6<3.7)*1),10,9,8,7,6,5,4,3,2)) H是性别用1和2表示,I是成绩, |