excel中满足多个条件中的一个条件并返回值

Question

填入单元格数据如等于其中一个条件返回相应的值.
如:100或200或300或400或......返回5 500或600或700或800或......返回6,,
在单元格中如A1中填入数据100,如果满足条件在A2中返回5
在单元格中如A1中填入数据200,如果满足条件在A2中返回5
在单元格中如A1中填入数据500,如果满足条件在A2中返回6
.........

Answer 1

=IF(OR(A1=100,A1=200,A1=300,A1=400),5,IF(OR(A1=500,A1=600,A1=700,A1=800),6,""))

Answer 2

=if(or(a1=100,a1=200,a1=300,a1=400),5,if(or(a1=500,a1=600,a1=700,a1=800,a1=900),6,""))

Answer 3

B1=if(A1>=500,6,5)

Answer 4

=if(A1=choose{100,200,300,400},5,if(A1=choose{500,600,700,800},6,""))

Answer 5

A2单元格输入公式=IF(OR(A1=100,A1=200,A1=300,A1=400),5,IF(OR(A1=500,A1=600,A1=700,A1=800),6,"其它"))。