在C8单元格输入以下公式,然后向右填充公式=C6*LOOKUP(C7,{0,0.8,1,1.3},$M5:$M8)
=C6*LOOKUP(C7,{0,0.8,1,1.3},$M$5:$M$8)
或者是:
=C6*LOOKUP(C7,{0,0.8,1,1.3},{0.007,0.009,0.012,0.015})