Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. | |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions |