Ask Your Question
0

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

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

this post is marked as community wiki

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 flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 20:55:21.287559

2 Answers

Sort by » oldest newest most voted
0

answered 2013-01-23 17:38:19 +0200

horst gravatar image

updated 2013-01-23 17:39:08 +0200

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.

edit flag offensive delete link more
1

answered 2013-01-23 16:44:11 +0200

JohnSUN gravatar image

updated 2013-01-23 16:47:02 +0200

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?

edit flag offensive delete link more

Question Tools

Stats

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

Seen: 180 times

Last updated: Jan 23 '13