EXL里当A1>90时,B1*100%;当90>A1>80时,B1*85%;当80>A1>70时,B1*75%;当70>A1>60时,B1*65%;当A1小于
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/21 07:53:03
![EXL里当A1>90时,B1*100%;当90>A1>80时,B1*85%;当80>A1>70时,B1*75%;当70>A1>60时,B1*65%;当A1小于](/uploads/image/z/1562075-35-5.jpg?t=EXL%E9%87%8C%E5%BD%93A1%3E90%E6%97%B6%2CB1%2A100%25%EF%BC%9B%E5%BD%9390%3EA1%3E80%E6%97%B6%2CB1%2A85%25%EF%BC%9B%E5%BD%9380%3EA1%3E70%E6%97%B6%2CB1%2A75%25%EF%BC%9B%E5%BD%9370%3EA1%3E60%E6%97%B6%2CB1%2A65%25%EF%BC%9B%E5%BD%93A1%E5%B0%8F%E4%BA%8E)
EXL里当A1>90时,B1*100%;当90>A1>80时,B1*85%;当80>A1>70时,B1*75%;当70>A1>60时,B1*65%;当A1小于
EXL里当A1>90时,B1*100%;当90>A1>80时,B1*85%;当80>A1>70时,B1*75%;当70>A1>60时,B1*65%;当A1小于
EXL里当A1>90时,B1*100%;当90>A1>80时,B1*85%;当80>A1>70时,B1*75%;当70>A1>60时,B1*65%;当A1小于
=IF(A2>89,"A",IF(A2>79,"B",IF(A2>69,"C",IF(A2>59,"D","F"))))
可参见这个表达方式.