请问这个excel函数公式=CHOOSE(MATCH(MAX(1-F1,1-G1),{-5,0,0.2,0.3}),0.05,0.02,0.015,

来源:学生作业帮助网 编辑:作业帮 时间:2024/11/16 21:25:46

请问这个excel函数公式=CHOOSE(MATCH(MAX(1-F1,1-G1),{-5,0,0.2,0.3}),0.05,0.02,0.015,
请问这个excel函数公式=CHOOSE(MATCH(MAX(1-F1,1-G1),{-5,0,0.2,0.3}),0.05,0.02,0.015,

请问这个excel函数公式=CHOOSE(MATCH(MAX(1-F1,1-G1),{-5,0,0.2,0.3}),0.05,0.02,0.015,
折解函数
MAX(1-F1,1-G1) 查找1-F1和1-G1的最大值
MATCH(MAX(1-F1,1-G1),{-5,0,0.2,0.3}) 在{-5,0,0.2,0.3}数组中模糊查找上面公式所得的值的位置.结果是1,2,3,4,5
CHOOSE(MATCH(MAX(1-F1,1-G1),{-5,0,0.2,0.3}),0.05,0.02,0.015,0)
以上面公式中所得的结果,按位置1,2,3,4,5查找0.05,0.02,0.015,0,并返回值