101 Best Excel Functions compatible with Excel 2019
Categories- Function Category 📊StatisticalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢2Pros ✅Easy To Understand & Handles Basic Conditional AveragingCons ❌Limited Condition Options & Single Criteria Only
- Function Category 📊MathematicalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Excel 2016Required Arguments Count 🔢2Pros ✅Consistent Results & Engineering ApplicationsCons ❌Limited To Downward Rounding & Single Direction
- Function Category 📊MathematicalOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢2Pros ✅Easy To Use For Basic Text Searches & Case-Sensitive Search CapabilityCons ❌Limited To Text Strings Only & Returns Error If Text Not Found
- Function Category 📊MathematicalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Excel 2016Required Arguments Count 🔢2Pros ✅Predictable Results & Engineering FriendlyCons ❌Limited To Upward Rounding & Single Direction
- Function Category 📊Date & TimeOperation Type 🔧InformationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Simple To Use & Reliable OutputCons ❌Single Purpose & Limited Flexibility
- Function Category 📊Date & TimeOperation Type 🔧InformationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Consistent Results & Easy To UseCons ❌Single Purpose & Basic Output
- Function Category 📊Date & TimeOperation Type 🔧InformationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Straightforward & ReliableCons ❌Limited Functionality & Single Purpose
- Function Category 📊TextOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Simple To Use & ReliableCons ❌Limited To Length Only & Counts Spaces
- Function Category 📊Lookup & ReferenceOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013, Microsoft 365 and Excel OnlineRequired Arguments Count 🔢3Pros ✅Powerful With MATCH, Flexible Lookup, Very Flexible, Fast Performance, Powerful and FlexibleCons ❌Complex Syntax, Requires Understanding, Complex For Beginners, Requires Understanding Of Arrays and Learning Curve
- Function Category 📊Date & TimeOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Excel 2016Required Arguments Count 🔢2Pros ✅Holiday Consideration & Business Calendar SupportCons ❌Weekend Definition Limited & Regional Constraints
- Function Category 📊MathematicalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Excel 2016Required Arguments Count 🔢2Pros ✅Easy To Use & VersatileCons ❌Recalculates Automatically & Not Truly Random
- Function Category 📊InformationOperation Type 🔧ComparisonVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Simple Error Detection & Prevents Formula CrashesCons ❌Only Checks For #N/A Error & Limited Functionality
- Function Category 📊TextOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Simple To Use, Consistent Results and FastCons ❌Single Purpose & Basic Functionality
- Function Category 📊InformationOperation Type 🔧InformationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Great For Learning & Easy DebuggingCons ❌Only Works With Formulas & Limited Functionality
- Function Category 📊TextOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Removes Unwanted Characters, Improves Data Quality and Simple To UseCons ❌Limited Cleaning Scope & Only Removes Specific Characters
- Function Category 📊StatisticalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Easy Statistical Analysis, Quick Results and ReliableCons ❌Only Works With Numbers & Limited To Single Mode
- Function Category 📊MathematicalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Simple To Use, Fast Calculations and AccurateCons ❌Limited To Integers & Maximum Value Restrictions
- Function Category 📊TextOperation Type 🔧ConversionVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Easy Formatting, Professional Output and ConsistentCons ❌Limited Currency Options & Fixed Format
- Function Category 📊LogicalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013 and Excel 2007Required Arguments Count 🔢2Pros ✅Prevents Formula Errors, Clean Presentation, Easy To Implement and Clear Error MessagesCons ❌Can Mask Real Errors, Binary Output Only, Limited Flexibility and Only Handles Errors
- Function Category 📊StatisticalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢2Pros ✅Easy To Understand & Reliable ResultsCons ❌Array Size Limitations & Static Ranking
- Function Category 📊StatisticalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢2Pros ✅Simple To Use & Flexible RankingCons ❌Array Size Limitations & Not Dynamic
- Function Category 📊DatabaseOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019 & Excel 2016Required Arguments Count 🔢2Pros ✅Precise Data Retrieval & Automation FriendlyCons ❌Complex Syntax & PivotTable Dependency
- Function Category 📊TextOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Automatic Capitalization, Consistent Formatting, Easy Formatting and ConsistentCons ❌Struggles With Special Characters, Limited Flexibility and Limited Formatting Options
- Function Category 📊Date & TimeOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢2Pros ✅Excludes Weekends, Holiday Aware, Accurate, Excludes Weekends Automatically and Considers HolidaysCons ❌Requires Date Format, Complex Holiday Handling, Limited Holiday Input Format and Regional Limitations
- Function Category 📊MathematicalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013, Microsoft 365, Excel Online, Excel 2007 and Excel 2010Required Arguments Count 🔢3Pros ✅Multiple Conditions, Accurate Calculations, Flexible For Multiple Criteria, Handles Large Datasets, Easy To Understand, Multiple Conditions Support, Accurate Results, Flexible, Versatile Conditional Summing, Supports Multiple Criteria, Powerful For Multiple Criteria and Flexible ConditionsCons ❌Complex For Beginners, Needs Sorted Data, Complex Syntax For Beginners, Limited To Sum Operations, Performance Issues With Large Ranges, Cannot Use OR Conditions, Complex Syntax, Can Be Slow With Large Datasets, Limited To Sum Operation Only and Requires Sorted Data
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