/

Calc Spreadsheet Err 502 – How to Solve

4380 views
10

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

A 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 that is causing this error.

See some examples below.

Examples

  • If you pass a negative 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 the column, but the column number doesn’t exist in the selected table, you would get Error 502.

Conclusion

Almost all functions can return Error 502 if you pass an 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. Analyze the function

    Analyze 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 the Error 502 problem and unable to solve it? Drop a comment below for help.


Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.


Join our Telegram channel and stay informed on the move.

Related


arindam

Creator of libreofficehelp.com. The aim is to help as many people with easy-to-understand tutorials and no BS. Follow us using social channels or send us an email.

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

10 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Michael Clark

I’m getting a 502 error but only for data from the 14th column and after. All data in columns 1-13 works perfectly. Is there a limit to the number of columns VLOOKUP will handle?

Arindam Giri

There is no limit for number of columns in VLOOKUP. Check your source array and column numbering.

Michael Clark

Ok, someone on another message board I’m on figured it out. Evidently, the “M” refers to the last column looked at by VLOOKUP. As I was trying to pull data from beyond that column, that’s what was causing the error.

I changed “M” to “Z” and the problem is now solved.

Michael Clark

Huh… I honestly don’t see anything “wrong” with it. I’ve literally copy-n-pasted the VLOOKUP argument so I know it’s identical, except for the column from which it’s pulling that cell’s requested data.

Here’s what I’ve got:

=IF(H6=0,"",(VLOOKUP(H6,$'Data Lookup'.A:$'Data Lookup'.M,14,0)))

Everything stating M.13.0 and less (down to M.2.0, since M.1.0 is the initial search criterion) works perfectly. Just 14 and up do not work and return the 502 error.

This spreadsheet has six sheets to it.

The first sheet is a data entry sheet, where I type in the store number (along with first day of that week and team members I’m working with), and it’s broken out to give me five days, and then these are grouped into four groups (i.e. four weeks).

The second, third, fourth, and fifth sheets are weekly result tables which I can print.

The sixth sheet is the Data Lookup sheet, and it’s a massive table of store numbers (first field) and then all the other pertinent data for each of those stores (district, phone number, address, and so on).

Unknow0059

I don’t understand. I’m getting this error.
I have a cell with “00:47:05” in it. It’s in position B5. When I do the function “=TIMEVALUE(B5)” I get error 502, but when I do the function “=TIMEVALUE(“00:47:05″)” I get the converted value.
I cannot seriously be expected not to use a cell within a function in a spreadsheet program. Hell, I have seen such being described here. Something is wrong, and I don’t know what it is.

Christina Mporodimou

Hi, I am trying to apply the command minverse in calc and I get a 502 error. When an error 502 may exist in this specific command?

Igors Mihailovs

I am puzzled by this error in COUNTIFS() function. It is said to accept arbitrary number of argument pairs but in fact accepts only two pairs, as in the tip shown on yellow when typing the formula. Why is it so? Am I missing something?

Thanks for the great article anyway.

Kenneth E. Smith

Why Error # 502 “Invalid argument” ?

This is the formula for cell F9:
=INDEX(category,MATCH(B9,pounds,0),MATCH(E9,bminumber,0))

According to: LibreOffice 7.0 online help,
INDEX(Reference [; Row [; Column [; Range]]])
INDEX only requires Reference which in above formula is category.
MATCH(SearchCriterion; LookupArray [; Type])
SearchCriterion: B9 & E9 , LookupArray: pounds & bminumber, Type: 0 exact match

I have also tried this formula for cell F9:
=IFERROR(INDEX(category,MATCH($B9,pounds,0),MATCH($E9,bmiumber,0)),””)
This formula does not trigger an error, but it also does not return any text from the help table as expected even when there is text in the help cell for that cross reference.

The value of cell B9 is entered by user. The value of E9 is derived by a formula. =ROUNDUP((B9*703)/INT($D$9*$D$9),0)

10
0
Would love your thoughts, please comment.x