Prev: Aligning decimals in Excel ...
Next: Using fuzzy logic in excel
From: Debutante on 15 Feb 2005 13:51
ExcelXP

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

Thank you.


From: RagDyer on 15 Feb 2005 14:53
If by "footnote" you mean "Comment", YES!
<Insert> <Comment>
--

HTH,

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

"Debutante" <akdjakls(a)jdakfldj.com> wrote in message
news:uUapn94EFHA.628(a)TK2MSFTNGP15.phx.gbl...
ExcelXP

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

Thank you.


From: Gord Dibben on 15 Feb 2005 18:27
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" <ragdyer(a)cutoutmsn.com> wrote:

>If by "footnote" you mean "Comment", YES!
><Insert> <Comment>
>--
>
>HTH,
>
>RD
>==============================================
>Please keep all correspondence within the Group, so all may benefit!
>==============================================
>
>"Debutante" <akdjakls(a)jdakfldj.com> wrote in message
>news:uUapn94EFHA.628(a)TK2MSFTNGP15.phx.gbl...
>ExcelXP
>
>Is it possible to add a footnote to a cell that includes a formula?
>
>Thank you.

From: Dave Peterson on 15 Feb 2005 21:02
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" <ragdyer(a)cutoutmsn.com> wrote:
>
> >If by "footnote" you mean "Comment", YES!
> ><Insert> <Comment>
> >--
> >
> >HTH,
> >
> >RD
> >==============================================
> >Please keep all correspondence within the Group, so all may benefit!
> >==============================================
> >
> >"Debutante" <akdjakls(a)jdakfldj.com> wrote in message
> >news:uUapn94EFHA.628(a)TK2MSFTNGP15.phx.gbl...
> >ExcelXP
> >
> >Is it possible to add a footnote to a cell that includes a formula?
> >
> >Thank you.

--

Dave Peterson
 | 
Pages: 1
Prev: Aligning decimals in Excel ...
Next: Using fuzzy logic in excel