IF/AND Google表格错误 [英] IF/AND Google Sheets error

问题描述

我正在尝试在工作表上创建IF语句，以便如果后三列(W，X，Y)中至少有一个包含是"，则Z列将显示1.包含否"，则Z列将显示"FALSE"或否".

I'm trying to create an IF Statement on Sheets so that if at least one of the last 3 columns (W,X,Y) contains 'YES' then column Z will say 1. If all of them are empty or contain 'NO' then column Z will say 'FALSE' or 'NO'.

请查看下面的内容，每次执行此操作时，它只会从W中获取数据，而忽略X和Y.

Please see what I have below, each time I do it, it only takes the data from W and ignores X and Y.

=IF(W3='DATA VALIDATION'!B2,
  1,
  AND(X3='DATA VALIDATION'!B2,1,AND(Y3='DATA VALIDATION'!B2,1,))
)

推荐答案

在W:Y上使用计数，以查看是否有是.任何大于 0 的结果在if中都为真. Z2的公式为:

Use a countif across W:Y to see if there is a Yes. Any result greater than 0 will ring true in an if. A formula for Z2 would be:

=if(countif(W2:Y2, "Yes"), 1, "No")

根据需要填充或向下拖动公式.

Fill or drag the formula down as necessary.

这篇关于IF/AND Google表格错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！