**Error Code** |
**Message** |
**Explanation** |

501 |
Invalid character |
Character in a formula is not valid, for example, "=1Eq" instead of "=1E2". |

502 |
Invalid argument |
Function argument is not valid, for example, a negative number for the root function. |

503 |
Invalid floating point operation |
Division by 0, or another calculation that results in an overflow of the defined value range. |

504 |
Parameter list error |
Function parameter is not valid, for example, text instead of a number, or a domain reference instead of cell reference. |

505 |
Internal syntax error |
Not used |

506 |
Invalid semicolon |
Not used |

507 |
Error: Pair missing |
Not used |

508 |
Error: Pair missing |
Missing bracket, for example, closing brackets, but no opening brackets |

509 |
Missing operator |
Operator is missing, for example, "=2(3+4) * ", where the operator between "2" and "(" is missing. |

510 |
Missing variable |
Variable is missing, for example when two operators are together "=1+*2". |

511 |
Missing variable |
Function requires more variables than are provided, for example, AND() and OR(). |

512 |
Formula overflow |
Compiler: the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 512. Interpreter: the total number of matrices that the formula creates exceeds 150. This includes basic functions that receive too large an array as a parameter (max. 0xFFFE, for example, 65534 bytes). |

513 |
String overflow |
Compiler: an identifier in the formula exceeds 64 KB in size. Interpreter: a result of a string operation exceeds 64 KB in size. |

514 |
Internal overflow |
Sort operation attempted on too much numerical data (max. 100000) or a calculation stack overflow. |

515 |
Internal syntax error |
Not used |

516 |
Internal syntax error |
Matrix is expected on the calculation stack, but is not available. |

517 |
Internal syntax error |
Unknown code, for example, a document with a newer function is loaded in an older version that does not contain the function. |

518 |
Internal syntax error |
Variable is not available |

519 |
No result (#VALUE is in the cell rather than Err:519!) |
Formula yields a value that does not corresponds to the definition, or a cell that is referenced in the formula contains text instead of a number. |

520 |
Internal syntax error |
Compiler creates an unknown compiler code. |

521 |
Internal syntax error |
No result. |

522 |
Circular reference |
Formula refers directly or indirectly to itself and the iterations option is not selected under File - Preferences - Productivity Tools - SpreadSheet Editor - Calculate. |

523 |
The calculation procedure does not converge |
Financial statistics function missed a targeted value or iterations of circular references do not reach the minimum change within the maximum steps that are set. |

524 |
invalid references (instead of Err:524 cell contains #REF) |
Compiler: a column or row description name could not be resolved. Interpreter: in a formula, the column, row, or sheet that contains a referenced cell is missing. |

525 |
invalid names (instead of Err:525 cell contains #NAME?) |
An identifier could not be evaluated, for example, no valid reference, no valid domain name, no column/row label, incorrect decimal divider, add-in not found. |

526 |
Internal syntax error |
Obsolete, no longer used, but could come from old documents if the result is a formula from a domain. |

527 |
Internal overflow |
Interpreter: References, such as when a cell references a cell, are too encapsulated. |