excel中IF公式求解。假如A1是随机数字 B1要求输出 当A1<=1.时 B1=1同时A1<=1.5时 B1=2；A1<=2时 B1=3

Question

假如A1是随机数字 B1要求输出 当A1<=1.时 B1=1；时A1<=1.5时 B1=2；A1<=2时 B1=3 求大神解答！~

Answer 1

看了你对别人回答的补充，用下面的公式就好了：
=IF(OR(A1<=0,A1>3.54),"",LOOKUP(A1,{0,0.54,1.04,1.54,2.04,2.54,3.05},{1,2,3,4,5,6,7}))

Answer 2

=IF(A1<=1,1,IF(AND(A1>1,A1<=1.5),2,IF(AND(A1>1.5,A1<=2),3,"")))

Answer 3

参考公式：
=4-SUM(N(A1<={1,1.5,2}))追问

这什么东西

追答

参考公式：
=IF(A13.54),"",8-SUM(N(A1<={0.54,1.04,1.54,2.04,2.54,3.05,3.54})))

Answer 4

=IF(A1<=1,1,IF(A1<=1.5,2,IF(A1<=2,3)))追问

帮我编个7个的，分就给你，谢谢。
0<A1<=0.54 B1=1
0.54<A1<=1.04 B1=2
1.04<A1<=1.54 B1=3
1.54<A1<=2.04 B1=4
2.04<A1<=2.54 B1=5
2.54<A1<=3.05 B1=6
3.05<A1<=3.54 B1=7

追答

=LOOKUP(A1,{0,0.5401,1.0401,1.5401,2.0401,2.5401,3.0501,3.54},{1,2,3,4,5,6,7})