I am curious if anyone has seen this. I am on the newest version of excel 2016 and my formula works exactly as intended.
=IFS((C5=0)*AND(B5=0,A5=0),4,((C5>0)*AND(B5=0,A5=0)),1,((B5>0)*AND(A5=0)),2,(A5>0),3)
BUT
On a some but not all of my co-workers with the newest version of Excel 2016 as well and is seeing a '=_xlfn.IFS' at the start of the equation. I know this issue comes up if you are using an older version of excel where the IFS function is not supported (but they are using 2016).. I am wondering if something needs to be activated for them to use the IFS function..
=IFS((C5=0)*AND(B5=0,A5=0),4,((C5>0)*AND(B5=0,A5=0)),1,((B5>0)*AND(A5=0)),2,(A5>0),3)
BUT
On a some but not all of my co-workers with the newest version of Excel 2016 as well and is seeing a '=_xlfn.IFS' at the start of the equation. I know this issue comes up if you are using an older version of excel where the IFS function is not supported (but they are using 2016).. I am wondering if something needs to be activated for them to use the IFS function..
What Is The Newest Version Of Excel For Mac
What Is The Newest Version Of Excel
Download Excel 2019
Problem with latest version of Excel. Rufus for mac torrent. Lv date code. Excel 2016 is slower than previous versions but not that much slow. Filtering was an issue which has been sorted out by MS. Recommending Excel Online to the average Excel user is fine-it does all the basics of the desktop version while adding automatic cloud saving in OneDrive, and it has real-time collaboration tools.