excel If函数可以加入多条件判断公式吗例如我想在=IF(COUNTA(D4:D7)1000,"/","有")这里"有"这里加入两个条件的判断公式,加入这个=SUM(COUNTIF(A4:D10,{"=110","=1000"})*{0,1}),怎么实现?就是第一个判断,如果这D
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/12 06:22:26
![excel If函数可以加入多条件判断公式吗例如我想在=IF(COUNTA(D4:D7)1000,](/uploads/image/z/655574-14-4.jpg?t=excel+If%E5%87%BD%E6%95%B0%E5%8F%AF%E4%BB%A5%E5%8A%A0%E5%85%A5%E5%A4%9A%E6%9D%A1%E4%BB%B6%E5%88%A4%E6%96%AD%E5%85%AC%E5%BC%8F%E5%90%97%E4%BE%8B%E5%A6%82%E6%88%91%E6%83%B3%E5%9C%A8%3DIF%28COUNTA%28D4%3AD7%291000%2C%22%2F%22%2C%22%E6%9C%89%22%29%E8%BF%99%E9%87%8C%22%E6%9C%89%22%E8%BF%99%E9%87%8C%E5%8A%A0%E5%85%A5%E4%B8%A4%E4%B8%AA%E6%9D%A1%E4%BB%B6%E7%9A%84%E5%88%A4%E6%96%AD%E5%85%AC%E5%BC%8F%2C%E5%8A%A0%E5%85%A5%E8%BF%99%E4%B8%AA%3DSUM%28COUNTIF%28A4%3AD10%2C%7B%22%3D110%22%2C%22%3D1000%22%7D%29%2A%7B0%2C1%7D%29%2C%E6%80%8E%E4%B9%88%E5%AE%9E%E7%8E%B0%3F%E5%B0%B1%E6%98%AF%E7%AC%AC%E4%B8%80%E4%B8%AA%E5%88%A4%E6%96%AD%2C%E5%A6%82%E6%9E%9C%E8%BF%99D)
xJQ_%ʉ!g b4$ .@!3G3
dQ"bʟ^33g
n
Z^5"ӊ> ׀to&B"drSi@dͷ%QeY$P#+Lޝ݉m8+PVtcNYJE1 8%%)JT+Wzu`5}!F