[Libreoffice] append function result to string
bjlockie at lockie.ca
Tue Jan 4 15:40:59 PST 2011
On 01/04/11 13:53, Regina Henschel wrote:
> 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
> LibreOffice mailing list
> LibreOffice at lists.freedesktop.org
More information about the LibreOffice