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

Internationalization / Localization (German) and Formulas Question
 

maybe you have to use the german words for "if", "and", "match", and
"vlookup"?
susan

On Feb 8, 1:24 pm, "TCook" wrote:
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

Internationalization / Localization (German) and Formulas Question
 

Do you know for sure that these are different when running with regional
settings set for German?

-- Todd



"Susan" wrote in message
ups.com...
maybe you have to use the german words for "if", "and", "match", and
"vlookup"?
susan

On Feb 8, 1:24 pm, "TCook" wrote:
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

Internationalization / Localization (German) and Formulas Question
 

no. it's just something i've seen other people discuss in foreign-
language sub translation issues.
is there a german.excel group you could ask?
search usenet.........
susan


On Feb 8, 3:33 pm, "TCook" wrote:
Do you know for sure that these are different when running with regional
settings set for German?

-- Todd

"Susan" wrote in message

ups.com...



maybe you have to use the german words for "if", "and", "match", and
"vlookup"?
susan

On Feb 8, 1:24 pm, "TCook" wrote:
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- Hide quoted text -

- Show quoted text -

Internationalization / Localization (German) and Formulas Question
 

for instance, see this post:

http://groups.google.com/group/comp....5240b108a116db

i searched google groups for "excel german" & came up with several
different posts, but have not found one specific group (yet).
susan

On Feb 8, 3:33 pm, "TCook" wrote:
Do you know for sure that these are different when running with regional
settings set for German?

-- Todd

"Susan" wrote in message

ups.com...



maybe you have to use the german words for "if", "and", "match", and
"vlookup"?
susan

On Feb 8, 1:24 pm, "TCook" wrote:
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- Hide quoted text -

- Show quoted text -

Internationalization / Localization (German) and Formulas Question
 

aha!

microsoft.public.de.excel


On Feb 8, 3:33 pm, "TCook" wrote:
Do you know for sure that these are different when running with regional
settings set for German?

-- Todd

"Susan" wrote in message

ups.com...



maybe you have to use the german words for "if", "and", "match", and
"vlookup"?
susan

On Feb 8, 1:24 pm, "TCook" wrote:
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- Hide quoted text -

- Show quoted text -

Internationalization / Localization (German) and Formulas Question
 

a quote from a microsoft.public.de.excel post:

"For your problem (assuming you use the english Excel version) try
the
function COUNTIF
=COUNTIF(A1:A9,12)


For the German Excel version try
=ZÄHLENWENN(A1:A9;12) "

susan, shutting up now. :)



On Feb 8, 3:46 pm, "Susan" wrote:
no. it's just something i've seen other people discuss in foreign-
language sub translation issues.
is there a german.excel group you could ask?
search usenet.........
susan

On Feb 8, 3:33 pm, "TCook" wrote:



Do you know for sure that these are different when running with regional
settings set for German?

-- Todd

"Susan" wrote in message

oups.com...

maybe you have to use the german words for "if", "and", "match", and
"vlookup"?
susan

On Feb 8, 1:24 pm, "TCook" wrote:
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Internationalization / Localization (German) and Formulas Question
 

Thanks Susan.

I'll try reposting there.

Best,

Todd


"Susan" wrote in message
oups.com...
aha!

microsoft.public.de.excel


On Feb 8, 3:33 pm, "TCook" wrote:
Do you know for sure that these are different when running with regional
settings set for German?

-- Todd

"Susan" wrote in message

ups.com...



maybe you have to use the german words for "if", "and", "match", and
"vlookup"?
susan

On Feb 8, 1:24 pm, "TCook" wrote:
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- Hide quoted text -

- Show quoted text -

Internationalization / Localization (German) and Formulas Question
 

If Excel didn't understand the formulas because the functions should be in
German, then you would get #Name? errors. Not #N/A or #Value errors.

However, you said you were working on cleaning up the VBA - so does the code
enter these formulas into the worksheet? If so, then they should be written
using english conventions and the Formula property (rather than
FormulaLocal).

Then I would suspect your problems are due to the data being processed.

--
Regards,
Tom Ogilvy




"TCook" wrote in message
...
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