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”).
3 Responses
Leave a Comment
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”).
October 15th, 2008 at 3:07 am
And if you’re returning text:
=”some text”&text(”comment here”,”;;;”)
October 15th, 2008 at 5:49 am
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
October 15th, 2008 at 6:45 am
Great !!
I was looking for something like that since long time.
Thanks