excel中某一个值在区间内,则显示为一个值,如图,应该怎么写公式答:公式为:=VLOOKUP(A1,{0,1;0.1,2;0.3,3;0.5,4;0.8,5},2)如图所示:
举例求教:excel区间函数公式答:在A2单元格输入公式:=IF(A1<0.5,"",IF(A1<3,0.2,IF(A1<6,0.3,IF(A1<30,0.5,IF(A1<120,0.8,IF(A1<400,1.2,"")))或者:=IF(OR(A1<0.5,A1>400),"",LOOKUP(A1,{0,3,6,30,120},{0.2,0.3,0.5,0.8,1.2}))...