=LOOKUP(C3,{"-100000%","-1.49999999%","-0.49999999%","0.5000001%","1.500000001%"}*1,{"大跌","小跌","横盘","小涨","大涨"})
=LOOKUP(C3,{-9E9,-1.5,-0.5,0.5,1.5}+1%%,{"大跌","小跌","横盘","小涨","大涨"})'有效请采纳
