如何在复杂的excel公式中添加评论

问题描述:

可以在excel公式的单元格中添加注释吗?我有一个非常长的表达在一个单元格,可以更好地理解,如果我可以在其中发表评论。

Is it possible to add a comment within the cell of an excel formula? I have an exceedingly long expression inside a cell that could better understood if I can comment within it.

Excel 2010是我的版本。以下是我想注意的示例单元格:

Excel 2010 is my version. Here is an example cell I'd like to notate:

=MID(
A4,
((FIND("n   ",A4,FIND(G4,A4))+75)+LEN(H4)+78),
(FIND("n   ",A4,(FIND("n   ",A4,FIND(G4,A4))+75))) - ((FIND("n   ",A4,FIND(G4,A4))+78))
)


N()函数允许您直接在您的公式的单元格中添加注释。要使用该函数添加注释,只需在公式的末尾添加加号(+),然后在括号内的引号中输入一些文本,将该文本传递给N()函数。

The N() function allows you add comments directly inside your cells on your formulas. To use the function to add a comment, simply add a plus sign (+) to the end of your formula, and then enter some text in quotes inside the parentheses, passing that text to the N() function.

示例: = YourFormula + N(comment)

或您可以在审阅选项卡的注释部分中使用添加评论。
http:// www.howtogeek.com/162231/add-comments-to-formulas-and-cells-in-excel-2013/

Or you can use "add comment" in the Comments section of the Review tab. http://www.howtogeek.com/162231/add-comments-to-formulas-and-cells-in-excel-2013/