=IF(A=1,CHOOSE(FIND("1",(B>9.69)*1&(B>9.09)*1&(B>8.49)*1&(B>7.89)*1&(B>7.29)*1&(B>6.69)*1&(B>6.09)*1&(B>5.49)*1&(B<5.5)*1),10,9,8,7,6,5,4,3,2))+IF(A=2,CHOOSE(FIND("1",(B>6.49)*1&(B>6.09)*1&(B>5.69)*1&(B>5.29)*1&(B>4.89)*1&(B>4.49)*1&(B>4.09)*1&(B>3.69)*1&(B<3.7)*1),10,9,8,7,6,5,4,3,2))
[此贴子已经被作者于2010-4-17 14:04:10编辑过] |