### Formula error

Posted:

**Wed Mar 20, 2019 7:52 am**=MAX(INDEX('machine work data'.!$C$2:$C$13>0)*('machine work data'.!$B$2:$B$13='machine work data'.!A2)*('machine work data'.!$A$2:$A$13),,)

Giving Err : 509

Giving Err : 509

User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives

https://forum.openoffice.org/en/forum/

https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=97434

Page **1** of **1**

Posted: **Wed Mar 20, 2019 7:52 am**

=MAX(INDEX('machine work data'.!$C$2:$C$13>0)*('machine work data'.!$B$2:$B$13='machine work data'.!A2)*('machine work data'.!$A$2:$A$13),,)

Giving Err : 509

Giving Err : 509

Posted: **Wed Mar 20, 2019 1:34 pm**

Remove the exclamation mark from machine work data'.!$C$2:$C$13

'machine work data'.$C$2:$C$13 references absolute C2:C12 on sheet 'machine work data'

'machine work data'.$C$2:$C$13 references absolute C2:C12 on sheet 'machine work data'

Posted: **Wed Mar 20, 2019 1:40 pm**

Welcome to the Forums.

This appears to be an Excel formula, or maybe LibreOffice, but not OpenOffice. I can tell that due to the usage of the commas as the parameter separators.

Are you using OpenOffice, as the name in your signature states, or LibreOffice, as the version number in your signature suggests?

In either case your formula is wrong for many reasons.

You appear to be looking for the maximum of some numbers, but the only "number" (can't say for sure as I have no data to work with), comes from the first INDEX.

You have a comparator (the > sign) in the INDEX function... which is, either not allowed (as I suspect), or something I've never seen before.

You also seem to want to do INDEX lookups for the second and third entries used in the first parameter, but you don't have the INDEX functions specified.

Also your INDEX function is missing parameters.

Finally, at this point at least, your MAX function is getting NULL entries from the last two parameters, which are separated by commas, but not specified.

On a side note, in OpenOffice (not sure about LibreOffice), when using a sheet name that contains spaces, that sheet name has to be enclosed in double quotes (") not single (')

If you want further help, please clarify what it is you are trying to do, and attach a sample of your spreadsheet, including some valid, but dummy data.

This appears to be an Excel formula, or maybe LibreOffice, but not OpenOffice. I can tell that due to the usage of the commas as the parameter separators.

Are you using OpenOffice, as the name in your signature states, or LibreOffice, as the version number in your signature suggests?

In either case your formula is wrong for many reasons.

You appear to be looking for the maximum of some numbers, but the only "number" (can't say for sure as I have no data to work with), comes from the first INDEX.

You have a comparator (the > sign) in the INDEX function... which is, either not allowed (as I suspect), or something I've never seen before.

You also seem to want to do INDEX lookups for the second and third entries used in the first parameter, but you don't have the INDEX functions specified.

Also your INDEX function is missing parameters.

Finally, at this point at least, your MAX function is getting NULL entries from the last two parameters, which are separated by commas, but not specified.

On a side note, in OpenOffice (not sure about LibreOffice), when using a sheet name that contains spaces, that sheet name has to be enclosed in double quotes (") not single (')

If you want further help, please clarify what it is you are trying to do, and attach a sample of your spreadsheet, including some valid, but dummy data.