当前位置:百科知识 > 知到猛志常在答案

问题描述:

[多选] 填充“奖学金级别”列:可在I2单元格输入(),然后拖动I2单元格的填充柄至I10单元格。()
A.=IF(H2=5000,"一等", H2=4000,"二等", H2=3000,"三等") B.=IF(H2=5000,"一等",IF(H2=4000,"二等","三等")) C.=IF(H2=3000,"三等",IF(H2=4000,"二等","一等")) D.=IF(H2=4000,"二等",IF(H2=5000,"一等","三等"))
参考答案:查看
答案解析:
☆收藏

随机题目