Forum Discussion
_Xlfn and 365
I have an older xl file from a machine that had a 365 license and am still getting the _xlfn prefix for IFS functions even though i have installed excel with a 365 license on my new machine. deta...
Perhaps the machine you are opening the file on is on a slower update track? Does the IFS function appear in the intellisense when you try to type it in a cell?
it does not...my version says 16.17 (180909) and my license says office 365
- And which build number? Mine is Version 1809 (Build 10827.20138), which does noet include IFS.
I guess that is Excel for Mac, in general IFS shall be in 16.17.x
