 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2007Using calculation in a cell like a variable
This seems so basic to me, but I want to take the calculation of a formula in a cell, let's say the result of some financial calculation and then later on I have some text explaining what I did. Something like this: The answer to the question is --the value of cell C1-- That way if any information changes in the formula, you don't have to type it into the text. M, If you want the text and the formula result to appear in the cell, try this. Select the cell. Format - Cells - Number tab - Custom. Whatever is currently in the Type box, add this: "The answer to the question is " (followed by the original format code). E.g.: "The answer to the question is" General "The answer to the question is" 0.00 You can also have text after the formula result: "The answer to the question is" 0.00 "don't you know" The cell will still be considered to contain a number, so you can refer to it in other formulas.  SignatureEarl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- > This seems so basic to me, but I want to take the calculation of a > formula in a cell, let's say the result of some financial calculation [quoted text clipped - 5 lines] > That way if any information changes in the formula, you don't have to > type it into the text. One way: Format/Cells/Number/Custom "The answer to the question is "0.00 You could also use ="The answer to the question is " & TEXT(<calc here>,"0.00") Note, however, that you wouldn't then be easily able to use the result in subsequent formulae. > This seems so basic to me, but I want to take the calculation of a > formula in a cell, let's say the result of some financial calculation [quoted text clipped - 5 lines] > That way if any information changes in the formula, you don't have to > type it into the text. I think both of you are misunderstanding. I want the value of a cell mixed in with text. So if I have a cell that has a formula in it, and the result of that formula is $1250.34. I want to have some text that says, "The answer to the problem is $1250.34" The $1250.34 would not be typed in manually, but rather be the value of the cell that contained the formula. That way if I changed the formula in the cell, the amount in the text would have too. I hope that makes more sense. > One way: > [quoted text clipped - 20 lines] > > That way if any information changes in the formula, you don't have to > > type it into the text. > I think both of you are misunderstanding. I think you should try the suggested solution before you decide that there's a misunderstanding <g>. Sorry, you are correct. Thanks. > In article <1175275838.570165.298...@e65g2000hsc.googlegroups.com>, > > > I think both of you are misunderstanding. > > I think you should try the suggested solution before you decide that > there's a misunderstanding <g>. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.