98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Adding a comment to a formula

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

Added by Rich on 28th June 2006

More Excel hints and tips, like:

• Bracketed negative numbers
• Select Single Data Marker
• New to Excel 2010 - Sparklines!