大师作文网改变公式内容,公式不起作用
来源：学生作业帮 编辑：大师作文网作业帮 分类：数学作业 时间：2024/11/10 13:14:32
改变公式内容,公式不起作用
=LOOKUP(SUM(LOOKUP($G5,{"不合格","合格","良好","优秀"},{59,70,85,95})*0.4,LOOKUP($H5,{"不合格","合格","良好","优秀"},{59,70,85,95})*0.6),{0,60,80,90},{"不合格","合格","良好","优秀"})
把优秀改为A,良好改为B,合格改为C,不合格改为D
=LOOKUP(SUM(LOOKUP($G5,{"不合格","合格","良好","优秀"},{59,70,85,95})*0.4,LOOKUP($H5,{"不合格","合格","良好","优秀"},{59,70,85,95})*0.6),{0,60,80,90},{"不合格","合格","良好","优秀"})
把优秀改为A,良好改为B,合格改为C,不合格改为D
LOOKUP查找范围必须从小到大,改成VLOOKUP吧.
=LOOKUP(SUM(VLOOKUP($G5,{"D",59;"C",70;"B",85;"A",95},2,)*0.4,VLOOKUP($H5,{"D",59;"C",70;"B",85;"A",95},2,)*0.6),{0,60,80,90},{"D","C","B","A"})
=LOOKUP(SUM(VLOOKUP($G5,{"D",59;"C",70;"B",85;"A",95},2,)*0.4,VLOOKUP($H5,{"D",59;"C",70;"B",85;"A",95},2,)*0.6),{0,60,80,90},{"D","C","B","A"})