公式如下=IFERROR(ODATA("报价表?$select=单价&$filter=商品id eq "&IF(ISBLANK(H7),"null",H7)&" and 客户id eq "&IF(ISBLANK(客户ID),"null",客户ID)&" and 报价类型ID eq '1'"),ODATA("报价表?$select=单价&$filter=商品id eq "&IF(ISBLANK(H7),"null",H7)&" and 报价类型ID eq '1' and 分组id eq "&IF(ISBLANK(O4),"null",O4)))*T7
|
|