| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inline calculations possible?
If i have a string of text within a cell, is there a way to place either values or calulations within that string? For example i'd like to put the following line at the top of a mortgage payment sheet i'm working on... If you pay $[monthly payment] each month, the loan will be paid off in [balance/12] years... Obviously that's simplified and doesn't take interest into account, but i hope it illustrates my purpose? -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=520717 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
inline calculations possible?
="If you pay "&TEXT(A1,"$0.00")&" each month,"
etc -- Kind regards, Niek Otten "bcamp1973" wrote in message ... If i have a string of text within a cell, is there a way to place either values or calulations within that string? For example i'd like to put the following line at the top of a mortgage payment sheet i'm working on... If you pay $[monthly payment] each month, the loan will be paid off in [balance/12] years... Obviously that's simplified and doesn't take interest into account, but i hope it illustrates my purpose? -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=520717 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
inline calculations possible?
How about:
="there are only "&DATEDIF(TODAY(),DATE(2006,12,25),"d")&" Left to Christmas" another option is to use a custom format. This will display text but allow the value to be used in other calculations -- Gary''s Student "bcamp1973" wrote: If i have a string of text within a cell, is there a way to place either values or calulations within that string? For example i'd like to put the following line at the top of a mortgage payment sheet i'm working on... If you pay $[monthly payment] each month, the loan will be paid off in [balance/12] years... Obviously that's simplified and doesn't take interest into account, but i hope it illustrates my purpose? -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=520717 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
inline calculations possible?
Those work perfectly, thank you! -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=520717 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculations based on PivotTable information | Excel Discussion (Misc queries) | |||
| looping through a set of calculations | Excel Worksheet Functions | |||
| Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
| How do I set up a standard form showing incentive calculations | Excel Discussion (Misc queries) | |||
| time interval calculations in excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
