第1个回答 2014-04-11
M1=IF(K1>=H1,IF(K1<I1,J1*L1,IF(K1<I2,J2*L1,IF(K1<I3,J3*L1,IF(K1<I4,J4*L1,IF(K1<I5,J5*L1,IF(K1<I6,J6*L1,J7*L1)))))))
第2个回答 2014-04-11
=L1*VLOOKUP(K1,H1:J7,3)
或:
=L1*CHOOSE(MATCH(K1,{20,30,40,50,60,70,80,100},1),0.9,0.85,0.8,0.75,0.7,0.65,0.6)本回答被网友采纳