Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've recently upgraded from the previous USA Office XP 2002 to USA Office XP
2003. In office XP 2002 I was able to use our company's excel file that comes from Holland. All the equations in the excel file are written in Dutch. Here's an example: =IF(+G21<"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+ 0.49,1),IF(+G21<1000,AFRONDEN.N.VEELVOUD(+G21+2.49 ,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10 ),IF(+G21<20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25) ,AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),"") Now, in Office XP 2003 the contents of this equation produces #NAME?. I can't seem to find any type of language setting or addon package that corrects this. Nor can I seem to find out what language changes have been made between the two versions. I've had multiple different installations of XP 2002 on different computers all able to "translate" these equations so that tells me it wasn't unique to just 1 install. How do I get XP 2003 to recognize these equations? Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I read Pocket Excel files from Excel | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Is there a converter to read Quattro pro files on Excel 2002? | Excel Worksheet Functions |