While many folks know that notes are a great way to provide information about cell data, many people are unaware that you can also add notes to formulas using the N Function. This can come in quite handy, especially if you have a complex formula and want to document the process of going through it. The notes will appear in the formula bar following the formula.
To add notes to a formula:
- Type in the formula as you normally would.
- At the very end of the formula, press the spacebar and type in the plus (+) symbol.
- Type N.
- Type the open parenthesis.
- Type in your comment, surrounded by quotes.
- Type the close parenthesis.
Similar Posts:
- Add Comments in Excel 2007
- Using the Notes Pane in PowerPoint 2007
- Editing and Deleting Comments in Excel 2007
- Entering in Functions Manually in Excel
- Microsoft Releases OneNote for the iPhone
- Using 3-D Formulas and References in Excel
- Insert AutoSum using Keystrokes in Excel
