EXCEL中公式怎么簡化？

=IFS(OR(B7={"圓法蘭","模板"}),BB7,OR(B7={"鋼板","方法蘭","扁鋼","帶鋼","鍍鋅扁鋼"}),BC7,OR(B7={"矩形管","方管"}),BD7,OR(B7={"焊管","無縫管","螺旋焊管","不銹鋼無縫管"}),BF7,OR(B7={"圓鋼","鋼筋","螺紋鋼","盤圓","鍍鋅圓鋼","不銹鋼圓鋼"}),BE7,B7="角鋼",BG7,B7="不等邊角鋼",BH7,B7="槽鋼",BI7,OR(B7={"螺栓","腳釘"}),BN7,OR(B7={"地腳螺栓","全絲桿","雙頭絲桿"}),BO7,B7="方鋼",BJ7,B7="H型鋼",B

請高手幫忙簡化EXCEL函數(shù)公式？

方法是：

1、在101-108表中先設(shè)置某個輔助單元，輸入相同的函數(shù)=CONCATENATE(E4," ",G4," ",I4," ",K4," ",M4," ",O4," ",Q4," ",S4," ",U4," ",W4)，假如，A4存放本表匯總

2、在匯總表中=CONCATENATE('101'!A4,'102'!A4,'103'!A4,'104'!A4,'105'!A4,'106'!A4,'107'!A4,'108'!A4)

請問excel函數(shù)公式如何簡化？

目測......

if 有四個參數(shù)嗎 .....

=IF(AND(E3="一級",OR(B3="北四分",B3="北一分",B3="深圳",B3="蘇州")),3500*90%,3500*81%,IF(A

1. AND(E3="一級",OR(B3="北四分",B3="北一分",B3="深圳",B3="蘇州"))

2. 3500*90%

3. 3500*81%

4. IF(A.....

難道我眼睛花了?????

函數(shù)公式如何簡化

=SUMPRODUCT(($A$2:$A$10=$Y2)*($B$2:$B$10=$Z2)*$G$2:$G$10+($H$2:$H$10=$Y2)*($I$2:$I$10=$Z2)*$N$2:$N$10+($O$2:$O$10=$Y2)*($P$2:$P$10=$Z2)*$T$2:$T$10) 如果公式是右拉的則還可以去掉行號前的絕對引用符號$ 如: =SUMPRODUCT(($A2:$A10=$Y2)*($B2:$B10=$Z2)*$G2:$G10+($H2:$H10=$Y2)*($I2:$I10=$Z2)*$N2:$N10+($O2:$O10=$Y2)*($P2:$P10=$Z2)*$T2

EXCEL函數(shù)公式簡化

COUNTIF(range,criteria)是excel中的一個函數(shù)，用來計算區(qū)域中滿足給定條件的單元格的個數(shù)。例如，返回包含值12的單元格數(shù)量，則“=COUNTIF（DATA,12）”。 本函數(shù)中，只有兩個函數(shù)，if函數(shù)和countif函數(shù)，且都位于第4行，解釋清楚一個，其它都明白了，以第一個為例。 IF(COUNTIF(B4:C4,"□")>0,1,0)意思是，如果B4:C4范圍內(nèi)【實際上就是B4和C4單元格】有不止一個"□"，則返回1，否則返回0。所以這句話的意思就是，如果B4、C4單元格里有"□"則計數(shù)1次；沒有，則不計數(shù)，為0； IF(COUNTIF(E4:F4,"□")>0,1,