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

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

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

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 -

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 -

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 -

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 -

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 -

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