Ask Your Question

# Is there a maximal number of arguments for functions [closed]

asked 2013-01-23 16:07:11 +0100

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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?

edit retag reopen merge delete

## 2 Answers

Sort by » oldest newest most voted

There 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.

more

Do 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?

more

## Stats

Asked: 2013-01-23 16:07:11 +0100

Seen: 220 times

Last updated: Jan 23 '13