Question

EXCEL分段设置计算公式当D在1.5%——1.9%时,E等于C乘以1.5%；D在2%——2.5%时,E等于C乘以3%；

Answer 1

E2输入

=C2*LOOKUP(D2,{0.01,0;0.015,0.015;0.02,0.03;0.0251,0})

G2输入

=C2*LOOKUP(F2,{0.135,0;0.14,0.01;0.145,0.02;0.15,0.03;0.155,0.04;0.16,0})

（你对当D在2.5%以上、F在15.9%以上的没要求,我的公式就暂时设置=0）