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
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.
      • JoeUser2004's avatar
        JoeUser2004
        Bronze Contributor
        Jan 27, 2022

        Gnd_Teknoloji  wrote: ``Yes the translation is makes no sense.``

         

        Use the Feedback feature in Excel to report the error to MSFT.  This is a peer-to-peer forum.  As far as I know, MSFT employees do not monitor it.

         

        However, I doubt that MSFT can fix it, due to backward compatibility issues.

         

        So you will just have to make the adjustment, using SANÇIKAR when you intend IMSUM, and SANTOPLA when you intend IMSUB.

         

        -----

         

        The real question is:  when you write IMSUM and IMSUB in English, then open the file in Turkish, do you see SANÇIKAR for IMSUM and SANTOPLA for IMSUB?

         

        (You should, given the wrong translations.)

         

        Open the Excel file that I attached to an earlier response.

         

        Do you see SANÇIKAR in A3, and is the result 6+8i ?

         

        And do you see SANTOPLA in A4, and is the result -2-2i ?

         

         

Resources