Question

我正在创建一个函数, 从工作表中生成并更新的线索中过滤值。公式用于 A, E & amp; G 中, 使用其他已有的列中的值。它正在为简单的公式工作, 只有一列可以引用, 例如 : =ARRAYFORMULA( IF ( ISBLANK (B2: B), “ “ TRUE ” ) )

不幸地为涉及更多栏目引用的公式制造问题,例如:

For implementing the following as an array function in A2: =IF(ISBLANK(B2),"",(if((C2=""), CONCATENATE(B2," Interest ",D2," ",G2),CONCATENATE(B2," Interest"," from ",C2," ",D2," ",G2))))

I tried to use this: =ARRAYFORMULA(IF(ISBLANK(B2:B),"",(if((C2:C=""), CONCATENATE(B2:B," Interest ",D2:D," ",G2:G),CONCATENATE(B2:B," Interest"," from ",C2:C," ",D2:D," ",G2:G)))))

它正在所有行中充斥所有值!

我知道我想做的事有问题

我在这里创建了一个样本文件 - < a href="https://docs.google.com/spreteshes/d/1BAwKX00VPV_GuyYI-JT3vqS-7xB8YTfaCY6-c1XQ/edit?usp=share" rel="nofoln noreferrer" >Isssue参考页 ,它有两个标签,一个带有工作功能,另一个带有阵列格式错误,我正试图用你的帮助加以解决。

十分感谢各方支持解决同样的问题。

提前感谢您!

Answer 1

使用代替 CoONCATENATE :

=ARRAYFORMULA(
   IF(B2:B="",,
    IF(C2:C="",B2:B&" Interest "&D2:D&" "&G2:G,
      B2:B&" Interest from "&C2:C&" "&D2:D&" "&G2:G)))

友情链接