同学,这个很好办,给你做了下,如图:=IF(A2<-10,"极冷",IF(A2<-5,"很冷",IF(A2<5,"郑歼冷",IF(A2<15,"有点冷","暖和"))))在你自己的表中,把公式改为=IF(E3<-10,"极冷",IF(E3<-5,"很冷",IF(E3<5,"冷",IF(E3<15,"有点冷","暖和"))))可以采纳啦。……碧巧。。…悔丛键…。……。。……