Forum Discussion
.xlfn when using =FORMULATEXT on excel 2016
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
Hi **bleep**,
IFS was for Office365 subscribers only, perhaps now it works for the latest Excel 2016 but I'm not sure. As an alternative you may use nested IF which works on any version of Excel, i.e. instead of
'=IFS(test1,value1,test2,value2,test3,value3,TRUE,value4)
it could be
'=IF(test1,value1,IF(test2,value2,IF(test3,value3,value4)))
