Re: [libreoffice-users] Function acting on range

Two separate issues.
A_ The curly brackets are not to be introduced manually. They are only
a sign that the formula is not "normal" (as introduced by pressing
[ENTER]) but instead is an array formula, introduced by simultaneously
pressing [CTRL]+[SHIFT]+[ENTER] (CSE). Search the wiki or the web for
info.

B_ Not every function will accept 3D arguments (i.e. ranges from
different worksheets), even when using array formulas. You can use
ABS() as an array formula, but within the same worksheet. Currently,
ABS() does not accept 3D arguments, IIUC. I could be wrong.

So, you would have to use ABS() in each sheet (as normal or as CSE),
and then you can use AVERAGE() as a 3D formula, whether with [ENTER]
alone or with CSE, depending on the specific case.

Regards,
Ady.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy