带有If函数的Google Sheet循环依赖问题 [英] Google Sheet Circular Dependency Issue With If Function

问题描述

Am使用Google表格A列中的 if 函数

Am using if function in Column A of the Google Sheets

= ARRAYFORMULA(if(isblank(D3:D)，A2:A，D3:D))

，但收到循环依赖错误.如果我在没有 ARRAYFORMULA 的情况下使用相同的功能，即

but getting Circular dependency error. If I use the same function without ARRAYFORMULA i.e.

if(isblank(D3)，A2，D3)))))

然后拖动公式，没有错误，结果得到反映.

and then drag the formula, there is no error and the result is reflected.

在上述情况下，任何有关使用 ARRAYFORMULA 修复循环依赖错误的帮助都将不胜感激.

Any help on how to fix the Circular dependency error with ARRAYFORMULA in above case would be greatly appreciated.

推荐答案

当您看到在您的计算机上显示检测到的循环依赖错误时Google电子表格，这意味着您的公式所引用的是包含公式本身的范围，换句话说，公式输入取决于输出.

When you see the circular dependency detected error displayed in your Google spreadsheet, this means that your formula is referring to a range that contains the formula itself, or in other words when the formula input, is dependent on the output.

您可以尝试做的是在 File->下打开迭代计算".设置:

如果这可以解决您的问题，那就很好.但是根据您的公式，我认为这不是解决方法.上面的选项最适合重复计算值.您当前的公式无法做到这一点.

If that fixes your issue then good. But based on your formula, I don't think this is a fix. The above option is best on recalculating values repetitively. Your current formula is not doing that.

如果是这种情况，那么您只需将公式放在另一列上即可避免循环依赖.

If that's the case, then you'll just have to put the formula on another column to avoid the circular dependency.

我建议您尝试阅读以下有关循环依赖的参考，它可能有助于您决定应该做什么.

I recommend you try and see the reference below about circular dependency and it might help you decide what you should do.

• 循环依赖

这篇关于带有If函数的Google Sheet循环依赖问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！