[Libreoffice] append function result to string

[James]

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.
Thanks.
>
> Kind regards
> Regina
> _______________________________________________
> LibreOffice mailing list
> LibreOffice at lists.freedesktop.org
> http://lists.freedesktop.org/mailman/listinfo/libreoffice
>