How to Add a Comment to a Formula
A simple way to add a comment to a formula for later reference is to add the following to the formula N+(“YOUR COMMENT”). By way of an example, =SUM(A2:A4)+N(“This is”).
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Get answers right away at our AE Excel Support Forums!
And if you’re returning text:
=”some text”&text(“comment here”,”;;;”)
This only works provided you put text in the N() function
If the N() Function evaluates to a numeral as in =10*10+N(10*10)
it returns 200 as it should,
as the N function returns a number
=10*10+N(“10*10″) returns 100
Better and safer to use Cell Comments
Great !!
I was looking for something like that since long time.
Thanks
N function is a great way to add general notes to formulas. I mean by general not a description on each argument.
On the other hand, an Excel Named Range is an intrinsic way to add descriptions to formulas and is done on each argument. Read: http://www.excel-spreadsheet-authors.com/excel-names-reasons.html
it doesn’t work.
This works Kerol… i have tried this on 2003 and also on 2007…