| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding a comment to a formula-not a cell
I just went brain dead and can't remember the keystroke to
add a comment to a formula, not the cell. Please help! TIA |
|
#2
|
|||
|
|||
|
Do you mean
=formula+N("This is a comment") Regards, Peo Sjoblom "Floridagal" wrote: I just went brain dead and can't remember the keystroke to add a comment to a formula, not the cell. Please help! TIA |
|
#3
|
|||
|
|||
|
Use the N
=a2*a1+N("my wage+bonus-4 weekly loan repayments") Gord Dibben Excel MVP On Wed, 5 Jan 2005 11:34:34 -0800, "Floridagal" wrote: I just went brain dead and can't remember the keystroke to add a comment to a formula, not the cell. Please help! TIA |
|
#4
|
|||
|
|||
|
Yes! Thanks!
-----Original Message----- Do you mean =formula+N("This is a comment") Regards, Peo Sjoblom "Floridagal" wrote: I just went brain dead and can't remember the keystroke to add a comment to a formula, not the cell. Please help! TIA . |
|
#5
|
|||
|
|||
|
And if you're working with text:
=A1&B1&"hi there"&TEXT("this is a comment",";;;") Floridagal wrote: I just went brain dead and can't remember the keystroke to add a comment to a formula, not the cell. Please help! TIA -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Re What is the formula for adding multiple numbers in a cell | Excel Discussion (Misc queries) | |||
| What is the formula for adding mulitple numbers in one excel cell. | Excel Discussion (Misc queries) | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| Is there a way to transfer a style by cell referrence in a formula | Excel Discussion (Misc queries) | |||
Linear Mode
