How to Add a Note to an Excel Formula

You can add a comment to an Excel formula. This is different than adding a comment to a cell. The comment added to a formula can be considered, for example, as a note to explain the meaning of the results of a formula. A formula comment does not display like a cell comment can.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

• Microsoft Excel

1. Open an Excel file with existing formulas or create your worksheet with at least one formula.
2. Click in the cell at the end of the formula. In the above example, we will use =A2+A3 as our formula, with our insertion point at A5.
3. Add a plus sign and the letter N at the end of your formula, e.g., =A2+A2+N
4. Following the N function (click the image next to the Introduction above to see an enlarged view), type in your comment between quotes and within parentheses. e.g.
   
   =A2+A3+N("potential sales")
5. When you press enter (or tab or click outside the cell), your note is set. It will not affect the formula’s results. You will not be able to see that there is an annotation to the formula unless you click the cell that the formula is in