Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments within formulas
I have a vague memory that it is possible to add comments in the same cell
as a formula. (Not using Comment feature.) Does anyone know how to do that? Rob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments within formulas
If the results are numeric:
=A1+B1+N("this is a comment") If the results are text: =A2&B2&TEXT("this is a comment",";;;") RobN wrote: I have a vague memory that it is possible to add comments in the same cell as a formula. (Not using Comment feature.) Does anyone know how to do that? Rob -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments within formulas
Couple of methods.
=a2*a1+N("my wage+bonus for the month of February") The comments will appear only in the formula bar. If you want it to show in the cell =a2*a1 & " is my wage+bonus for the month of February" Gord Dibben MS Excel MVP On Fri, 29 Feb 2008 11:47:40 +1030, "RobN" wrote: I have a vague memory that it is possible to add comments in the same cell as a formula. (Not using Comment feature.) Does anyone know how to do that? Rob |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments within formulas
Thanks Dave and Gord.
I notice, in this example I created, ==1284.15+520 & " test", that the cell is no longer treated as numeric as it is not included in another SUM function, for instance. The other method works great, but is there a way for the example above to still be treated as numeric? I suspect not. Ps. Gord, I can't help you with the value for a2 in your example, but a1 is, "Thanks for your help!" Rob "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Couple of methods. =a2*a1+N("my wage+bonus for the month of February") The comments will appear only in the formula bar. If you want it to show in the cell =a2*a1 & " is my wage+bonus for the month of February" Gord Dibben MS Excel MVP On Fri, 29 Feb 2008 11:47:40 +1030, "RobN" wrote: I have a vague memory that it is possible to add comments in the same cell as a formula. (Not using Comment feature.) Does anyone know how to do that? Rob |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments within formulas
If you want to keep the value numeric:
=1284.15+520 &n("test") But test won't show up in the cell. You could give the cell a custom format: format|cells|number tab|custom category: 0,000.000 "test" and just use: =1284.15+520 in the cell RobN wrote: Thanks Dave and Gord. I notice, in this example I created, ==1284.15+520 & " test", that the cell is no longer treated as numeric as it is not included in another SUM function, for instance. The other method works great, but is there a way for the example above to still be treated as numeric? I suspect not. Ps. Gord, I can't help you with the value for a2 in your example, but a1 is, "Thanks for your help!" Rob "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Couple of methods. =a2*a1+N("my wage+bonus for the month of February") The comments will appear only in the formula bar. If you want it to show in the cell =a2*a1 & " is my wage+bonus for the month of February" Gord Dibben MS Excel MVP On Fri, 29 Feb 2008 11:47:40 +1030, "RobN" wrote: I have a vague memory that it is possible to add comments in the same cell as a formula. (Not using Comment feature.) Does anyone know how to do that? Rob -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments within formulas
Thanks Dave,
I thought that would be the case, but the other method is still very useful. Rob "Dave Peterson" wrote in message ... If you want to keep the value numeric: =1284.15+520 &n("test") But test won't show up in the cell. You could give the cell a custom format: format|cells|number tab|custom category: 0,000.000 "test" and just use: =1284.15+520 in the cell RobN wrote: Thanks Dave and Gord. I notice, in this example I created, ==1284.15+520 & " test", that the cell is no longer treated as numeric as it is not included in another SUM function, for instance. The other method works great, but is there a way for the example above to still be treated as numeric? I suspect not. Ps. Gord, I can't help you with the value for a2 in your example, but a1 is, "Thanks for your help!" Rob "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Couple of methods. =a2*a1+N("my wage+bonus for the month of February") The comments will appear only in the formula bar. If you want it to show in the cell =a2*a1 & " is my wage+bonus for the month of February" Gord Dibben MS Excel MVP On Fri, 29 Feb 2008 11:47:40 +1030, "RobN" wrote: I have a vague memory that it is possible to add comments in the same cell as a formula. (Not using Comment feature.) Does anyone know how to do that? Rob -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas as comments | Excel Discussion (Misc queries) | |||
Having comments copied when using formulas | Excel Worksheet Functions | |||
in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
formulas in comments in excel | Excel Discussion (Misc queries) |