Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell in cell formulation possible???
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)? |
#2
|
|||
|
|||
="We may charge you $" & format(A1,"#,##0.00") & " fee if item is not
returned in good condition." HTH, Gary Brown "Abi" wrote: 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)? |
#3
|
|||
|
|||
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 "Abi" wrote in message ... 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)? |
#4
|
|||
|
|||
OOPS!!!
="We may charge you $" & Text(A1,"#,##0.00") & " fee if item is not returned in good condition." "Gary Brown" wrote: ="We may charge you $" & format(A1,"#,##0.00") & " fee if item is not returned in good condition." HTH, Gary Brown "Abi" wrote: 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)? |
#5
|
|||
|
|||
Thank you both - I'm off to give it a try!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) |