can put comment in formula line?

I

Ian Elliott

Thanks for any help.
I was wondering if I could put a comment in the same line as a formula.
Something like:
=41500+32000 'this is reserve plus commission
or
=41500+3200 !this is reserve plus commission
or whatever the comment character is, if there is one.
Thanks.
 
J

Jim Rech

You can do something like this:

=123+456+N("this is a comment")

--
Jim
| Thanks for any help.
| I was wondering if I could put a comment in the same line as a formula.
| Something like:
| =41500+32000 'this is reserve plus commission
| or
| =41500+3200 !this is reserve plus commission
| or whatever the comment character is, if there is one.
| Thanks.
|
 
D

Dave Peterson

And if you wanted to include a comment in a formula that returned text:

="Due date is: " & text(a1,"mm/dd/yyyy") &text("another comment here",";;;")

Just in case you ever need it <bg>.
 
Top