Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can I put a note in an excel formula
I'd like to put a few notes in my excel formulas to refer to later when I
forgot where I may have gotten a number I used. Something like <=c3*b4*20"the number of work days in May" Is this possible? Basically I'd like to add text in formulas that is ignored by excel |
#2
|
|||
|
|||
Try something like in say, D3:
=C3*B4*20 +N("20 = the number of work days in May") -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "danno1" wrote in message ... I'd like to put a few notes in my excel formulas to refer to later when I forgot where I may have gotten a number I used. Something like <=c3*b4*20"the number of work days in May" Is this possible? Basically I'd like to add text in formulas that is ignored by excel |
#3
|
|||
|
|||
With the cell in question selected, press Shift-F2. This will pop up a
comment box into which you can type your note to yourself. Click outside the note to move on. That note will then appear if you hover the mouse for a second or so over the subject cell "danno1" wrote: I'd like to put a few notes in my excel formulas to refer to later when I forgot where I may have gotten a number I used. Something like <=c3*b4*20"the number of work days in May" Is this possible? Basically I'd like to add text in formulas that is ignored by excel |
#4
|
|||
|
|||
And if you want a comment in a cell that returns text:
=a1&" "&text(b1,"$0.00") & text("this is a comment",";;;") danno1 wrote: I'd like to put a few notes in my excel formulas to refer to later when I forgot where I may have gotten a number I used. Something like <=c3*b4*20"the number of work days in May" Is this possible? Basically I'd like to add text in formulas that is ignored by excel -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Updating rows - Excel Formula or Something Else? | Excel Worksheet Functions | |||
Formula in an Excel comment | Excel Discussion (Misc queries) | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions |