问题描述
我有一个很大的数据集,并创建了许多规则,我想用它来过滤掉一些不必要的数据点.
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"当参数满足时的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!