Problem with Functions Translator

[KDean-Dolphin]

There doesn't appear to be a GitHub project for this and the support link is broken (it leads to UserVoice), so I'm posting here, hoping it gets to the right people.

The Functions Translator has a problem with the literal #N/A. This function works in English:

=IF(A1<0,#N/A,A1)

However, the translator can't process it, returning:

Failed to parse: #N/A

The same is true for the literal #VALUE! etc.

[NWilson]

Thank you @KDean-Dolphin I have found the email address of someone who worked on the Functions Translator (I have never met that team), and forwarded a link to this issue. I can't guarantee anyone will act on the bug report though.

You may find that Excel Labs is able to do what you need? In the settings panel (top-right menu of Labs), there is the option to switch between your language and English. This enables you to copy-paste formulas into or out of your workbook using either English or your locale. The workflow is a bit klunky if you need to switch locale often, but it will do the job.

[KDean-Dolphin]

Thank you, @NWilson. I'm actually going from English to other languages. The translator is the fastest option for me.