You're probably already familiar with this feature and if you're like me, you've sprinkled your sheets with useful comments.
Related: How to Select a Boot Drive
How to Add Comments in Microsoft Excel?
Cell comments aren't the only way to share relevant information about the contents of a cell. Did you know that you can insert a comment into a formula? Most likely, you'd use this feature to document a formula when the formula itself isn't clear. For instance, perhaps a formula is long or it references oddly-named ranges. Or, you might want to include a note about what the formula does or the type of data it should return.
Related: How to Reset Windows 7 Password
To add a comment to a formula, use the following form:
Formula + N("your comment")
For instance, the following formula contains a note that explains the formula's purpose:
=($C2-$B2 + ($B2>$C2))-$D2+N("Returns the elapsed time between two time values")
In this particular formula, there's no way to tell what's going on, so the note adds valuable information to other users. Of course, users can easily see the formula's purpose by simply viewing the spreadsheet! Of more value, might be a note that shares the required data types, or even a development note that identifies the person who entered the formula, or perhaps the person who last modified the formula and why--if that information is relevant to other users in some way.
Related: How to Make Banners with Macromedia
This feature works in all versions of Excel.
Post a Comment