inline calculations possible?

[bcamp1973]

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?

[Niek Otten]

="If you pay "&TEXT(A1,"$0.00")&" each month,"

etc

--
Kind regards,

Niek Otten

"bcamp1973" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[Gary''s Student]

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

[bcamp1973]

Those work perfectly, thank you!