How do I add a comment inside an Excel formula?

Append +N('Your comment here') to the end of your formula. N() converts text to 0, so it does not affect the result. Example: =SUM(A1:A10)+N('Monthly revenue total').

Does the N() formula comment affect the cell's calculated result?

No - N('text') always returns 0, so adding it to a numeric formula does not change the result. It is purely a documentation tool.

Is there a better way to document complex Excel formulas?

For brief inline notes, N() works well. For fuller documentation, use Excel Comments (Shift+F2) on the cell, or add a separate documentation column beside the formula.

Add Comments Inside Excel Formulas with N()

Have you ever wanted to retrieve a complex formula you had created a while back and saved in a workbook, only to realise you could not recollect the logic of the formula, or what it is was expected to...

Well, there's a neat feature in Excel that lets you include comments within formulas, so you can document key info about the formula within the same cell it was inputted. You can even use this feature to leave notes for other users as guides for subsequent use of the formula.

You can include a comment within a formula, by adding "+ N("Your comment here")" in front of your formula.

How to Add a Comment or Note Inside an Excel Formula Using N()

Frequently Asked Questions