Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Internationalization / Localization (German) and Formulas Question
Hey All,
I've been given the task of trying to localize a large, disorganized VBA solution. I was wondering if any of you might know why formulas like the following might give me errors: =IF(AND('A01'!U76=3,'A01'!U76<=1000),1,"") =IF(DM31="","",MATCH(DM31,$AB$202:$AB$450,0)) =IF(AB205="","",VLOOKUP(AD205,$CE$4:$CF$20,2,0)) I am getting lots of #N/A and #VALUE errors. The solution runs fine in English. Could there be number formatting issues that I also need to be aware of? Any advice or experience offered would be appreciated. Regards, TC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formulas change outcome on a German computer? | Excel Discussion (Misc queries) | |||
this formulas is in English ... what is it in German? | Excel Discussion (Misc queries) | |||
German translation for english formulas | Excel Discussion (Misc queries) | |||
C# .NET Excel development and Internationalization | Excel Programming | |||
Problem with COM Addin in German OS and German Office. | Excel Programming |