我想在Excel用If函数，谁能教教我。。！！

来源：百度知道 编辑：UC知道 时间：2024/06/08 01:18:39
大家好。。研究了很久都无结果。。。我就想
例如： A1输入一个数如果在以下的范围内就显示某个数。

91到150 显示出 "8"
151-280 "13"
281-500 "20"
501-1200 "32"
1201-3200 "50"
3201-10000 "80"
10001-35000 "125"
35001-150000 "200"

B1=IF(and（A1>=91,A1<=150),"8","")
B2=IF(and（A1>=151,A1<=280),"13","")
B3=IF(and（A1>=281,A1<=500),"20","")
B4=IF(and（A1>=501,A1<=1200),"32","")
B5=IF(and（A1>=1201,A1<=3200),"50","")
B6=IF(and（A1>=3201,A1<=10000),"80","")
B7=IF(and（A1>=10001,A1<=35000),"125","")
B8=IF(and（A1>=35001,A1<=150000),"200","")
在A1中输入值即可按你的要求在B1到B8中显示相应的值,可 “H!”我。
或：B1=IF(OR(A1>150000,A1<91),"",(IF(AND(A1>=35001,A1<=150000),"200",IF(AND(A1>=10001,A1<=35000),"125",IF(AND(A1>=3201,A1<=10000),"80",IF(AND(A1>=1201,A1<=3200),"50","0"))))+IF(AND(A1>=501,A1<=1200),"32",IF(AND(A1>=281,A1<=500),"20",IF(OR(A1>=151,A1<=280),"13"