英文:
Google Sheets Array Error using Or asterisk
问题
以下是已翻译的内容：
我有下面的数组，它正在检查多个单元格的条件。但是，当列H中有一个值并且该值包含字母时，我收到一个错误。
我收到的错误是“函数MULTIPLY的第2个参数需要数值。但是'P02269895'是文本，无法强制转换为数字。”
然而，我没有添加/乘法。据我所知，AND/OR语句需要在数组中使用+/*。
我漏掉了什么？
TYIA
Mark
英文:
I have the below array which is checking multiple cells for conditions. However I am receiving an error when column H has a value in it and the value contains letters.
=ArrayFormula(if(A:A="","", if(row(A:A)=1,"Cert Generated?",
if(H:H="","N/A",
if((AF:AF=""*+H:H<>""),"No","Yes")))))
I receive the error "Function MULTIPLY parameter 2 expects number values. But 'P02269895' is a text and cannot be coerced to a number.".
However, I am not adding/multiplying. From what I know, AND/OR statements need to use a +/* in an array.
What am I missing?
TYIA
Mark
答案1
得分: 1
用以下部分替换公式中的这部分：
(AF:AF="")*(H:H<>"")
英文:
<!-- language-all: js -->
replace this part of the formula
(AF:AF=""*H:H<>"")
with
(AF:AF="")*(H:H<>"")
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论