excel如何将一列数值按区间划分，同时另外一项数值对乘以对应系数？

Question

如题所述

Answer 1

分区间的话，用lookup 

方法如下：=LOOKUP(D7,{0,0.2,0.3,0.35,0.4},{"不打折","98折","95折","9折","85折"})

Answer 2

在E2中输入如下公式
=a2*lookup(d2,{30,35,40,45}%,{95,90,85,80}%)
下拉填充本回答被网友采纳

Answer 3

=IF(E2>0.35,0.9,IF(E2>0.3,0.95,1))*A2