Calc Spreadsheet Err 502 – How to Solve

By | September 6, 2019

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 some examples below.

Examples

  • 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.
Error-502-VLOOKUP
Error-502-VLOOKUP

  • 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.
SEE ALSO:  SUMIF and SUMIFS Function with Examples in LibreOffice Calc

Conclusion

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.

Summary

Time needed: 5 minutes.

How to fix Error 502 in Calc

  1. Select the Cell in Calc which contains the Err 502

    Select the cell

  2. Analyse the function

    Analyse the argument of the functions or functions (in case of nested formula) and change the arguments.

  3. Run your formula

    Recalculate Calc formula to eliminate Err 502.

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 libreofficehelp.com on Twitter, Facebook, and subscribe to our YouTube channel and email updates via below form.

Join 565 other subscribers.