• State Suggested Answer
  • Replies 16 replies
  • Answers 2 answers
  • Subscribers 436 subscribers
  • Views 240 views
  • Users 0 members are here
Options
Related

Translation of texts contained in Excel formulae

Yulia Kovalskaya

Dear Community!

I need help with the settings of an excel containing the following formulae:

Excel screenshot showing a formula bar with a nested IF statement and cells with '#VALUE!' errors in columns 'Probabilidad' and 'Impacto en Talgo'.

I have translated the texts in Columns "Probabilidad" and "Impacto en Talgo", replacing them with "High " and "Very high", however, as you can see, the referenced values in the two Columns on the right show an error.

Above, you can see the formula, containing the same parameters (high, low, etc.).They are not translated and this is what causes the errors.

Any idea on how to make this embedded content visible in Trados and avoid the error? Seems like it is impossible to do it manually. 

Thanks in advance!
emoji
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • 0

      

    I don’t think you can extract Excel formulas in Trados. So you can only prepare better the spread-sheet.

    Are cells in columns H and I picked from a list somewhere else? If so, you can edit the formula to pick those values. For example, if the list of values shown in column H is in a separate sheet called Values, and in the range A2:A7, you’ll need to replace:

    H14="5 (Muy Alto)"

    with:

    H14=Values!A$2

    in the formula of cell J14. You'll need to edit the remaining IF and a similar thing in the cell above. At the end of the replacements, you won’t have strings inside the SI functions and it should work. If you only have to edit a couple of cells, this edition is feasible, otherwise, it can be a real pain to prepare...

    Good luck!
    emoji
  • 0 in reply to Jesús Prieto

    Thank you,   and  :

    let me be more specific. 

    Screenshots 1 and 2 (before): original document. The selected cell IS extracted by Trados as text and can be translated:

    Screenshot of a spreadsheet with cells showing text in Spanish, no visible errors.

    However, in the next column there is a numerical value (calculation result). The formula is:

    Spreadsheet with a formula bar displaying a complex formula in Spanish, no errors visible.

    Screenshots 3 and 4 (after): Once translated (columns H and I), the resuls in column J and K show errors:

    Spreadsheet after translation showing '#VALUE!' errors in columns J and K for 'Expectation priority'.

    Columns H and I were translated in Trados.

    Spreadsheet with formula bar in English showing '#VALUE!' errors in cells and a note 'Establish action!' in column K.

    And this is the result after the replacement of the texts in the formula manually (with Search and Replace function)

    So,  , I did not understand, what should be replaced with the combinations you mentioned in your answer...but I hope that the issue is clearer now , with these screenshots.

    Many, many thanks in advance!
    emoji


    Generated Image Alt-Text
    [edited by: RWS Community AI at 8:26 AM (GMT 0) on 27 Feb 2025]
Reply
  • 0 in reply to Jesús Prieto

    Thank you,   and  :

    let me be more specific. 

    Screenshots 1 and 2 (before): original document. The selected cell IS extracted by Trados as text and can be translated:

    Screenshot of a spreadsheet with cells showing text in Spanish, no visible errors.

    However, in the next column there is a numerical value (calculation result). The formula is:

    Spreadsheet with a formula bar displaying a complex formula in Spanish, no errors visible.

    Screenshots 3 and 4 (after): Once translated (columns H and I), the resuls in column J and K show errors:

    Spreadsheet after translation showing '#VALUE!' errors in columns J and K for 'Expectation priority'.

    Columns H and I were translated in Trados.

    Spreadsheet with formula bar in English showing '#VALUE!' errors in cells and a note 'Establish action!' in column K.

    And this is the result after the replacement of the texts in the formula manually (with Search and Replace function)

    So,  , I did not understand, what should be replaced with the combinations you mentioned in your answer...but I hope that the issue is clearer now , with these screenshots.

    Many, many thanks in advance!
    emoji


    Generated Image Alt-Text
    [edited by: RWS Community AI at 8:26 AM (GMT 0) on 27 Feb 2025]
Children