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
|