EXCEL中函数查找值是否在区间内,若在即返还相应值?答:=IFERROR(LOOKUP(B13*100,{65,70,75,80,85,90,95},{151,189,227,265,303,379,454}),"")输入公式下拉
如何在EXCEL中判断判断一个数值属于多区间中的哪个部分,并按相应公式...答:=CHOOSE(SUM(N(A1>{0,10,50,100,200,500,1000,2000,5000})),A1*8%,A1*7%,A1*5%,A1*3%,A1*1.6%,A1*0.7%,A1*0.3%,A1*0.12%,A1*0.05%)