Option 1: Install the Excel PowerUps Premium Suite add-in If you have a standalone version of Excel that does not have the IFS, MAXIFS, MINIFS, SWITCH, CONCAT or TEXTJOIN function you have a few options to get the functionality. But it does seem like there is an unmet expectation that buying a full license of Excel gets the most current version of Excel. Were the functions removed from existing standalone copies of Excel 2016? I can’t tell. Some references indicate it may be part of Office 2019.
Other posts such as Excel new functions IFS, MAXIFS, MINIFS, SWITCH, CONCAT, TEXTJOIN not available in ms office 2016, or Why is Excel not able to compute Maxifs function, or Excel 2016 also seem to show where people expected to see IFS, MAXIFS, MINIFS, SWITCH, CONCAT and TEXTJOIN functions but are not able to use them.īased on some answers in the Answers forum from Microsoft, those functions are only made available to subscribers to the Office 365 subscription product. ( Lost new functions like “ifs” & “switch” & “maxifs” after upgrade to. After an update from Microsoft to version. In looking at various posts online, one user notes in his version. Where did the IFS function go? (same for MAXIFS, MINIFS, SWITCH, CONCAT and TEXTJOIN) Can’t find IFS function in Excel 2016?ĭoes it seem like you were once able to use the IFS function in Excel with your worksheets? Can’t find the IFS function in Excel 2016? Do you have a standalone license (a non-Office 365 subscription) of Office? Do your function names now resolve to “_xlfn.IFS”? (same for MAXIFS, MINIFS, SWITCH, CONCAT and TEXTJOIN) Facebook 0 Tweet 0 Pin 0 LinkedIn 0 Print 0
0 kommentar(er)
