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