[已解决]IF函数超出嵌套层数，求帮忙解决，谢谢 需要函数如下

叶遮尘

if(a1<200,"1",if((a1>200)*(a1<300),"2",if((a1>300)*(a1<500),"3",if((a1>500)*(a1<800),"4",if((a1>800)*(a1<1000),"5",if((a1>1000)*(a1<1200),"6",if((a1>1200)*(a1<1500),"7",if((a1>1500)*(a1<1800),"8",if((a1>1800)*(a1<2000),"9",if((a1>2000)*(a1<2200),"10",if((a1>2200)*(a1<2500),"11",if((a1>2500)*(a1<2800),"12",if((a1>2800)*(a1<3000),"13",if((a1>3000)*(a1<3200),"14",if((a1>3200)*(a1<3500),"15","")))

最佳答案

月排行榜 / 总排行榜

绿卡816-沸点

2017-4-19 09:54

LOOKUP($A$1,{0,200,300,500,800,1000,1200,1500,1800,2000,2200,2500,2800,3000,3200,3500},{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,""})

跳转到最佳答案楼层

砂海

=choose( 数值 , 结果1 , 结果2 ,....)
数值为1 , 对应结果1
数值为2 , 对应结果2

设计好数值就好

绿卡816-沸点

LOOKUP($A$1,{0,200,300,500,800,1000,1200,1500,1800,2000,2200,2500,2800,3000,3200,3500},{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,""})

hupin6331

IF超过7个，可以用“&”或“+”解决，这个可以百度下。用LooKUP函数替代IF更简单，供参考

1. =LOOKUP($A1,{0,200,300,500,800,1000,1200,1500,1800,2000,2200,2500,2800,3000,3200,3500},{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,""})

复制代码

叶遮尘

砂海 发表于 2017-4-19 09:31
=choose( 数值 , 结果1 , 结果2 ,....)
数值为1 , 对应结果1
数值为2 , 对应结果2

我的数值是要200-300 ，300-400，400-500.一直循环下去，这个数值要怎么设置，能详说吗  谢谢

叶遮尘

绿卡816-沸点 发表于 2017-4-19 09:54
LOOKUP($A$1,{0,200,300,500,800,1000,1200,1500,1800,2000,2200,2500,2800,3000,3200,3500},{1,2,3,4,5,6, ...

谢谢