You'll get nowhere with spreadsheets unless you are willing to learn and put some time into understanding them. This is a forum peopled by volunteers - nothing official. Try to remember that this isn't tech support. Not try to point me in the right direction when I have no clue to start with on how this works, and I'm not interested in learning either. It doesn't work for OO.o, and I'm asking someone to figure out how its supposed to be so that it does work. So, telling me "it works" if you put it into some test sheet instead of looking at the huge book I've linked to that has several sheets and is doing these lookups across sheets using a special "Matrix" sheet and stuff. So, obviously something is different between the two. Sometimes you'll get a #NAME error also when you don't have the proper Add-Ins. I have never understood how to format tables on this forum.) The first situations is for my Vanguard Small-Cap Value Index Fund Admiral Shares. You only get the #REF! error when you don't have the Add-Ins installed. How do I resolve an Err:502 in a spreadsheet XIRR calculation This problem comes up in the following two situations. It does work in Excel 2k3 and 2k7 as advertised when you go to Tools->Add-Ins and check all the ones needed for this. I'll reiterate: I didn't author these sheets.
0 Comments
Leave a Reply. |