假设A1为x在B1中输入=IF(A1>1,A1+0.1,IF(A1=0,1,IF(AND(A1<=-1,A1>=-3),0.8,IF(AND(A1<=-4,A1>=-7),0.5,IF(A1<-7,0,"")))))
假设A1是X,B1是Y,B1输入以下公式:=LOOKUP(A1,{-99,-7,-3,0,1}^{9,1,1,1,1},{0,0.5,0.8,1,1.1})
