首页=TEXTJOIN("+",TRUE,B2:B1048576) 这个公式报错#NAME?

=TEXTJOIN("+",TRUE,B2:B1048576) 这个公式报错#NAME?

时间: 2024-03-05 08:51:00 浏览: 138

trueman:轻松断言字符串、整数的真值和假值。（不要与#present？和#blank 混淆？）

真男人介绍：世界上最小的 RubyGem...（几乎）断言一个值是否与这个小宝石的真或假的常见形式之一匹配。安装将此行添加到应用程序的 Gemfile 中： gem 'trueman' 然后执行： $ bundle 用法 Trueman 旨在断言某个值是否为真。它不测试值presence ，只是它匹配以下项目之一： Trueman . truthy? 1 # => true Trueman . truthy? "1" # => true Trueman . truthy? "t" # => true Trueman . truthy? "T" # => true Trueman . truthy? true # => true Trueman . truthy? "true" # => true Trueman . truthy?

如果您的Excel版本低于2016，则不能使用TEXTJOIN函数，您可以使用以下公式： ``` =IFERROR(INDEX(B2:B1048576,1)&IFERROR("","+"&INDEX(B2:B1048576,2))&IFERROR("","+"&INDEX(B2:B1048576,3))&IFERROR("","+"&INDEX(B2:B1048576,4))&IFERROR("","+"&INDEX(B2:B1048576,5))&IFERROR("","+"&INDEX(B2:B1048576,6))&IFERROR("","+"&INDEX(B2:B1048576,7))&IFERROR("","+"&INDEX(B2:B1048576,8))&IFERROR("","+"&INDEX(B2:B1048576,9))&IFERROR("","+"&INDEX(B2:B1048576,10))&IFERROR("","+"&INDEX(B2:B1048576,11))&IFERROR("","+"&INDEX(B2:B1048576,12))&IFERROR("","+"&INDEX(B2:B1048576,13))&IFERROR("","+"&INDEX(B2:B1048576,14))&IFERROR("","+"&INDEX(B2:B1048576,15))&IFERROR("","+"&INDEX(B2:B1048576,16))&IFERROR("","+"&INDEX(B2:B1048576,17))&IFERROR("","+"&INDEX(B2:B1048576,18))&IFERROR("","+"&INDEX(B2:B1048576,19))&IFERROR("","+"&INDEX(B2:B1048576,20)), "") ``` 该公式会将B2单元格及其以下所有不为空的单元格内容用符号+连接起来。请注意，如果您的数据超过B2:B1048576范围，请根据实际情况修改公式中的数据范围。

阅读全文