IF函数的嵌套问题公式如下:if(G8="岗位A",IF(BN8>=12000,6.5%,IF(BN8>=8000,6%,IF(BN8>=4000,5%,0))),if(G8="岗位B",IF(BO8>=12000,2%,IF(BO8>=8000,1.5%,IF(BO8>=4000,1%,0)))),if(G8="岗位C",IF(BO8>=20000,7%,IF(BO8>=7000,4%,0))),if(G8="岗位
来源:学生作业帮助网 编辑:六六作业网 时间:2025/01/25 03:49:03
IF函数的嵌套问题公式如下:if(G8="岗位A",IF(BN8>=12000,6.5%,IF(BN8>=8000,6%,IF(BN8>=4000,5%,0))),if(G8="岗位B",IF(BO8>=12000,2%,IF(BO8>=8000,1.5%,IF(BO8>=4000,1%,0)))),if(G8="岗位C",IF(BO8>=20000,7%,IF(BO8>=7000,4%,0))),if(G8="岗位
IF函数的嵌套问题
公式如下:if(G8="岗位A",IF(BN8>=12000,6.5%,IF(BN8>=8000,6%,IF(BN8>=4000,5%,0))),if(G8="岗位B",IF(BO8>=12000,2%,IF(BO8>=8000,1.5%,IF(BO8>=4000,1%,0)))),if(G8="岗位C",IF(BO8>=20000,7%,IF(BO8>=7000,4%,0))),if(G8="岗位D",IF(BO820000,2%,0))))),输入公式后提示参数太多.
本人试用的O7版本的Excel,按理说可以嵌套64层.
求各位大神帮忙看看公式的问题所在已经有没有替代公式可用,
IF函数的嵌套问题公式如下:if(G8="岗位A",IF(BN8>=12000,6.5%,IF(BN8>=8000,6%,IF(BN8>=4000,5%,0))),if(G8="岗位B",IF(BO8>=12000,2%,IF(BO8>=8000,1.5%,IF(BO8>=4000,1%,0)))),if(G8="岗位C",IF(BO8>=20000,7%,IF(BO8>=7000,4%,0))),if(G8="岗位
嵌套这么多就不怕括号不配对么……就我所见发上来的确实就是括号不配对……