Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 23 Jan 2013 17:38:19 +0100Is there a maximal number of arguments for functionshttps://ask.libreoffice.org/en/question/10338/is-there-a-maximal-number-of-arguments-for-functions/I am trying to conduct a simple MEAN function with reference to 75 cells. The problem ist that it only takes reference to the first 30. The 31th and the following are not taken into calculation of the mean.
Does anybody know if there is a maximal number of arguments that the function can take reference to? Wed, 23 Jan 2013 16:07:11 +0100https://ask.libreoffice.org/en/question/10338/is-there-a-maximal-number-of-arguments-for-functions/Answer by horst for <p>I am trying to conduct a simple MEAN function with reference to 75 cells. The problem ist that it only takes reference to the first 30. The 31th and the following are not taken into calculation of the mean.
Does anybody know if there is a maximal number of arguments that the function can take reference to? </p>
https://ask.libreoffice.org/en/question/10338/is-there-a-maximal-number-of-arguments-for-functions/?answer=10343#post-id-10343There is no MEAN function in the standard list. So I am assuming you mean the AVERAGE function.
Most function can take 30 individual arguments or a range (e.g. A1:B500). To find out how many arguments are accepted goto Help-Functions or enter the function wizard (fx left of the input line), select your function and click next, then it shows you the max. number of arguments.
Wed, 23 Jan 2013 17:38:19 +0100https://ask.libreoffice.org/en/question/10338/is-there-a-maximal-number-of-arguments-for-functions/?answer=10343#post-id-10343Answer by JohnSUN for <p>I am trying to conduct a simple MEAN function with reference to 75 cells. The problem ist that it only takes reference to the first 30. The 31th and the following are not taken into calculation of the mean.
Does anybody know if there is a maximal number of arguments that the function can take reference to? </p>
https://ask.libreoffice.org/en/question/10338/is-there-a-maximal-number-of-arguments-for-functions/?answer=10340#post-id-10340Do you mean "user-defined function" (macro) or "native" function of Calc? I have just an experiment - function
=AVERAGE(A1;A2;A3;A4;A5;A6;...<skip some (244) addresses>...;A251;A252;A253;A254)
gives the correct result.
Longer formula (more than 1171 characters) are not placed in the cell.
But I know that any long formula can be written shortly. For example, in this case
=AVERAGE(A1:A254)
Perhaps, your formula can be simplified and written short too?Wed, 23 Jan 2013 16:44:11 +0100https://ask.libreoffice.org/en/question/10338/is-there-a-maximal-number-of-arguments-for-functions/?answer=10340#post-id-10340