=index({23,24,25},1)显示23,
=TEXT(INDEX({23,24,25},1),0)&TEXT(INDEX({23,24,25},2),0)&TEXT(INDEX({23,24,25},1),0)显示232425
问:有再简单得公式将数组中的各元素组合在一起
AA={23,24,25}
=sum(AA*100^{2,1,0})
使用道具 举报
难道是六段函数一?
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-16 14:34 , Processed in 0.340381 second(s), 7 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.