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”).
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
I was looking for something like that since long time.
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…
Copyright © 2004-2010 Automate Excel | Powered by WordPress | Theme by NeoEase