ExcelXP

Is it possible to add a footnote to a cell that includes a formula?

Thank you.

If by "footnote" you mean "Comment", YES!
<Insert <Comment
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Debutante" wrote in message
...
ExcelXP

Is it possible to add a footnote to a cell that includes a formula?

Thank you.

And if you don't want a coment, but a footnote in the formula bar.

=a2*a1+n("my wage+bonus-4 weekly loan repayments")

The footnote won't be seen in the cell, but will appear in the formula bar.


Gord Dibben Excel MVP


On Tue, 15 Feb 2005 11:53:14 -0800, "RagDyer" wrote:

If by "footnote" you mean "Comment", YES!
<Insert <Comment
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Debutante" wrote in message
...
ExcelXP

Is it possible to add a footnote to a cell that includes a formula?

Thank you.

And if your formula is text and you want a "comment":

=a1&text(b1,"mm/dd/yyyy")&text("this is a comment",";;;")



Gord Dibben wrote:

And if you don't want a coment, but a footnote in the formula bar.

=a2*a1+n("my wage+bonus-4 weekly loan repayments")

The footnote won't be seen in the cell, but will appear in the formula bar.

Gord Dibben Excel MVP

On Tue, 15 Feb 2005 11:53:14 -0800, "RagDyer" wrote:

If by "footnote" you mean "Comment", YES!
<Insert <Comment
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Debutante" wrote in message
...
ExcelXP

Is it possible to add a footnote to a cell that includes a formula?

Thank you.

--

Dave Peterson