excel表格简单小问题。

显示全部楼层 · 2012-6-13 12:14:57

=LOOKUP(A1,{0,35,45,55,65,75,85,95},{"D","C-","C","C+","B-","B","B+","A"})...

千问 · 2012-6-13 12:14:57

=IF(A1100,"",CHOOSE((FLOOR(A1-5,10))/10-2,"C-","C","C+","B-","B","B+","A",""))) 考虑了数值超出100后的情况，否则公式可以缩减些。...

千问 · 2012-6-13 12:14:57

你必须有一列是纯数字的，这列数字为最小值。然后用vlookup()来找，我就是用的lookup（）函数，最后的参数为1...

千问 · 2012-6-13 12:14:57

good...