Excel 公式查看器
Back
粘贴Excel:
(IF(ISNUMBER(SEARCH(LEFT($DG$1,20),$X$6)),Sheet2!$J$6,)*$Y$6+IF(ISNUMBER(SEARCH(LEFT($DG$1,20),$AB$6)),Sheet2!$J$6,)*$AC$6+IF(ISNUMBER(SEARCH(LEFT($DH$1,20),$X$6)),Sheet2!$J$6,)*$Y$6+IF(ISNUMBER(SEARCH(LEFT($DH$1,20),$AB$6)),Sheet2!$J$6,)*$AC$6)*$C3*$C$6