![]() ![]() 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. You only get the #REF! error when you don't have the Add-Ins installed. 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. 5+B402ABS((B40-D40)(-2)))) -> Returns in 'Err:502' So what I want is if D40 is empty, write nothing, otherwise IF B40 and D40 are the same make 5+2B40 and if. I'll reiterate: I didn't author these sheets. OpenOffice 4.1 on Windows 10 and Linux Mint If your question is answered, please go to your first post, select the Edit button, and add Solved to the beginning of the title. ![]()
0 Comments
Leave a Reply. |