> 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. -- Bests, Jon