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



4 thoughts on “Adding a Comment to a Formula

  1. “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)”

  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…”

Leave a Reply

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


nine − = 3

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>