How to add comments inside a Formula?

Rather than use the Excel Comments boxes, which can be a bit clumsy and/or intrusive, you cab use the N() function to add a comment inside a formula.

For example¬† =SUM(A1:A12)+N(“Sum of monthly sales for the year”)

The N() function can yield several values, but N(“any text string”) has a value of zero.

So, in this example, it adds 0 to the sum but leaves the comment inside the formula ?

Learn more comprehensive Excel Formulae, Click here

Happy Excelling
Team Excelgoodies

Leave a Reply

Your email address will not be published. Required fields are marked *