Referring to a value in text field in openoffice calc

[Gordon Charrick]

I'm sure I could find the answer somewhere out on the net, but I guess I 
haven't googled with the right terms since I haven't found the answer yet.

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.

-- 
Gordon Charrick
gordonmc at cox.net