Referring to a value in text field in openoffice calc

[Jon Savage]

> 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