如何查找对应的佣金比例
多条件查找对应的数据有多种方法,譬如IFS,LOOKUP,INDEX+MATCH等都可以,以下仅以IFS和lookup函数为例,见下图
方法1:
=IFS(H3<500,0.0005,H3<1000,0.001,H3<1500,0.003,H3<2000,0.004,TRUE,0.005)
方法2:
=LOOKUP(1,0/(($B$3:$B$42=G3)*($D$3:$D$42<H3)),$E$3:$E$42)