扫码参与新品0元试用
晒单、顶楼豪礼等你拿
excel中没法嵌套第二个IF函数
回答数
4
浏览数
4,216
如果要用if函数，请试试下面的公式：
=if(g3="a",sheet2!c20,if(g3="b",sheet2!c6,if(g3="c",sheet2!c7,if(g3="d",sum(sheet2!c8:c10),if(g3="e",sheet2!c11,if(g3="f",sheet2!c12,if(g3="g",sheet2!c13,if(g3="h",sheet2!c14,0))))))))+if(g3="i",sheet2!c15,if(g3="j",sheet2!c16,if(g3="k",sheet2!c17,if(g3="l",sheet2!c18,if(g3="m",sheet2!c19,0)))))
也可试试下面的公式：
=if(g3="d",sum(sheet2!c8:c10),if((code(g3)78)*(code(g3)64)+(code(g3)110)*(code(g3)96),indirect("sheet2！c"&vlookup(g3,{"a",20;"b",6;"c",7;"e",11;"f",12;"g",13;"h",14;"i",15;"j",16;"k",17;"l",18;"m",19},2,)),""))
|
|
扫码参与新品0元试用
晒单、顶楼豪礼等你拿