WPS常用代码

原料计算数量

=D2*EVALUATE(SUBSTITUTE(SUBSTITUTE(C2,"kg",""),"L",""))+E2

查询原料箱数

=VLOOKUP(B2,[三香原物料库存202508.xlsx]原料!$C:$H,6,0)/PRODUCT(--TEXTSPLIT(SUBSTITUTE(SUBSTITUTE(C2,"kg",""),"L",""),"*"))

查询库区

=XLOOKUP(B2,原料!$C:$C,原料!$B:$B,XLOOKUP(B2,包装!C:C,包装!B:B,0,0,1),0,1)

查询规格

=XLOOKUP(B2,原料!$C:$C,原料!$D:$D,XLOOKUP(B2,包装!$C:$C,包装!$D:$D,0,0,1),0,1)

库存单位

=IFERROR(VLOOKUP(B2,包装!$C:$E,3,0),0)

结存数量

=XLOOKUP(B2,原料!$C:$C,原料!$H:$H,XLOOKUP(B2,包装!$C:$C,包装!$J:$J,0,0,1),0,1)

结存数量对比

=H2-G2

应当结余

=XLOOKUP(B2,原料!$C:$C,原料!$E:$E,XLOOKUP(B2,包装!$C:$C,包装!$F:$F,0,0,1),0,1)-I2

初期结余日盘

=XLOOKUP(B2,原料!$C:$C,原料!$E:$E,XLOOKUP(B2,包装!$C:$C,包装!$F:$F,0,0,1),0,1)