Adding Comments to Formulas
Adding comments to your worksheet allows you to share your thoughts with other users, or to serve as a reminder for yourself.
It’s also useful to be able to add comments to a formula, so that you can let other users of your workbook know if you’ve made a change to the formula, let them know what the result of the formula represents, or share other information about the formula.
After entering your formula, type +N(“Your comment here”)
For example if you have a formula that produces a class average, you can type:
=AVERAGE(A1:A25)+N(“Period 1 Class Average”)
