Forum Discussion

Gnd_Teknoloji's avatar
Gnd_Teknoloji
Copper Contributor
Jan 26, 2022

A Translation Mistake on functions

Hello,   I use Office 2016 pro plus, I use in English normally, but for work sake I must use it in Turkish.    Currently, I found translation mistake on two functions.   IMSUM and IMSUB   The...
excel
Stafford Quaid's avatar
Stafford Quaid
Icon for Microsoft rankMicrosoft
Jan 26, 2022

Hi Gnd_Teknoloji 

Thanks for reporting this.

Could you please confirm the Turkish Excel version & build number you are using?

You can find that out by going to File | Account | About Excel

Many thanks!

Staff

Gnd_Teknoloji's avatar
Gnd_Teknoloji
Copper Contributor
Jan 26, 2022
I will when I got to work.

I can tell you the version of Excel in the morning(GMT-3), when I go to work; albeit, I found this is a problem since Excel 2007.

So, this is not a new problem.

Thanks for the reply!
    • JoeUser2004's avatar
      JoeUser2004
      Bronze Contributor
      Jan 26, 2022

      SergeiBaklan  wrote: ``is it correct translation here Translator • Excel-Translator ?``

       

      Good find (the link)!

       

      I think the better comparison is:  IMSUB translates into SANTOPLA.  And according to Google Translate, topla translates into gather; and toplam translates into total.  They do indeed sound more like "sum" than "sub", IMHO.

       

      (I cannot find a reasonable translation for ÇIKAR.  Perhaps Gnd_Teknoloji  can provide a relevant translation.)

       

      I think the point that Gnd_Teknoloji  makes is not that he cannot use SANÇIKAR for IMSUM and SANTOPLA for IMSUB, but that those translations do not make sense to a Turkish speaker any more than COMPLEXE.DIFFERENCE for IMSUM and COMPLEXE.SOMME for IMSUB (purposely backwards) would make sense to a French speaker.  (Fortunately, MSFT got the French translations right.)

       

      .... If an actual Excel file demonstrates that the  Excel Translator  is indeed correct.  (I'm sure it will, given Gnd_Teknoloji's complaint.)

      • Gnd_Teknoloji's avatar
        Gnd_Teknoloji
        Copper Contributor
        Jan 27, 2022
        Hello,

        Yes the translation is makes no sense.

        Basically;

        Çıkar means subtraction, so SANÇIKAR should've sub the numbers.
        Topla means sub, so SANTOPLA should've sub it.

        But...

        SANTOPLA Subtract,
        SANÇIKAR Add/sum the numbers.

        That is the problem I've found.

Resources