如何在excel一个表格中设置多个条件语句

Question

我想达到这样的效果：在A1中输入数值，当小于等于3000时B2显示差，大于3000小于4000时显示良；大于等于4000时显示优。请问在EXCEL中如何设置？

请各位大虾们帮帮忙！谢谢了~
我想达到这样的效果：在A1中输入数值，当小于等于3000时B2显示差，大于3000小于4000时显示良；大于4000时显示优。大于5000时显示冲击冠军请问在EXCEL中如何设置？

Answer 1

=IF(A1>=4000,"优",IF(A1>3000,"良","差"))
或者
=LOOKUP(A1,{0,3000.0001,4000;"差","良","优"})追问

我想达到这样的效果：在A1中输入数值，当小于等于3000时B2显示差，大于3000小于4000时显示良；大于4000时显示优。大于5000时显示冲击冠军请问在EXCEL中如何设置？

追答

=IF(A1>=5000,"冲击冠军",IF(A1>=4000,"优",IF(A1>3000,"良","差")))
或者
=LOOKUP(A1,{0,3000.0001,4000,5000;"差","良","优","冲击冠军"})

本回答被提问者和网友采纳

Answer 2

B2公式
=if(A1<=3000,"差",if(A1<4000,"良","优"))
=if(A1<=3000,"差",if(A1<4000,"良",if(a1<5000,"优","冲击冠军")))

Answer 3

=if(a1<=3000,"差",if(a1<4000,"良","优"))追问

假如有4个（含）以上的结果，怎么就进行不了呢？

Answer 4

B2
=if(a1<=3000,"差",if(a1<4000,"良","优"))