旅遊休閒樂活趣

公式

=IF(A2="","--",VLOOKUP(A2,DATA!A:B,2,FALSE))

=IF(A1="","--",VLOOKUP(A1,[生產部工單每日餘量LIST.XLS]資料!$E:$Z,2,FALSE))

=IF(C2="","--",VLOOKUP(C2,[工單資料.xls]型名對照數量!$A:$B,2,FALSE))---換算pcs

=IF($A1128="","--",VLOOKUP($A1128,l2c!$G:$Z,2,FALSE))

=IF(D7<C7,"OK","NG")---=IF(P10<>100%,"OK","NG")--不等於

=SUMIF($N$13:$N$1278,N4,$O$13:$O$1278)

=COUNTIF(D3:D9,E3)--計算某區間符合個數的量

        項目             資料 

=IF(LEFT(H416,4)="1130","量產","")& IF(LEFT(H416,4)="1137","客退","")& IF(LEFT(H416,4)="1131","退庫","")& IF(LEFT(H416,4)="1132","工程","")& IF(LEFT(H416,4)="1135","PM","")

=IF(LEFT(H2,1)="F","實驗","")& IF(LEFT(H2,1)="C","實驗","")& IF(LEFT(H2,1)="P","研發","")& IF(LEFT(H2,1)="J","研發","")& IF(LEFT(H2,1)="R","實驗","")& IF(LEFT(H2,1)="","非實驗","")

=COUNTIF($A$5:$A701,">=31")-COUNTIF($A5:$A701,">=41")

=COUNTIF($A$5:$A$702,">=82")

=LEN(AD2)-計算字元

=MIDB(B3,5,5)--擷取部份字元

=SUM(D3,K3,R3,Y3)--仕掛無id

=LEFT(I2,LEN(I2)-1)-文字型態數字.變成真數字

=INDEX(資料庫,MATCH(條件,範圍,0))

=COUNTIF('SAP實盤-新版'!F:F,"=TFT")

=INDEX('早會(Cel IP)'!N:N,MATCH(C25,C:C,0))

=MATCH(F4,'SAP-DATA'!$D:$D,0)

公式
=IF(A2="","--",VLOOKUP(A2,DATA!A:B,2,FALSE))
=IF(A1="","--",VLOOKUP(A1,[生產部工單每日餘量LIST.XLS]資料!$E:$Z,2,FALSE))
=IF(C2="","--",VLOOKUP(C2,[工單資料.xls]型名對照數量!$A:$B,2,FALSE))---換算pcs
http://scmap01.cptt.com.tw/mos/SAP/main.asp
=IF($A1128="","--",VLOOKUP($A1128,l2c!$G:$Z,2,FALSE))
=IF(D7<C7,"OK","NG")---=IF(P10<>100%,"OK","NG")--不等於
=SUMIF($N$13:$N$1278,N4,$O$13:$O$1278)
=COUNTIF(D3:D9,E3)--計算某區間符合個數的量


項目 資料
=IF(LEFT(H416,4)="1130","量產","")& IF(LEFT(H416,4)="1137","客退","")& IF(LEFT(H416,4)="1131","退庫","")& IF(LEFT(H416,4)="1132","工程","")& IF(LEFT(H416,4)="1135","PM","")
=IF(LEFT(H2,1)="F","實驗","")& IF(LEFT(H2,1)="C","實驗","")& IF(LEFT(H2,1)="P","研發","")& IF(LEFT(H2,1)="J","研發","")& IF(LEFT(H2,1)="R","實驗","")& IF(LEFT(H2,1)="","非實驗","")
=COUNTIF($A$5:$A701,">=31")-COUNTIF($A5:$A701,">=41")
=COUNTIF($A$5:$A$702,">=82")
=LEN(AD2)-計算字元
=MIDB(B3,5,5)--擷取部份字元
=SUM(D3,K3,R3,Y3)--仕掛無id
=LEFT(I2,LEN(I2)-1)-文字型態數字.變成真數字
=INDEX(資料庫,MATCH(條件,範圍,0))
=COUNTIF('SAP實盤-新版'!F:F,"=TFT")
=INDEX('早會(Cel IP)'!N:N,MATCH(C25,C:C,0))
=MATCH(F4,'SAP-DATA'!$D:$D,0)