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:
>
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
="av
