101 Best Excel Functions compatible with Excel 2019

101 Best Excel Functions compatible with Excel 2019

Categories
Excel functions that work specifically in Excel 2019 version These Excel functions are fully supported in Excel 2019, incorporating the latest features and improvements available in this version. They take advantage of modern Excel capabilities and enhancements. The compatibility ensures users can utilize the most recent Excel features while maintaining reliable function performance.
Facts about Best Excel Functions compatible with Excel 2019
  •  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
  •  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
  •  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
  •  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
  •  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
  •  MONTH belongs to the Date & Time category.  MONTH performs Information operations.  The Excel versions supporting MONTH are Excel 2019,Excel 2016.  MONTH 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
  •  LEN belongs to the Text category.  LEN performs Manipulation operations.  The Excel versions supporting LEN are Excel 2019,Excel 2016.  LEN needs 1 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
  •  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
  •  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
  •  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
  •  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
  •  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
  •  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
  •  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
  •  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
  •  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
  •  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
  •  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
  •  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
  •  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