excel formula

;abap debug inner table, then download, if use si tai, minus data must tranfer
=IF(RIGHT(G2,1)="-",VALUE(LEFT(G2,LEN(G2)-1))*-1,VALUE(G2))

;abap source code hikaku,
=TRIM(TEXT(A2,))=TRIM(TEXT(B2,))

;get benifit center 4 kai
=VLOOKUP(C2,Sheet2!A:J,10,FALSE)

;lookup result is null, transfer
=IF(ISNA(D2),C2,D2)

;lookup result is null, transfer
=IF(ISNA(VLOOKUP(C2,Sheet3!A52:B116,2,FALSE)),C2,VLOOKUP(C2,Sheet3!A52:B116,2,FALSE))

;lookup result is null, transfer
=IF(ISNA(VLOOKUP(D2,Sheet3!$A$1:$B$50,1,FALSE)),"9999",VLOOKUP(D2,Sheet3!$A$1:$B$50,1,FALSE))

=LEFT(C1,4)
=RIGHT(C1,LEN(C1)-4)
=" ,"&B1&" “&D1&” “&E1&” “&I1
=” ,"&TEXT(F1&G1&LENB(I1)-1,“00000000000”)&") TYPE C VALUE “&I1&”’"

=VALUE(“20”)