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