Inserting a formula into a text string
I have tried all of your suggestions--Thanks, by the way--but each of them
simply prints the verbiage of the function, not the result.
What could I be doing wrong?
--
Thanks,
Courie
"daddylonglegs" wrote:
Another way is to use
="XYZ company will pay "&DOLLAR(Sheet2!A1)&" of your shipping costs"
"Courie" wrote:
Is there a way to insert a formula or reference a cell on another worksheet
in the middle of a text string.
For example if I wanted to say: XYZ company will pay $___________ of your
shipping costs... Where the blank was a reference from another sheet.
--
Thanks,
Courie
|