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

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

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

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