Excel公式符号帮助 [英] Excel Formular Symbol Help

问题描述

大家好，



我正在审核我刚刚递交的excel表中的一些公式。一旦我查看了这些公式，我就会知道如何在我正在进行的项目中对它们进行编码。



现在，我遇到了一个特定的单元格，其中包含我发现很难理解的公式，我希望这里的某个人能够用更简单的术语向我解释。公式如下：

Hi All,

I am just reviewing some formulas in an excel sheet that i have just been handed . Once i have reviewed these formulas I will some how need to code them in the project i am currently working on.

Now, I have come across a particular cell which contains a formula that i'm finding hard to understand and I hope some one on here will be able to explain it to me in simpler terms. The formula is as follows:

引用：

= F10-C10-I10

=F10-C10-I10

现在根据我的理解是：F10单元格中的值减去了C10中的值..现在最后一个是我卡住的地方，我不理解

Now according to my understanding is: the value in F10 cell is subtracting the value in C10.. now the last Is where i am stuck , I don;t understand the

引用：

-I10

位。这个垂直划线是否意味着excel中的任何特殊内容？



感谢您的时间和帮助！

bit. Does that vertical dash mean anything special in excel?

Thank you for your time and help!

推荐答案

这是I10，如第I列第10行。



事实上，如果你在一个单元格中进入编辑模式，你应该在每个参与的细胞周围获得高光，你应该看到所有3。 br />


公式从单元格C10中减去单元格I10，然后从单元格F10中减去该单元格。

It's I10, as in column I row 10.

In fact if you go into edit mode in a cell like that you should get highlights around each of the cells that are involved and you should see all 3.

The formula is subtracting cell I10 from cell C10 and then subtracting that from cell F10.

这篇关于Excel公式符号帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！