Text in a Formula

J

James Hamilton

Hi,

I once knew how to add text to a formula, which I'd use to explain the
formula rather than using cell comments.

I can't for the life of me remember how to do this.

Any help would be greatly appreciated.


James
 
R

Roger Govier

Hi James

Try
=Sum(A1:A100)+N("This adds the total Gross Amount")

Change to suit.

Regards

Roger Govier
 
P

Paul B

James, use something like this, ="This is the sum of A1 + B1 " & A1+B1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top