26 Best Excel Functions for Microsoft 365
Categories- Function Category 📊MathematicalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013, Microsoft 365 and Excel OnlineRequired Arguments Count 🔢1Pros ✅Easy To Use, Widely Recognized, Versatile and Fast CalculationCons ❌Limited To Numbers Only, Cannot Handle Text and No Text Handling
- Function Category 📊LogicalOperation Type 🔧ComparisonVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013, Microsoft 365 and Excel OnlineRequired Arguments Count 🔢3Pros ✅Simple Logic Implementation, Versatile, Flexible and Easy To UnderstandCons ❌Nested IFs Can Be Complex, Limited Conditions and Nested IFs Get Complex
- Function Category 📊Lookup & ReferenceOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019 & Microsoft 365Required Arguments Count 🔢3Pros ✅Dynamic Array Support, Handles Errors Gracefully and Bi-Directional LookupCons ❌Complex Syntax For Beginners, Limited Backward Compatibility, Not Available In Older Versions and Complex For Beginners
- Function Category 📊Lookup & ReferenceOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013 and Microsoft 365Required Arguments Count 🔢3Pros ✅More Flexible Than VLOOKUP, Can Search Both Ways, Better Performance and Column IndependentCons ❌Requires Two Functions, Steeper Learning Curve and Complex Syntax
- Function Category 📊MathematicalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Microsoft 365Required Arguments Count 🔢1Pros ✅Automatic Sequence Generation, Dynamic Arrays, Flexible Steps and Generates Number SeriesCons ❌Modern Excel Required, Overflow Potential, New Versions Only and Limited Customization
- Function Category 📊DatabaseOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2019 & Microsoft 365Required Arguments Count 🔢2Pros ✅Dynamic Filtering, Multiple Criteria, Flexible Output, Returns Dynamic Arrays and Flexible FilteringCons ❌Requires Modern Excel, Complex For Beginners, Requires Latest Excel Versions and Memory Intensive
- Function Category 📊DatabaseOperation Type 🔧AggregationVersion Compatibility 💻Excel 2019 & Microsoft 365Required Arguments Count 🔢1Pros ✅Removes Duplicates Automatically, Dynamic Results, Simple Syntax and Automatically UpdatesCons ❌Requires Latest Excel Versions, Array Spillover Needs Space, Limited To Newer Versions and Single Operation
- Function Category 📊TextOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2019, Excel 2016 and Microsoft 365Required Arguments Count 🔢2Pros ✅Array Support & Dynamic RangesCons ❌Not Backward Compatible & Limited Formatting
- Function Category 📊StatisticalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013 and Microsoft 365Required Arguments Count 🔢1Pros ✅Simple To Use, Quick Results and ReliableCons ❌Only Counts Completely Empty Cells, Cannot Count Specific Values and Limited Functionality
- Function Category 📊StatisticalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013, Microsoft 365 and Excel OnlineRequired Arguments Count 🔢1Pros ✅Simple To Use, Common Function and UniversalCons ❌Ignores Text, Includes Zero Values, Numbers Only and No Weights
- Function Category 📊DatabaseOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2019 & Microsoft 365Required Arguments Count 🔢1Pros ✅Automatic Sorting, Dynamic Results, Multiple Columns and Automatic UpdatesCons ❌Requires Modern Excel, Space Requirements and Resource Intensive
- Function Category 📊LogicalOperation Type 🔧ComparisonVersion Compatibility 💻Excel 2016 & Microsoft 365Required Arguments Count 🔢2Pros ✅Multiple Condition Support, Clean Syntax and Logical FlowCons ❌All Conditions Must Be Specified & Order Sensitive
- Function Category 📊InformationOperation Type 🔧ComparisonVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013 and Microsoft 365Required Arguments Count 🔢1Pros ✅Fast Execution, Simple Syntax and Reliable ResultsCons ❌Limited To Number Checking, Binary Output Only and No Customization
- Function Category 📊TextOperation Type 🔧ConversionVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013 and Microsoft 365Required Arguments Count 🔢2Pros ✅Flexible Formatting Options & Widely CompatibleCons ❌Format String Complexity & Learning Curve
- Function Category 📊EngineeringOperation Type 🔧CalculationVersion Compatibility 💻Microsoft 365Required Arguments Count 🔢1Pros ✅Reusable Code, Custom Functions, Recursive Capability, Reusable Custom Functions and Reduces ComplexityCons ❌Steep Learning Curve, Modern Excel Only, Recent Addition and Advanced Concept
- Function Category 📊TextOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2016 & Microsoft 365Required Arguments Count 🔢3Pros ✅Flexible Delimiter, Ignore Empty Cells and Array SupportCons ❌Version Compatibility & Complex For Basic Users
- Function Category 📊TextOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013, Microsoft 365 and Excel OnlineRequired Arguments Count 🔢2Pros ✅Simple Text Extraction, Consistent, Easy Text Handling and QuickCons ❌Limited To Left Side, Fixed Length Only, Only Left Side and Fixed Length
- Function Category 📊TextOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013, Microsoft 365 and Excel OnlineRequired Arguments Count 🔢2Pros ✅Simple Text Combining, Clear Syntax, Simple To Use and Flexible Text CombinationCons ❌No Automatic Formatting, Limited To Text, Limited To Text Only and No Delimiter Options
- Function Category 📊EngineeringOperation Type 🔧ManipulationVersion Compatibility 💻Microsoft 365Required Arguments Count 🔢2Pros ✅Improves Formula Readability & Reduces Calculation OverheadCons ❌Limited Backward Compatibility & Steep Learning Curve
- Function Category 📊MathematicalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2016 & Microsoft 365Required Arguments Count 🔢3Pros ✅Multiple Condition Support, Array Handling and Efficient ProcessingCons ❌Requires Sorted Data & Limited To Numbers
- 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 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
- 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 📊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 📊FinancialOperation Type 🔧InformationVersion Compatibility 💻Microsoft 365Required Arguments Count 🔢2Pros ✅Real-Time Data, Historical Prices, Automatic Updates and Comprehensive InfoCons ❌Subscription Required & Internet Dependent
Showing 1 to 25 from 26 items.
Facts about Best Excel Functions for Microsoft 365
- SUM
- SUM belongs to the Mathematical category.
- SUM performs Calculation operations.
- The Excel versions supporting SUM are Excel 2019,Excel 2016,Excel 2013,Microsoft 365.
- SUM needs 1 required arguments
- IF
- IF belongs to the Logical category.
- IF performs Comparison operations.
- The Excel versions supporting IF are Excel 2019,Excel 2016,Excel 2013,Microsoft 365.
- IF needs 3 required arguments
- XLOOKUP
- XLOOKUP belongs to the Lookup & Reference category.
- XLOOKUP performs Retrieval operations.
- The Excel versions supporting XLOOKUP are Excel 2019,Microsoft 365.
- XLOOKUP needs 3 required arguments
- INDEX_MATCH
- INDEX_MATCH belongs to the Lookup & Reference category.
- INDEX_MATCH performs Retrieval operations.
- The Excel versions supporting INDEX_MATCH are Excel 2019,Excel 2016,Excel 2013.
- INDEX_MATCH needs 3 required arguments
- SEQUENCE
- SEQUENCE belongs to the Mathematical category.
- SEQUENCE performs Calculation operations.
- The Excel versions supporting SEQUENCE are Excel 2019,Microsoft 365.
- SEQUENCE needs 1 required arguments
- FILTER
- FILTER belongs to the Database category.
- FILTER performs Manipulation operations.
- The Excel versions supporting FILTER are Excel 2019,Microsoft 365.
- FILTER needs 2 required arguments
- UNIQUE
- UNIQUE belongs to the Database category.
- UNIQUE performs Aggregation operations.
- The Excel versions supporting UNIQUE are Excel 2019,Microsoft 365.
- UNIQUE needs 1 required arguments
- CONCAT
- CONCAT belongs to the Text category.
- CONCAT performs Manipulation operations.
- The Excel versions supporting CONCAT are Excel 2019,Excel 2016.
- CONCAT needs 2 required arguments
- COUNTBLANK
- COUNTBLANK belongs to the Statistical category.
- COUNTBLANK performs Calculation operations.
- The Excel versions supporting COUNTBLANK are Excel 2019,Excel 2016,Excel 2013.
- COUNTBLANK needs 1 required arguments
- AVERAGE
- AVERAGE belongs to the Statistical category.
- AVERAGE performs Calculation operations.
- The Excel versions supporting AVERAGE are Excel 2019,Excel 2016,Excel 2013,Microsoft 365.
- AVERAGE needs 1 required arguments
- SORT
- SORT belongs to the Database category.
- SORT performs Manipulation operations.
- The Excel versions supporting SORT are Excel 2019,Microsoft 365.
- SORT needs 1 required arguments
- IFS
- IFS belongs to the Logical category.
- IFS performs Comparison operations.
- The Excel versions supporting IFS are Excel 2016,Microsoft 365.
- IFS needs 2 required arguments
- ISNUMBER
- 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
- 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
- LAMBDA
- LAMBDA belongs to the Engineering category.
- LAMBDA performs Calculation operations.
- LAMBDA is compatible with Microsoft 365
- LAMBDA needs 1 required arguments
- TEXTJOIN
- TEXTJOIN belongs to the Text category.
- TEXTJOIN performs Manipulation operations.
- The Excel versions supporting TEXTJOIN are Excel 2016,Microsoft 365.
- TEXTJOIN needs 3 required arguments
- LEFT
- 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
- CONCATENATE
- 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
- LET
- LET belongs to the Engineering category.
- LET performs Manipulation operations.
- LET is compatible with Microsoft 365
- LET needs 2 required arguments
- MAXIFS
- MAXIFS belongs to the Mathematical category.
- MAXIFS performs Calculation operations.
- The Excel versions supporting MAXIFS are Excel 2016,Microsoft 365.
- MAXIFS needs 3 required arguments
- INDEX
- 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
- SUMIFS
- 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
- COUNTIF
- 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
- MATCH
- 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
- STOCKHISTORY
- STOCKHISTORY belongs to the Financial category.
- STOCKHISTORY performs Information operations.
- STOCKHISTORY is compatible with Microsoft 365
- STOCKHISTORY needs 2 required arguments