=A1*IF(A1<100,0.4,IF(A1<200,0.5,0.6))
如果那个100或200的数字在A1,要乘以的数字在A2,B1中输入=if(A1<100,0.4,if(A1<200,0.5,0.6))*A2
=a1*lookup(a1,{0,100,200,},{0.4,0.5,0.6})a1为数据所在单元格
=if(a1<100,a1*0.4,if(a1<200,a1*0.5,a1*0.6))