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
_______________________________________________
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice
