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
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 updat...
Your community for how-to discussions and sharing best practices on Microsoft Excel. If you’re looking for technical support, please visitMicrosoft Support Community. Forum Discussion