Search

Hello all,

I’m using Microsoft excel 2016.

I have used the FORMULATEXT function to show the formulas in row a as text in row b.

For some reason every time I open the file a “.xlfn_” is added before the “formulatext”.

I’ve googled it and found out that this happens when someone is using a lower version of excel that dose not support this formula, but I’m using only 2016 version.

Please advise.

-----

Gai Golan, CPA (isr), CDM implementer

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-882... . 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)))