What I'd like to do is have a text cell refer to one or more values in another cell. Basically I'd like to have something like below:
|------------------|--------------| | 500 | 0.15 | |------------------|--------------| | Cell a1 is 500 and 15% is 75 | |------------------|--------------|
I don't want the values in separate cells because I want the text to be a fairly long line that refers to several values like the example.
concatenate? That function might well do it for you.
That worked. Just in case anyone else needs to figure it out, to do the example above, just put
concatenate("Cell a1 is ";text(a1;"###");" and ";text(b1;"##%");" is ";text(a1*b1;"###"))
in the cell.
-- Gordon Charrick gordonmc@xxxxxxx
