excel函数公式

男","男","

長安東路

市",C56)+1,FIND 市",C57)+1,FIND

統計函數

查找引用與數據庫函數

必須找到完全相同的實例

水平查找---HLOOKUP( )--

,數組)

索引---INDEX( )

四","五")

待加強","尚可","优等","尚可","优等")

") =IF(MOD(C25,D25)=0,"可整除","否")

6整除

","小姐") HT(C42,2)&IF(D42="男","先生","小姐")

C56,FIND("市",C56)+1,FIND("路",C56)-FIND("市",C56))

市",C57))

优")

")

差")

")

")

",D115:D120)

",D115:D120)

門市",D115:D120)/COUNTIF(B115:B120,"門市")

業務",D116:D121)/COUNTIF(B116:B121,"業務")

3名而是第

按工號手工輸入查找

=VLOOKUP($C$204,$B$195:$I$201,2,FALSE)

=VLOOKUP($C$204,$B$195:$I$201,3,FALSE)

=VLOOKUP($C$204,$B$195:$I$201,6,FALSE)

=VLOOKUP($C$204,$B$195:$I$201,7,FALSE)

=IF(ISERROR(VLOOKUP($C$211,$B$195:$I$201,2,FALSE)),找不到",VLOOKUP($C$211,$B$195:$I$201,2,FALSE))

2.(

=LOOKUP(D237,$B$231:$C$234)

=LOOKUP(D238,$B$231:$C$234)

=LOOKUP(D239,$B$231:$C$234)

=LOOKUP($C$244,B237:B242,C237:C242)

=LOOKUP($C$244,B237:B242,D237:D242)

=LOOKUP($C$244,B237:B242,E237:E242)

=MATCH(C284,B277:B282,0)

=MATCH(C285,C276:H276,0)

B282,0),MATCH(C285,C276:H276,0))

","二","三","四","五")

TCH(D300,{0,1000,10000,30000

差","待加強","尚可","优等")

NT(D303/30000)+1>=3,3,INT(D303/30000)

待加強","尚可","优等")

D311,E309:E311))