IF條件函數(shù)多層嵌套應(yīng)用

如果在D單元格中的結(jié)果是通過(guò)A單元格的不同條件選擇，進(jìn)行B、C單元格的數(shù)據(jù)計(jì)算。這一方法用于計(jì)算異型梁、柱、獨(dú)立基穿條形基礎(chǔ)等工程量上非常簡(jiǎn)潔。
    =IF(A1="A",B1,"")&IF(A1="B",B1*C1,"")&IF(A1="C",B1-C1,"")&IF(A1="D",B1/C1,"")&IF(A1="E",C1+B1,"")&IF(A1="F",C1,"")&IF(A1="G",B1^2,"")&IF(A1="H",C1^2,"")