Adding a Comment to a Formula

To add 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. For

Example:
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")
Screenshot // Adding a Comment to a Formula
Adding a Comment to a Formula

Comments

  1. this only works if the formula evaluates to a value, it will not work if the formula evaluates to #N/A or text etc. hence it is often times not useful for added a comment

  2. "I have set up a hyperlink to a cell in separate worksheet tab within the same file, but I need to populate that cell with some text(4 or 5 alpha character). Does anyone know if I can make this happen?

    Background: There will ultimately be several link(100+), each for a different company, and the text will be a ticker symbol. That ticker symbol will drive numerous lookup functions and produce and score. I want to be able to click on the company name and have the score pop-up automatically rather than having to manually type in the ticker as I do now.
    I don't know if excel will do this..."

  3. "For whatever reason, if I want to add a comment to a string that will be visible only in the formula bar, I insert ""="" at the beginning, enclose the string in quotation marks, and append this to the end of the string:
    &REPT(""Comment goes here"", 0)"

  4. "I have set up a hyperlink to a cell in separate worksheet tab within the same file, but I need to populate that cell with some text(4 or 5 alpha character). Does anyone know if I can make this happen?

    Background: There will ultimately be several link(100+), each for a different company, and the text will be a ticker symbol. That ticker symbol will drive numerous lookup functions and produce and score. I want to be able to click on the company name and have the score pop-up automatically rather than having to manually type in the ticker as I do now.
    I don't know if excel will do this..."

  5. "For whatever reason, if I want to add a comment to a string that will be visible only in the formula bar, I insert ""="" at the beginning, enclose the string in quotation marks, and append this to the end of the string:
    &REPT(""Comment goes here"", 0)"

Leave a Reply to Mike Cancel reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.