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
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.
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
"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..."
"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)"
"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..."
"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)"