Excel为什么我的IF-formula不工作？ [英] Excel Why is my IF-formula not working?

问题描述

我有这个公式：

=IF(testing!I:I=A6;testing!A:A;"wrong")

我想用公式控制值映射是否正确。

我想知道A6中的值是否在测试表中的列A中有更多的相应值。所以当A6出现在第一列中时，我想知道A列中有哪个相应的值，或者如果他有多于一个，我想以错误的方式作为答案。

I want to control with the formula whether the mapping of values is right.
I want to know whether the value in A6 has more corresponding values in the column A in the 'testing'-sheet. So when A6 appears in the column I, I either want to know which corresponding value it has in column A, OR if he has MORE THAN ONE, I want to get 'wrong' as an answer.

推荐答案

我认为这是因为如果简单的测试只是 = I：I = A6 总是返回 FALSE 。

I think that is because if you simplify the test to just =I:I=A6 that will always return FALSE.

这篇关于Excel为什么我的IF-formula不工作？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！