=IF(AND(B12≤1000000,C16=Y),B18=1000,IF(AND(B12≤1000000,C16=N),B18=500,IF(AND(1000000
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/14 21:30:36
![=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)
xJ@_\.U7ٻ/z(hJ.RPڴ5.2g3&ؖXȦw~[7seA;ІPTw,TvBzS&*{1+"96K`=0KisQ'(NLWHb¾}4IɵGgk
ghʒ /noRmzri(Oa$΅}u08`9n刴qhJpg!V=Qoa7bQh7XIksԃplRXŊ
w$=
=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个了.