How do I print formula figures and calculated amount in a cell?
 

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?

How do I print formula figures and calculated amount in a cell?
 

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?

How do I print formula figures and calculated amount in a cell?
 

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

"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?

How do I print formula figures and calculated amount in a cell?
 

How about something like this:
in a seperate column
=G4&"*12="&g4*12
then hide the original column when printing

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=497543

How do I print formula figures and calculated amount in a cell
 

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?

How do I print formula figures and calculated amount in a cell
 

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?

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?