Comments in a formula

[Mark]

How do I place a comment inside of a formula, so that
Excel will ignore the commment in it's calculation, and
won't give an error message? Thanks!!

Example:
=1+1(place comment here)+1+1

=4

 

[Kevin Stecyk]

Mark,

You can't place a comment inside a formula.

But what you can do is copy your formula to a cell comment, and in the
comment, you can do whatever you want. To insert a comment, it is just
Insert | Comment.

So you can accomplish your goal of explaining your formula for a specific
cell.

Regards,
Kevin

 

[Ken Wright]

=1+1+N("place comment here")+1+1

but I usually use comments as Kevin has already advised.

 

[jaf]

Hi Mark,
=1+1 & " comment " & 1+1
Displays: 2 comment 2
Although I don't see a way to get a value of 4, if that is what your trying
to do.

 

[Ken Wright]

John, take a look at my reply for a way of doing that.

 

[Kevin Stecyk]

Ken,

Thank you for the correction. I have never seen comments inside a formula.

Regards,
Kevin

 

[Ken Wright]

I seem to remember doing a similar thing in Lotus as well - Not sure now.

 

[jaf]

Hi Ken,
OK. I thought he wanted the comment visible in the cell, not the formula
bar.

 

[Dave Peterson]

And if it's a comment in a string concatenation:

=A1&" should be paid on: "&TEXT(B1,"mm/dd/yyyy")&TEXT(N("comment here"),"")

 

[Gord Dibben]

Mark

You can place a comment inside a formula in this manner....

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

Note: the use of the "N" allows the formula to work properly. You will see
the comment in the formula bar but only the results in the cell.

Gord Dibben XL2002