|
|
Hi MMS USA
If = Als in Dutch
You can send me the file private and I will test it for you
--
Regards Ron de Bruin
http://www.rondebruin.nl
"MMS USA" <MMS wrote in message
...
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.
|