This is how you can fix the Calc spreadsheet error 502.

If you are an avid user of spreadsheet programs such as Excel, Calc in OpenOffice or LibreOffice, you might have encountered the Err:502 while performing calculations using functions. Here’s how you can fix it.

What is Err 502

As the Calc manual says – it occurs when – “A function argument has an invalid value or invalid function argument”. It can happen to any function if you are passing invalid arguments which it was not supposed to receive.

How to fix Err 502

Typical way to fix this error is – check each and every function and its parameters which you are passing. Likely you are providing some incorrect argument which is causing this error.

SEE ALSO:  Date and Time Formats in LibreOffice Calc

See some examples below.


  • If you pass a nagative number to SQRT (square root) function – Error 502 would be thrown by Calc. Because it expects a positive number and you are passing a negative.

  • If you are using VLOOKUP and trying to return some value from column, but the column number doesn’t exists in the selected table, you would get Error 502.


Almost all function can return Error 502 if you pass invalid argument. Carefully checking your spreadsheet to find out about the error assessing the arguments is the recommended way to solve this problem.


Are you facing Error 502 problem and unable to solve? Drop a comment below for help.

For the latest tutorials, news and how-to guides, follow on Twitter, Facebook, and subscribe to our YouTube channel and email updates via below form.

Join 520 other subscribers.