National language function names

  • Thread starter Thread starter Stefi
  • Start date Start date
S

Stefi

Hi All,

Does an English language Excel2003 recognize a function written in a
national language?

E.g. in a workbook produced by a Hungarian language version contains
=SZORZATÖSSZEG(...), which is =SUMPRODUCT(...)'s equivalent. Shall it be
transformed to =SUMPRODUCT(...) when opened in an English language version?

Thanks,
Stefi
 
Yes. Not the old Analysis Toolpak functions, though.
There may be problems with constants, like FormatStrings in the TEXT
function and R1C1 style addresses in the INDIRECT() function, and probably
more.
With Excel2007 there is another issue with ATP functions; look here:
http://www.rondebruin.nl/atp.htm
 
Thanks Niek, fortunately - for the moment - I need only basic functions!
Stefi


„Niek Otten†ezt írta:
 
Back
Top