Put comment directly in formula
 

I write somewhat complext formulas and I would like to be able to add
comments within a formula to explain what the formula is calculating or why I
use a particular cell in a formula

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

This is frequently used
=A4 + N("this is a comment, where the comment is equal to zero")

N Worksheet_Function
Returns a value converted to a number.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mslsmsls" wrote in message ...
I write somewhat complext formulas and I would like to be able to add
comments within a formula to explain what the formula is calculating or why I
use a particular cell in a formula

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...lic.excel.misc

And to add to David's response:

If you want to comment a formula that creates strings:

=a1 & " owes " & text(b1,"$0.00") & text("a comment here",";;;")

David McRitchie wrote:

This is frequently used
=A4 + N("this is a comment, where the comment is equal to zero")

N Worksheet_Function
Returns a value converted to a number.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mslsmsls" wrote in message ...
I write somewhat complext formulas and I would like to be able to add
comments within a formula to explain what the formula is calculating or why I
use a particular cell in a formula

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson