软件:EXCEL
请问大大 以下公式能否用阵列简化
主要是判断E6格 的数值 在哪个范围 回传什么值
=IF(E6<=0,0,
IF(E6<3001,30,
IF(E6<=6001,60,
IF(E6<=9001,90,
IF(E6<=12001,120,
IF(E6<=15001,150,
IF(E6<=18001,180,
IF(E6<=21001,210,
IF(E6<=24001,240,
IF(E6<=27001,270,
IF(E6<=30001,300,
IF(E6>50000,"0"," "))))))))))))

https://i.imgur.com/8NIbdxW.jpg类似这样

=LOOKUP(E6,{-1E+307,0,3001,6001,9001,12001,15001,18001,21001,24001,27001,30001,50001},{0,30,60,90,120,150,180,210,240,270,300,"",0})

谢谢 W大神 和 R大神!!! 万般感激请问大大 这可以用IFS函数吗? IFS回传的可以是数值吗?