cell in cell formulation possible???

[Guest]

Let's say I have a string of text in a cell, something like:

"We may charge you $XXX fee if item is not returned in good condition."

Is it possible to make that XXX a formula/calculation (based upon
information entered in another cell)?

 

[Guest]

="We may charge you $" & format(A1,"#,##0.00") & " fee if item is not
returned in good condition."

HTH,
Gary Brown

 

[Chip Pearson]

Abi,

Try something like

="We may change you " & TEXT(A1,"$#,##0") & " if the item is not
returned."

where cell A1 contains the value you want to display.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

OOPS!!!
="We may charge you $" & Text(A1,"#,##0.00") & " fee if item is not
returned in good condition."

 

[Guest]

Thank you both - I'm off to give it a try!