=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.