| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help with Index, Match and Countif in the same complicated formula | Excel Discussion (Misc queries) | |||
Threaded Mode
