Re: [问题] EXCEL 阵列问题 判断数值范围 回传 值

楼主: windknife18 (windknife18)   2023-04-30 17:37:23
IFS 的用法跟你原始的写法很像
=IFS(E6<=0,0,
E6<3001,30,
E6<=6001,60,
E6<=9001,90,
E6<=12001,120,
E6<=15001,150,
E6<=18001,180,
E6<=21001,210,
E6<=24001,240,
E6<=27001,270,
E6<=30001,300,
E6>50000,0,
TRUE," ")
※ 引述《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"," "))))))))))))
作者: ilf0121 (思想的崛起)   2023-05-01 04:31:00
谢谢大神指导!

Links booklink

Contact Us: admin [ a t ] ucptt.com