[Libreoffice] append function result to string

[Regina Henschel]

Hi James,

James schrieb:
> I want to prepend the result of the AVERAGE function with the string
> 'average '.

Where did you try this? AVERAGE and Concat are Calc functions and CStr 
is a BASIC function. You cannot mix that.

> I tried this:
> =concat('average ',cstr(AVERAGE(C3:C200)))

In Calc
="average " & AVERAGE(C3:C200)

Du not use a pair of single quotes for text literals in Calc, because 
they are used for labels.

Kind regards
Regina