cell in cell formulation possible???

A

Abi

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)?
 
G

Gary Brown

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

HTH,
Gary Brown
 
C

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
 
G

Gary Brown

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