Forum Discussion
.xlfn when using =FORMULATEXT on excel 2016
When it shall be another name for that function for your SKU
- how can i find the other name ?
when i use the FORMULATEXT it works, but when i close the file and reopen it i get the .xllfn_Gai,
Here is the formula translator https://en.excel-translator.de/translator/ if it supports your version.
Another option is to open this https://support.office.com/en-us/article/formulatext-function-0a786771-54fd-4ae2-96ee-09cda35439c8 support article (English US) and in very left bottom of the page to change the language - it will show the same article in selected language.
_xlfn. is displayed when the function is not supported by your version of the Excel https://support.office.com/en-gb/article/issue-an-xlfn-prefix-is-displayed-in-front-of-a-formula-882f1ef7-68fb-4fcd-8d54-9fbb77fd5025. Since you are on Excel 2016 most probably that's the localization, i.e. in your local version the function has another name.
Dear Sergei,
a few weeks ago i made an excel sheet which we would use a lot for our company as a standard.
i used the IF formula a lot because there are some regulations which are tested in the sheet, it worked perfectly.
After a few weeks holliday i am trying to use the same sheet but i get the _xlfn.IFS code, so this formula is not supported by my version of excel. Is there an update which removes this formula from excel?
i dont understand why this is changed i a few weeks time without us updating or changing anything.
with kind regards,
**bleep** de Braal
