Text and Formula in one cell
If the cell returns a number:
=a1+a2 +N("this is a comment describing the function")
if the cell returns text:
=a1&": "&text(a2,"mm/dd/yyyy") & text("this is a comment",";;;")
Tracy wrote:
I have a spreadsheet that has a cell with the answer to a formula, I would
like to add some text to this cell explaining what the answer is??
Does anyone have any ideas, I've tried changing the format to text and
simply just typing it but have had no success??
HELP?
--
Dave Peterson
|