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

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

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

为此，我使用公式:

=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屋！