Excel中如何整合多个IF函数?请大师帮忙看看,如何把下面4个IF函数整合成一个IF函数,=IF(AND(E4="SE",D4="48N"),5,3)=IF(AND(E4="GB",D4="48N"),3,2)=IF(AND(E4="DE",D4="48N"),3,2)=IF(AND(E4="HU",D4="48N"),4,2)那怎么把下面这
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/13 09:45:51
![Excel中如何整合多个IF函数?请大师帮忙看看,如何把下面4个IF函数整合成一个IF函数,=IF(AND(E4=](/uploads/image/z/6546818-2-8.jpg?t=Excel%E4%B8%AD%E5%A6%82%E4%BD%95%E6%95%B4%E5%90%88%E5%A4%9A%E4%B8%AAIF%E5%87%BD%E6%95%B0%3F%E8%AF%B7%E5%A4%A7%E5%B8%88%E5%B8%AE%E5%BF%99%E7%9C%8B%E7%9C%8B%2C%E5%A6%82%E4%BD%95%E6%8A%8A%E4%B8%8B%E9%9D%A24%E4%B8%AAIF%E5%87%BD%E6%95%B0%E6%95%B4%E5%90%88%E6%88%90%E4%B8%80%E4%B8%AAIF%E5%87%BD%E6%95%B0%2C%3DIF%28AND%28E4%3D%22SE%22%2CD4%3D%2248N%22%29%2C5%2C3%29%3DIF%28AND%28E4%3D%22GB%22%2CD4%3D%2248N%22%29%2C3%2C2%29%3DIF%28AND%28E4%3D%22DE%22%2CD4%3D%2248N%22%29%2C3%2C2%29%3DIF%28AND%28E4%3D%22HU%22%2CD4%3D%2248N%22%29%2C4%2C2%29%E9%82%A3%E6%80%8E%E4%B9%88%E6%8A%8A%E4%B8%8B%E9%9D%A2%E8%BF%99)
Excel中如何整合多个IF函数?请大师帮忙看看,如何把下面4个IF函数整合成一个IF函数,=IF(AND(E4="SE",D4="48N"),5,3)=IF(AND(E4="GB",D4="48N"),3,2)=IF(AND(E4="DE",D4="48N"),3,2)=IF(AND(E4="HU",D4="48N"),4,2)那怎么把下面这
Excel中如何整合多个IF函数?
请大师帮忙看看,如何把下面4个IF函数整合成一个IF函数,
=IF(AND(E4="SE",D4="48N"),5,3)
=IF(AND(E4="GB",D4="48N"),3,2)
=IF(AND(E4="DE",D4="48N"),3,2)
=IF(AND(E4="HU",D4="48N"),4,2)
那怎么把下面这两个公式变成一个啊?小白一枚,还请赐教喔……
=IF(D4="48N",IF(E4="SE",5,IF(E4="GB",3,IF(E4="DE",3,IF(E4="HU",4)))))
=IF(D4="15N",IF(E4="SE",3,IF(E4="GB",2,IF(E4="DE",2,IF(E4="HU",2)))))
Excel中如何整合多个IF函数?请大师帮忙看看,如何把下面4个IF函数整合成一个IF函数,=IF(AND(E4="SE",D4="48N"),5,3)=IF(AND(E4="GB",D4="48N"),3,2)=IF(AND(E4="DE",D4="48N"),3,2)=IF(AND(E4="HU",D4="48N"),4,2)那怎么把下面这
用INDEX函数:
=INDEX({5,3,3,4;3,2,2,2},MATCH(D4,{"48N","15N"},0),MATCH(E4,{"SE","GB","DE","HU"},0))