OR 函数不返回“TRUE"当参数满足时 [英] OR function not returning "TRUE" when parameters met

问题描述

我有一个很大的数据集，并创建了许多规则，我想用它来过滤掉一些不必要的数据点.

I have a large data set and have created a number of rules I want to use to filter out some of the unnecessary data points.

以下是一些数据的简化示例:

Here is a simplified example of some data:

    A         B        C        D
1 PIPPIP      0    0.411298  PIPPIP
2 PIPPIP     0.6    0.40924  PIPPIP
3 PIPPIP      1    0.378689  PIPPIP
4 PIPPIP      1    0.75456   PIPPIP
5 PIPPIP     0.8   0.967534  PIPPIP
6 PIPPYG     0.9   0.865426  PIPPYG
7 PIPPYG     0.9   0.789654  PIPPYG

一个示例规则是将 B > 0.89 且 C 值 > 0.749(如果 D=PIPPIP)或 >0.849(如果 D=PIPPYG)的所有数据点分开

An example rule would be to separate all data points which have both B > 0.89 and C value of > 0.749 if D=PIPPIP or >0.849 if D=PIPPYG

为此，我使用以下公式:

To do this I am using the formula:

=AND(B1>0.89,(OR((AND(D1="PIPPIP",C1>0.749)),(AND(D1="PIPPYG",C1>0.849))))) 

但是，即使对于满足这两个条件的点，这也始终返回 FALSE 值.我知道公式中一定有错误，但我无法弄清楚错误是什么.有人可以给我指出来吗?

However, this always returns a FALSE value even for points which meet both criteria. I know that there must be an error in the formula but I can't figure out what the error is. Would someone please point it out to me?

或者是我不能像我那样嵌套 OR 函数的问题?

Or is the problem that I can't nest OR functions like I have?

如果有人能引导我完成这个，我将不胜感激.

I would really appreciate if someone would walk me through this.

谢谢.

推荐答案

在这种情况下，你能做的最好的事情是:

In this case the best you can do is the following:

• 选择带有公式的单元格.
• 使用 Excel 中的内置评估器逐步评估公式(选项卡公式>评估公式>评估):

• 找出错误并修复它.

这篇关于OR 函数不返回“TRUE"当参数满足时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！