How to add a comment to a complex excel formula

Question

Can I add a comment to an excel formula cell? I have an extremely long expression inside a cell that can be better understood if I can comment on it.

Excel 2010 is my version. Here is an example of a cell that I would like to mention:

=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)) ) 

Answer 1

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

Example: =YourFormula+N("comment")

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

Answer 2

Like this:

 =SUM(A1:A4)+N("This is a comment") 

http://www.howtogeek.com/162231/add-comments-to-formulas-and-cells-in-excel-2013/

Answer 3

The comment function N () should not be the last part of the function. So this is an acceptable solution:

= + C6 + N ("C6 variable description") + C7 + N ("C7 info") + C8 + N ("C8 info")

While not required, to improve readability, I use params to indicate that the comment refers to multiple elements. In this example, the first comment only refers to cell "q13", and the next two comments relate to the calculation between "(...)"

= + AA435 * q13 + N (bonus factor) + (c435 * $ d $ 4 / a435) + N (“profit, scalable by area”) + (p24 * $ q $ 5 + w12 * 3) + N (“bl. .. ")

I always prefer to break complex complex formulas into one simple consolidation formula that combines the hidden columns of intermediate formulas.