13 Best Excel 97 Functions
Categories- Function Category 📊Date & TimeOperation Type 🔧CalculationRequired Arguments Count 🔢2Creation Date 📅Excel 97Pros ✅Reliable For Financial Reporting & Month-End ProcessingCons ❌Limited To Month-End Dates & Requires Date Serial Numbers
- Function Category 📊WebOperation Type 🔧InformationRequired Arguments Count 🔢2Creation Date 📅Excel 97Pros ✅Easy Link Creation & Customizable Display TextCons ❌Limited Formatting Options & Security Warnings
- Function Category 📊StatisticalOperation Type 🔧CalculationRequired Arguments Count 🔢1Creation Date 📅Excel 97Pros ✅Simple To Use, Quick Results and ReliableCons ❌Only Counts Completely Empty Cells, Cannot Count Specific Values and Limited Functionality
- Function Category 📊TextOperation Type 🔧ManipulationRequired Arguments Count 🔢3Creation Date 📅Excel 97Pros ✅Multiple Replacements, Case Sensitive and PreciseCons ❌Requires Exact Match & Complex Syntax
- Function Category 📊MathematicalOperation Type 🔧CalculationRequired Arguments Count 🔢2Creation Date 📅Excel 97Pros ✅Precise Power Calculations & Handles Large NumbersCons ❌Can Return Errors With Very Large Numbers & Limited To Real Numbers
- Function Category 📊Date & TimeOperation Type 🔧CalculationRequired Arguments Count 🔢3Creation Date 📅Excel 97Pros ✅Accurate Date Calculations & Multiple UnitsCons ❌Hidden Function & Documentation Limitations
- Function Category 📊MathematicalOperation Type 🔧AggregationRequired Arguments Count 🔢2Creation Date 📅Excel 97Pros ✅Ignores Hidden Rows & Multiple FunctionsCons ❌Function Code Memorization & Limited Operations
- Function Category 📊StatisticalOperation Type 🔧CalculationRequired Arguments Count 🔢2Creation Date 📅Excel 97Pros ✅Simple To Use & Flexible RankingCons ❌Array Size Limitations & Not Dynamic
- Function Category 📊StatisticalOperation Type 🔧CalculationRequired Arguments Count 🔢2Creation Date 📅Excel 97Pros ✅Easy To Understand & Reliable ResultsCons ❌Array Size Limitations & Static Ranking
- Function Category 📊StatisticalOperation Type 🔧AggregationRequired Arguments Count 🔢2Creation Date 📅Excel 97Pros ✅Easy Conditional Counting, Flexible Criteria, Simple To Use and EfficientCons ❌Limited To Single Condition, Case Sensitive and Limited Criteria Options
- Function Category 📊StatisticalOperation Type 🔧CalculationRequired Arguments Count 🔢3Creation Date 📅Excel 97Pros ✅Statistical Accuracy, Trend Analysis, Professional, Scientific Prediction and Based On Historical DataCons ❌Assumes Linear Relationship, Complex Setup and Sensitive To Outliers
- Function Category 📊DatabaseOperation Type 🔧AggregationRequired Arguments Count 🔢3Creation Date 📅Excel 97Pros ✅Powerful Database Calculations & Complex Criteria SupportCons ❌Complicated Syntax & Requires Database Structure
- Function Category 📊Lookup & ReferenceOperation Type 🔧RetrievalRequired Arguments Count 🔢1Creation Date 📅Excel 97Pros ✅Flexible Referencing & Dynamic Range SelectionCons ❌Performance Intensive & Complex Syntax
Showing 1 to 25 from 13 items.
Facts about Best Excel 97 Functions
- EOMONTH
- EOMONTH belongs to the Date & Time category.
- EOMONTH performs Calculation operations.
- EOMONTH needs 2 required arguments
- EOMONTH was created in Excel 97.
- HYPERLINK
- HYPERLINK belongs to the Web category.
- HYPERLINK performs Information operations.
- HYPERLINK needs 2 required arguments
- HYPERLINK was created in Excel 97.
- COUNTBLANK
- COUNTBLANK belongs to the Statistical category.
- COUNTBLANK performs Calculation operations.
- COUNTBLANK needs 1 required arguments
- COUNTBLANK was created in Excel 97.
- SUBSTITUTE
- SUBSTITUTE belongs to the Text category.
- SUBSTITUTE performs Manipulation operations.
- SUBSTITUTE needs 3 required arguments
- SUBSTITUTE was created in Excel 97.
- POWER
- POWER belongs to the Mathematical category.
- POWER performs Calculation operations.
- POWER needs 2 required arguments
- POWER was created in Excel 97.
- DATEDIF
- DATEDIF belongs to the Date & Time category.
- DATEDIF performs Calculation operations.
- DATEDIF needs 3 required arguments
- DATEDIF was created in Excel 97.
- SUBTOTAL
- SUBTOTAL belongs to the Mathematical category.
- SUBTOTAL performs Aggregation operations.
- SUBTOTAL needs 2 required arguments
- SUBTOTAL was created in Excel 97.
- LARGE
- LARGE belongs to the Statistical category.
- LARGE performs Calculation operations.
- LARGE needs 2 required arguments
- LARGE was created in Excel 97.
- SMALL
- SMALL belongs to the Statistical category.
- SMALL performs Calculation operations.
- SMALL needs 2 required arguments
- SMALL was created in Excel 97.
- COUNTIF
- COUNTIF belongs to the Statistical category.
- COUNTIF performs Aggregation operations.
- COUNTIF needs 2 required arguments
- COUNTIF was created in Excel 97.
- FORECAST
- FORECAST belongs to the Statistical category.
- FORECAST performs Calculation operations.
- FORECAST needs 3 required arguments
- FORECAST was created in Excel 97.
- DSUM
- DSUM belongs to the Database category.
- DSUM performs Aggregation operations.
- DSUM needs 3 required arguments
- DSUM was created in Excel 97.
- INDIRECT
- INDIRECT belongs to the Lookup & Reference category.
- INDIRECT performs Retrieval operations.
- INDIRECT needs 1 required arguments
- INDIRECT was created in Excel 97.