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
  •  POWER belongs to the Mathematical category.  POWER performs Calculation operations.  The Excel versions supporting POWER are Excel 2019,Excel 2016.  POWER needs 2 required arguments
  •  TRIM belongs to the Text category.  TRIM performs Manipulation operations.  The Excel versions supporting TRIM are Excel 2019,Excel 2016.  TRIM needs 1 required arguments
  •  DATEDIF belongs to the Date & Time category.  DATEDIF performs Calculation operations.  The Excel versions supporting DATEDIF are Excel 2019,Excel 2016.  DATEDIF needs 3 required arguments
  •  AGGREGATE belongs to the Mathematical category.  AGGREGATE performs Calculation operations.  The Excel versions supporting AGGREGATE are Excel 2019,Excel 2016.  AGGREGATE needs 3 required arguments
  •  COUNTIFS belongs to the Statistical category.  COUNTIFS performs Calculation operations.  The Excel versions supporting COUNTIFS are Excel 2019,Excel 2016.  COUNTIFS needs 2 required arguments
  •  COLUMN belongs to the Lookup & Reference category.  COLUMN performs Information operations.  The Excel versions supporting COLUMN are Excel 2019,Excel 2016.  COLUMN needs required arguments
  •  SUBSTITUTE belongs to the Text category.  SUBSTITUTE performs Manipulation operations.  The Excel versions supporting SUBSTITUTE are Excel 2019,Excel 2016.  SUBSTITUTE needs 3 required arguments
  •  ROW belongs to the Lookup & Reference category.  ROW performs Information operations.  The Excel versions supporting ROW are Excel 2019,Excel 2016.  ROW needs required arguments
  •  RIGHT belongs to the Text category.  RIGHT performs Manipulation operations.  The Excel versions supporting RIGHT are Excel 2019,Excel 2016.  RIGHT 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
  •  PRODUCT belongs to the Mathematical category.  PRODUCT performs Calculation operations.  The Excel versions supporting PRODUCT are Excel 2019,Excel 2016.  PRODUCT needs 1 required arguments
  •  DAYS belongs to the Date & Time category.  DAYS performs Calculation operations.  The Excel versions supporting DAYS are Excel 2019,Excel 2016.  DAYS needs 2 required arguments
  •  UPPER belongs to the Text category.  UPPER performs Manipulation operations.  The Excel versions supporting UPPER are Excel 2019,Excel 2016.  UPPER needs 1 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
  •  NOW belongs to the Date & Time category.  NOW performs Information operations.  The Excel versions supporting NOW are Excel 2019,Excel 2016.  NOW needs required arguments
  •  SUBTOTAL belongs to the Mathematical category.  SUBTOTAL performs Aggregation operations.  The Excel versions supporting SUBTOTAL are Excel 2019,Excel 2016.  SUBTOTAL needs 2 required arguments
  •  TODAY belongs to the Date & Time category.  TODAY performs Information operations.  The Excel versions supporting TODAY are Excel 2019,Excel 2016.  TODAY needs required arguments
  •  MOD belongs to the Mathematical category.  MOD performs Calculation operations.  The Excel versions supporting MOD are Excel 2019,Excel 2016.  MOD 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
  •  FREQUENCY belongs to the Statistical category.  FREQUENCY performs Calculation operations.  The Excel versions supporting FREQUENCY are Excel 2019,Excel 2016.  FREQUENCY needs 2 required arguments
  •  PMT belongs to the Financial category.  PMT performs Calculation operations.  The Excel versions supporting PMT are Excel 2019,Excel 2016.  PMT needs 3 required arguments
  •  ROUNDUP belongs to the Mathematical category.  ROUNDUP performs Calculation operations.  The Excel versions supporting ROUNDUP are Excel 2019,Excel 2016.  ROUNDUP needs 2 required arguments
  •  EXACT belongs to the Text category.  EXACT performs Comparison operations.  The Excel versions supporting EXACT are Excel 2019,Excel 2016.  EXACT needs 2 required arguments
  •  WEEKDAY belongs to the Date & Time category.  WEEKDAY performs Conversion operations.  The Excel versions supporting WEEKDAY are Excel 2019,Excel 2016.  WEEKDAY needs 1 required arguments