假如用EXCEL函数公式核算快递公司首重续重运费

可在E列中输入如下公式: =IF(D2<=1,VLOOKUP(C2,Sheet2!$A$2:$C$9,2,FALSE),VLOOKUP(C2,Sheet2!$A$2:$C$9,2,FALSE)+INT(D2)*VLOOKUP(C2,Sheet2!$A$2:$C$9,3,FALSE))