Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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 addresses>...;A248;A249;A250;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?

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 addresses>...;A248;A249;A250;A251;A252;A253;A254)
(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?