For your case, VLOOKUP expects entire table range and. I have tried the help feature in Apache Open Office, and I have tried Googling the problem, but I don't understand the solutions being offered. Error 502 occurs when you are passing incorrect/insufficient arguments to a function which it deserves.

The second situation involves my Vanguard Emerging Markets Stock Index Fund Admiral Shares.Īmount Date Quarter YTD 1-Year 3-Year 5-Year (If I had it to do over again, I would have retained the old worksheet and just inserted a comment to indicate the conversion.) I'm thinking this problem stems from the fact that my XIRR calculation is only for a four day period, but I'm not sure.Īmount Date Quarter YTD 1-Year 3-Year 5-Year

On, I converted my Investor shares to Admiral shares and began a new worksheet for the latter fund. We do not know the systematic and the random measurement error for these. The first situations is for my Vanguard Small-Cap Value Index Fund Admiral Shares.

This kind of error will appear as an annoying notification on your screen unless handled and corrected. It doesn't necessarily mean that the code was corrupt in some way, but just that it did not work during its run-time. I have never understood how to format tables on this forum.) Runtime Code 502 happens when OpenOfficefails or crashes whilst it's running, hence its name. How do I resolve an Err:502 in a spreadsheet XIRR calculation? This problem comes up in the following two situations.

Err 502 openoffice