software

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?

Try this:

=G4amp;quot;*12=quot;amp;(G4*12)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;SLMquot; wrote:

gt; In order to pass a file monitoring on income eligibility, I need to be able
gt; to show the calculations in a paper copy of a spreadsheet, not just the final
gt; amount.
gt;
gt; For example:
gt; If someone makes 3000 a month, the calculation would be =3000*12. It is
gt; calculated using a cell calculation formula (ie. =G4*12
gt; I need it to print 3000*12=36000. Does anyone have any ideas on how/if this
gt; is possible?

If you hold down the ctrl key and press the ~ key (to the left of the 1 key),
you will see all the calculations and you can print them. However, when you
print, you will get the leading equal signs (=).

Suzan

quot;SLMquot; wrote:

gt; In order to pass a file monitoring on income eligibility, I need to be able
gt; to show the calculations in a paper copy of a spreadsheet, not just the final
gt; amount.
gt;
gt; For example:
gt; If someone makes 3000 a month, the calculation would be =3000*12. It is
gt; calculated using a cell calculation formula (ie. =G4*12
gt; I need it to print 3000*12=36000. Does anyone have any ideas on how/if this
gt; is possible?


How about something like this:
in a seperate column
=G4amp;quot;*12=quot;amp;g4*12
then hide the original column when printing

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=497543Yes 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)

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; =G4amp;quot;*12=quot;amp;(G4*12)
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;SLMquot; wrote:
gt;
gt; gt; In order to pass a file monitoring on income eligibility, I need to be able
gt; gt; to show the calculations in a paper copy of a spreadsheet, not just the final
gt; gt; amount.
gt; gt;
gt; gt; For example:
gt; gt; If someone makes 3000 a month, the calculation would be =3000*12. It is
gt; gt; calculated using a cell calculation formula (ie. =G4*12
gt; gt; I need it to print 3000*12=36000. Does anyone have any ideas on how/if this
gt; gt; is possible?

Here are some general rules:

You can join text strings together by using an ampersand: amp;
(it's on the 7 key)

Quotation marks are used to insert text into a formula
Example:
A1: This is
B1: =A1amp;quot; my text.quot;
displays This is my text.

Another example using both rules:
If A1 contains 100 and B1 contains 500 . . .

=SUM(A1:B1)amp;quot; is the totalquot;
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),quot;$#,##0quot;)amp;quot; is the totalquot;
will display the following in the cell:
$600 is the total

Does that get you pointed in the right direction?

***********
Regards,
Ron

XL2002, WinXP-Proquot;SLMquot; wrote:

gt; Yes that does help!
gt; Do you know how I can do the same thing if I am using SUM or just using
gt; numbers (=531.20*12)
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Try this:
gt; gt;
gt; gt; =G4amp;quot;*12=quot;amp;(G4*12)
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;SLMquot; wrote:
gt; gt;
gt; gt; gt; In order to pass a file monitoring on income eligibility, I need to be able
gt; gt; gt; to show the calculations in a paper copy of a spreadsheet, not just the final
gt; gt; gt; amount.
gt; gt; gt;
gt; gt; gt; For example:
gt; gt; gt; If someone makes 3000 a month, the calculation would be =3000*12. It is
gt; gt; gt; calculated using a cell calculation formula (ie. =G4*12
gt; gt; gt; I need it to print 3000*12=36000. Does anyone have any ideas on how/if this
gt; gt; gt; is possible?

Thanks Ron!
You rule!

quot;Ron Coderrequot; wrote:

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