D
Debutante
ExcelXP
Is it possible to add a footnote to a cell that includes a formula?
Thank you.
Is it possible to add a footnote to a cell that includes a formula?
Thank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
RagDyer
If by "footnote" you mean "Comment", YES!
<Insert> <Comment>
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
ExcelXP
Is it possible to add a footnote to a cell that includes a formula?
Thank you.
<Insert> <Comment>
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
ExcelXP
Is it possible to add a footnote to a cell that includes a formula?
Thank you.
G
Gord Dibben
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
=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
D
Dave Peterson
And if your formula is text and you want a "comment":
=a1&text(b1,"mm/dd/yyyy")&text("this is a comment",";;;")
=a1&text(b1,"mm/dd/yyyy")&text("this is a comment",";;;")