90 Best Excel Functions compatible with Excel 2016
Categories- 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 📊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 📊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 ✅Straightforward & ReliableCons ❌Limited Functionality & Single Purpose
- 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 📊MathematicalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Excel 2016Required Arguments Count 🔢2Pros ✅Consistent Results & Engineering ApplicationsCons ❌Limited To Downward Rounding & Single Direction
- 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 📊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 📊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 📊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 📊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 📊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 📊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 📊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 📊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 📊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 📊DatabaseOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019 & Excel 2016Required Arguments Count 🔢2Pros ✅Precise Data Retrieval & Automation FriendlyCons ❌Complex Syntax & PivotTable Dependency
- 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 📊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 📊Lookup & ReferenceOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013, Microsoft 365 and Excel OnlineRequired Arguments Count 🔢3Pros ✅Flexible Matching, Works With INDEX, Versatile Search and FastCons ❌Requires Sorted Data, Complex Syntax and Requires Exact Matches
- Function Category 📊StatisticalOperation Type 🔧AggregationVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013, Microsoft 365 and Excel OnlineRequired Arguments Count 🔢2Pros ✅Easy Conditional Counting, Flexible Criteria, Simple To Use and EfficientCons ❌Limited To Single Condition, Case Sensitive and Limited Criteria Options
- 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 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