First time here? Check out the FAQ!

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?

2 | No.2 Revision |

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?

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.