Comments in a formula

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
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
 
=1+1+N("place comment here")+1+1

but I usually use comments as Kevin has already advised.
 
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,

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

Regards,
Kevin
 
And if it's a comment in a string concatenation:

=A1&" should be paid on: "&TEXT(B1,"mm/dd/yyyy")&TEXT(N("comment here"),"")
 
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
 
Back
Top