How to include text (comment) in numeric formula?
 

How can I include text (intended to be a comment) in a numeric
formula?

Effectively, I would like to write something like the following:

=A1 - A2 # this is the comment

My goal is for the comment to be visible only when I look at the cell,
but the cell retains its numeric quality. That is, in the example
above, the cell evaluates to A1 minus A2, and other numeric formulas
can refer to it straight-forwardly.

I know that I can do "insert comment", but that is not what I want.

I know I can do the following:

=A1 - A2 + N("this is the comment")

But I thought there is a more straight-forward way to do it.

How to include text (comment) in numeric formula?
 

hi
not sure but try this
=A1 - A2 & " this is the comment"

the ampersand acts as a concatinator for the text.

Regards
FSt1

" wrote:

How can I include text (intended to be a comment) in a numeric
formula?

Effectively, I would like to write something like the following:

=A1 - A2 # this is the comment

My goal is for the comment to be visible only when I look at the cell,
but the cell retains its numeric quality. That is, in the example
above, the cell evaluates to A1 minus A2, and other numeric formulas
can refer to it straight-forwardly.

I know that I can do "insert comment", but that is not what I want.

I know I can do the following:

=A1 - A2 + N("this is the comment")

But I thought there is a more straight-forward way to do it.

How to include text (comment) in numeric formula?
 

On Sep 30, 9:16*am, FSt1 wrote:
not sure but try this
=A1 - A2 *& *" this is the comment"

First, that makes the comment always visible in the cell, not "only
when I look at the cell" (i.e. the cell is selected). The cell does
not (simply) "evaluate to A1 minus A2".

Second, that changes the type of the cell to text, not "retains its
numeric quality", and "other numeric formulas can[not] refer to it
straight-forwardly". For example, =A3-1 results in a #VALUE! error,
if A3 has the formula you suggest.

How to include text (comment) in numeric formula?
 

Hi

There is no other method AFAIK apart from the 2 methods you already know.

--
Regards
Roger Govier

wrote in message
...
How can I include text (intended to be a comment) in a numeric
formula?

Effectively, I would like to write something like the following:

=A1 - A2 # this is the comment

My goal is for the comment to be visible only when I look at the cell,
but the cell retains its numeric quality. That is, in the example
above, the cell evaluates to A1 minus A2, and other numeric formulas
can refer to it straight-forwardly.

I know that I can do "insert comment", but that is not what I want.

I know I can do the following:

=A1 - A2 + N("this is the comment")

But I thought there is a more straight-forward way to do it.

How to include text (comment) in numeric formula?
 

On Sep 30, 10:15*am, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:
There is no other method AFAIK apart from the 2 methods
you already know.

Okay. Thanks for the confirmation.

How to include text (comment) in numeric formula?
 

You have another option.

Use the Data Validation "Input Message".

Does *not* mark the cell, and displays *only* when the cell is selected.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
...
On Sep 30, 10:15 am, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:
There is no other method AFAIK apart from the 2 methods
you already know.

Okay. Thanks for the confirmation.

How to include text (comment) in numeric formula?
 

=A1 - A2 & " this is the comment"


Hi. One common method is the following, as N just returns 0.

=A2-A1 + N("Some Text")

--
HTH :)
Dana DeLouis


wrote in message ...
On Sep 30, 9:16 am, FSt1 wrote:

not sure but try this
=A1 - A2 & " this is the comment"


First, that makes the comment always visible in the cell, not "only
when I look at the cell" (i.e. the cell is selected). The cell does
not (simply) "evaluate to A1 minus A2".

Second, that changes the type of the cell to text, not "retains its
numeric quality", and "other numeric formulas can[not] refer to it
straight-forwardly". For example, =A3-1 results in a #VALUE! error,
if A3 has the formula you suggest.