在Google电子表格中绕过循环引用 [英] Getting around circular reference in Google Spreadsheet

问题描述

我有一个带有两列的Google文档电子表格：A和B.
B的值只是来自A的不同格式的值，并且在B列中有一个用于执行转换的公式。
有时候我没有A格式的值，但是我有B格式的值。我想通过添加在A列中进行反向转换的公式，自动在A列中获取A格式的值。这当然会产生一个循环引用。有没有办法避开它？

I have a google docs spreadsheet with two columns: A and B. Values of B are just values from A in a different format, and I have a formula in the B column that does the conversion. Sometimes I do not have the values in A format but I have them in B format. I would like to automatically get the values in A format in the A column by adding the formula that does the reverse conversion in the A column. This, of course, generates a circular reference. Is there a way to get around it?

推荐答案

使用其他单元格来保存实际（非公式）数据，并使用公式单元格显示结果，而不是引用您的共依赖公式单元格。不幸的是，无法绕过循环引用。

Instead of referencing your co-dependent formula cells, use other cells to hold your actual (non-formulaic) data and use the formula cells to show your results. There's no way to get around circular references, unfortunately.

这篇关于在Google电子表格中绕过循环引用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！