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 |
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 |
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 |
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 . |
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 |
All times are GMT +1. The time now is 08:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com