can put comment in formula line?
 

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.

can put comment in formula line?
 

You can do something like this:

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

--
Jim
"Ian Elliott" wrote in message
...
| 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.
|

can put comment in formula line?
 

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.

Ian Elliott wrote:

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.

--

Dave Peterson