[問題] EXCEL 陣列問題 判斷數值範圍 回傳 值

[ilf0121 (思想的崛起)]

軟體: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"," "))))))))))))


--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 118.169.147.45 (臺灣)
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1682633009.A.203.html
→ rafaiero: https://i.imgur.com/8NIbdxW.jpg
→ rafaiero: 類似這樣
推 windknife18: =LOOKUP(E6,{-1E+307,0,3001,6001,9001,12001,15001,
→ windknife18: 18001,21001,24001,27001,30001,50001},{0,30,60,90,
→ windknife18: 120,150,180,210,240,270,300,"",0})
→ ilf0121: 謝謝 W大神 和 R大神!!!   萬般感激
→ ilf0121: 請問大大 這可以用IFS函數嗎? IFS回傳的可以是數值嗎?