如何在复杂的excel公式中添加评论 [英] How to add comment inside complex excel formula
问题描述
可以在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/
这篇关于如何在复杂的excel公式中添加评论的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!