=IF(AND(B12≤1000000,C16=Y),B18=1000,IF(AND(B12≤1000000,C16=N),B18=500,IF(AND(1000000
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/18 01:32:04
![=IF(AND(B12≤1000000,C16=Y),B18=1000,IF(AND(B12≤1000000,C16=N),B18=500,IF(AND(1000000](/uploads/image/z/3493480-40-0.jpg?t=%3DIF%28AND%28B12%E2%89%A41000000%2CC16%3DY%29%2CB18%3D1000%2CIF%28AND%28B12%E2%89%A41000000%2CC16%3DN%29%2CB18%3D500%2CIF%28AND%281000000)
=IF(AND(B12≤1000000,C16=Y),B18=1000,IF(AND(B12≤1000000,C16=N),B18=500,IF(AND(1000000
=IF(AND(B12≤1000000,C16=Y),B18=1000,IF(AND(B12≤1000000,C16=N),B18=500,IF(AND(1000000
=IF(AND(B12≤1000000,C16=Y),B18=1000,IF(AND(B12≤1000000,C16=N),B18=500,IF(AND(1000000
不知道你是哪个软件中的公式,极有可能是嵌套层数太多了,有可能最大嵌套层数为7层,我数的话也头晕,看你最后的括号数已经有10个了.