How do I print formula figures and calculated amount in a cell
Thanks Ron!
You rule!
"Ron Coderre" wrote:
Here are some general rules:
You can join text strings together by using an ampersand: &
(it's on the 7 key)
Quotation marks are used to insert text into a formula
Example:
A1: This is
B1: =A1&" my text."
displays This is my text.
Another example using both rules:
If A1 contains 100 and B1 contains 500 . . .
=SUM(A1:B1)&" is the total"
will display the following in the cell:
600 is the total
If you need the number formatted, use the TEXT function.
Continuing with the same example....
=TEXT(SUM(A1:B1),"$#,##0")&" is the total"
will display the following in the cell:
$600 is the total
Does that get you pointed in the right direction?
***********
Regards,
Ron
XL2002, WinXP-Pro
"SLM" wrote:
Yes that does help!
Do you know how I can do the same thing if I am using SUM or just using
numbers (=531.20*12)
"Ron Coderre" wrote:
Try this:
=G4&"*12="&(G4*12)
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"SLM" wrote:
In order to pass a file monitoring on income eligibility, I need to be able
to show the calculations in a paper copy of a spreadsheet, not just the final
amount.
For example:
If someone makes 3000 a month, the calculation would be =3000*12. It is
calculated using a cell calculation formula (ie. =G4*12
I need it to print 3000*12=36000. Does anyone have any ideas on how/if this
is possible?
|