90 Best Excel Functions compatible with Excel 2016

90 Best Excel Functions compatible with Excel 2016

Categories
Excel functions that work specifically in Excel 2016 version These Excel functions are optimized for Excel 2016, incorporating all the features and improvements available in this version. They provide enhanced functionality while maintaining backward compatibility. The compatibility ensures users can leverage the advanced features of Excel 2016 while using these functions effectively.
Facts about Best Excel Functions compatible with Excel 2016
  •  FIND belongs to the Mathematical category.  FIND performs Manipulation operations.  The Excel versions supporting FIND are Excel 2019,Excel 2016.  FIND needs 2 required arguments
  •  AVERAGEIF belongs to the Statistical category.  AVERAGEIF performs Calculation operations.  The Excel versions supporting AVERAGEIF are Excel 2019,Excel 2016.  AVERAGEIF needs 2 required arguments
  •  YEAR belongs to the Date & Time category.  YEAR performs Information operations.  The Excel versions supporting YEAR are Excel 2019,Excel 2016.  YEAR needs 1 required arguments
  •  DAY belongs to the Date & Time category.  DAY performs Information operations.  The Excel versions supporting DAY are Excel 2019,Excel 2016.  DAY needs 1 required arguments
  •  CEILING belongs to the Mathematical category.  CEILING performs Calculation operations.  The Excel versions supporting CEILING are Excel 2019,Excel 2016.  CEILING needs 2 required arguments
  •  FLOOR belongs to the Mathematical category.  FLOOR performs Calculation operations.  The Excel versions supporting FLOOR are Excel 2019,Excel 2016.  FLOOR needs 2 required arguments
  •  WORKDAY belongs to the Date & Time category.  WORKDAY performs Calculation operations.  The Excel versions supporting WORKDAY are Excel 2019,Excel 2016.  WORKDAY needs 2 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
  •  RANDBETWEEN belongs to the Mathematical category.  RANDBETWEEN performs Calculation operations.  The Excel versions supporting RANDBETWEEN are Excel 2019,Excel 2016.  RANDBETWEEN needs 2 required arguments
  •  ISNA belongs to the Information category.  ISNA performs Comparison operations.  The Excel versions supporting ISNA are Excel 2019,Excel 2016.  ISNA needs 1 required arguments
  •  LOWER belongs to the Text category.  LOWER performs Manipulation operations.  The Excel versions supporting LOWER are Excel 2019,Excel 2016.  LOWER needs 1 required arguments
  •  FACT belongs to the Mathematical category.  FACT performs Calculation operations.  The Excel versions supporting FACT are Excel 2019,Excel 2016.  FACT needs 1 required arguments
  •  FORMULATEXT belongs to the Information category.  FORMULATEXT performs Information operations.  The Excel versions supporting FORMULATEXT are Excel 2019,Excel 2016.  FORMULATEXT needs 1 required arguments
  •  SMALL belongs to the Statistical category.  SMALL performs Calculation operations.  The Excel versions supporting SMALL are Excel 2019,Excel 2016.  SMALL needs 2 required arguments
  •  LARGE belongs to the Statistical category.  LARGE performs Calculation operations.  The Excel versions supporting LARGE are Excel 2019,Excel 2016.  LARGE needs 2 required arguments
  •  NETWORKDAYS belongs to the Date & Time category.  NETWORKDAYS performs Calculation operations.  The Excel versions supporting NETWORKDAYS are Excel 2019,Excel 2016.  NETWORKDAYS needs 2 required arguments
  •  IFERROR belongs to the Logical category.  IFERROR performs Calculation operations.  The Excel versions supporting IFERROR are Excel 2019,Excel 2016,Excel 2013.  IFERROR needs 2 required arguments
  •  PROPER belongs to the Text category.  PROPER performs Manipulation operations.  The Excel versions supporting PROPER are Excel 2019,Excel 2016.  PROPER needs 1 required arguments
  •  CLEAN belongs to the Text category.  CLEAN performs Manipulation operations.  The Excel versions supporting CLEAN are Excel 2019,Excel 2016.  CLEAN needs 1 required arguments
  •  GETPIVOTDATA belongs to the Database category.  GETPIVOTDATA performs Retrieval operations.  The Excel versions supporting GETPIVOTDATA are Excel 2019,Excel 2016.  GETPIVOTDATA needs 2 required arguments
  •  MODE belongs to the Statistical category.  MODE performs Calculation operations.  The Excel versions supporting MODE are Excel 2019,Excel 2016.  MODE needs 1 required arguments
  •  DOLLAR belongs to the Text category.  DOLLAR performs Conversion operations.  The Excel versions supporting DOLLAR are Excel 2019,Excel 2016.  DOLLAR needs 1 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
  •  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
  •  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