26 Best Excel Functions for Microsoft 365

26 Best Excel Functions for Microsoft 365

Categories
Excel functions optimized for the latest Microsoft 365 platform These Excel functions are designed to work optimally in Microsoft 365, taking advantage of the latest features and cloud capabilities. They incorporate modern Excel functionality and regular updates. The compatibility ensures users can leverage the full power of Microsoft 365's constantly evolving feature set.
Facts about Best Excel Functions for Microsoft 365
  •  SUM belongs to the Mathematical category.  SUM performs Calculation operations.  The Excel versions supporting SUM are Excel 2019,Excel 2016,Excel 2013,Microsoft 365.  SUM needs 1 required arguments
  •  IF belongs to the Logical category.  IF performs Comparison operations.  The Excel versions supporting IF are Excel 2019,Excel 2016,Excel 2013,Microsoft 365.  IF needs 3 required arguments
  •  XLOOKUP belongs to the Lookup & Reference category.  XLOOKUP performs Retrieval operations.  The Excel versions supporting XLOOKUP are Excel 2019,Microsoft 365.  XLOOKUP needs 3 required arguments
  •  INDEX_MATCH belongs to the Lookup & Reference category.  INDEX_MATCH performs Retrieval operations.  The Excel versions supporting INDEX_MATCH are Excel 2019,Excel 2016,Excel 2013.  INDEX_MATCH needs 3 required arguments
  •  SEQUENCE belongs to the Mathematical category.  SEQUENCE performs Calculation operations.  The Excel versions supporting SEQUENCE are Excel 2019,Microsoft 365.  SEQUENCE needs 1 required arguments
  •  FILTER belongs to the Database category.  FILTER performs Manipulation operations.  The Excel versions supporting FILTER are Excel 2019,Microsoft 365.  FILTER needs 2 required arguments
  •  UNIQUE belongs to the Database category.  UNIQUE performs Aggregation operations.  The Excel versions supporting UNIQUE are Excel 2019,Microsoft 365.  UNIQUE needs 1 required arguments
  •  CONCAT belongs to the Text category.  CONCAT performs Manipulation operations.  The Excel versions supporting CONCAT are Excel 2019,Excel 2016.  CONCAT needs 2 required arguments
  •  COUNTBLANK belongs to the Statistical category.  COUNTBLANK performs Calculation operations.  The Excel versions supporting COUNTBLANK are Excel 2019,Excel 2016,Excel 2013.  COUNTBLANK needs 1 required arguments
  •  AVERAGE belongs to the Statistical category.  AVERAGE performs Calculation operations.  The Excel versions supporting AVERAGE are Excel 2019,Excel 2016,Excel 2013,Microsoft 365.  AVERAGE needs 1 required arguments
  •  SORT belongs to the Database category.  SORT performs Manipulation operations.  The Excel versions supporting SORT are Excel 2019,Microsoft 365.  SORT needs 1 required arguments
  •  IFS belongs to the Logical category.  IFS performs Comparison operations.  The Excel versions supporting IFS are Excel 2016,Microsoft 365.  IFS needs 2 required arguments
  •  ISNUMBER belongs to the Information category.  ISNUMBER performs Comparison operations.  The Excel versions supporting ISNUMBER are Excel 2019,Excel 2016,Excel 2013.  ISNUMBER needs 1 required arguments
  •  TEXT belongs to the Text category.  TEXT performs Conversion operations.  The Excel versions supporting TEXT are Excel 2019,Excel 2016,Excel 2013.  TEXT needs 2 required arguments
  •  LAMBDA belongs to the Engineering category.  LAMBDA performs Calculation operations.  LAMBDA is compatible with Microsoft 365  LAMBDA needs 1 required arguments
  •  TEXTJOIN belongs to the Text category.  TEXTJOIN performs Manipulation operations.  The Excel versions supporting TEXTJOIN are Excel 2016,Microsoft 365.  TEXTJOIN needs 3 required arguments
  •  LEFT belongs to the Text category.  LEFT performs Manipulation operations.  The Excel versions supporting LEFT are Excel 2019,Excel 2016,Excel 2013,Microsoft 365.  LEFT needs 2 required arguments
  •  CONCATENATE belongs to the Text category.  CONCATENATE performs Manipulation operations.  The Excel versions supporting CONCATENATE are Excel 2019,Excel 2016,Excel 2013,Microsoft 365.  CONCATENATE needs 2 required arguments
  •  LET belongs to the Engineering category.  LET performs Manipulation operations.  LET is compatible with Microsoft 365  LET needs 2 required arguments
  •  MAXIFS belongs to the Mathematical category.  MAXIFS performs Calculation operations.  The Excel versions supporting MAXIFS are Excel 2016,Microsoft 365.  MAXIFS needs 3 required arguments
  •  INDEX belongs to the Lookup & Reference category.  INDEX performs Retrieval operations.  The Excel versions supporting INDEX are Excel 2019,Excel 2016,Excel 2013,Microsoft 365.  INDEX needs 3 required arguments
  •  SUMIFS belongs to the Mathematical category.  SUMIFS performs Calculation operations.  The Excel versions supporting SUMIFS are Excel 2019,Excel 2016,Excel 2013,Microsoft 365,Excel Online,Excel 2007.  SUMIFS needs 3 required arguments
  •  COUNTIF belongs to the Statistical category.  COUNTIF performs Aggregation operations.  The Excel versions supporting COUNTIF are Excel 2019,Excel 2016,Excel 2013,Microsoft 365.  COUNTIF needs 2 required arguments
  •  MATCH belongs to the Lookup & Reference category.  MATCH performs Retrieval operations.  The Excel versions supporting MATCH are Excel 2019,Excel 2016,Excel 2013,Microsoft 365.  MATCH needs 3 required arguments
  •  STOCKHISTORY belongs to the Financial category.  STOCKHISTORY performs Information operations.  STOCKHISTORY is compatible with Microsoft 365  STOCKHISTORY needs 2 required arguments