Yulia Kovalskaya 

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!

Thank you, Paul  and Jesús Prieto :

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:

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

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

Columns H and I were translated in Trados.

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

So, Jesús Prieto , 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!

Yulia Kovalskaya 

I mentioned lookup table in my response and the screenshot you have shown looks to be just that.  Note the dropdown arrow in this cell:

That should tell you that these values are drawn from a list, possibly on a different worksheet (might even be hidden), and it is the values in that location that you should be translating, and not the ones in column H and I.

You really need to understand how the original spreadsheet is working and only then will you be able to understand the true nature of the problem... from your screenshots we can only guess.

Yulia Kovalskaya 

I mentioned lookup table in my response and the screenshot you have shown looks to be just that.  Note the dropdown arrow in this cell:

That should tell you that these values are drawn from a list, possibly on a different worksheet (might even be hidden), and it is the values in that location that you should be translating, and not the ones in column H and I.

You really need to understand how the original spreadsheet is working and only then will you be able to understand the true nature of the problem... from your screenshots we can only guess.

You are absolutely right, Paul! There is a dropdown list, so I have to find the elements of the list....but this is the only thing I can get to:

I cannot see the list though....

 Yulia Kovalskaya 

You need to go to the sheet Ayuda. Then the range where the values are picked-up is D7:13

The replacements mentioned in my post need to point to the values in this range.

I have just done it...but these are already translated, looks like Trados detected them as text.

So...what is here to replace?? This is the original doc (the target one has these words in English...)

Yulia Kovalskaya 

Can you provide the complete formula used in the cell that errors?  You want quite detailed help but don't provide enough information to help so we probably spend a lot more time guessing than is really needed here.

A sample spreadsheet would be even better.  If you deleted everything apart from a couple of rows, and anonymized any text, then that would surely help!

You are right, Paul! I have prepared the file:

7870.Sample excel (tab 3).xlsx

*Establecer acción is in herited from the original file (does not require fixing)

Thank you so much!!!