Excel Formula Directory

Calculating the absolute value of a number to remove negativity for further calculations

Finding the angle (in radians) from a cosine value for trigonometric calculations

Finding the inverse hyperbolic cosine for exponential or logarithmic analysis

Determining the angle (in radians) from a sine value for trigonometric problems

Calculating the inverse hyperbolic sine for logarithmic or exponential modeling

Finding the angle (in radians) from a tangent value for trigonometric analysis

Calculating the angle (in radians) from x and y coordinates for directional analysis

Finding the inverse hyperbolic tangent for logarithmic or statistical analysis

Rounding a number up to the nearest specified multiple for pricing or scheduling

Calculating the number of combinations for selecting items without regard to order

Calculating the cosine of an angle for trigonometric modeling

Calculating the hyperbolic cosine for exponential or physical modeling

Converting radians to degrees for angle readability

Rounding a number up to the nearest even integer for pairing or batching

Calculating the exponential value (e^x) for growth or decay models

Calculating the factorial of a number for permutations or probability

Calculating the double factorial for specialized combinatorial problems

Rounding a number down to the nearest specified multiple for conservative estimates

Finding the greatest common divisor of numbers for simplifying fractions or ratios

Extracting the integer part of a number for discrete calculations

Finding the least common multiple of numbers for scheduling or alignment

Calculating the natural logarithm for growth or decay analysis

Calculating the logarithm with a custom base for scaling or comparison

Calculating the base-10 logarithm for scientific or engineering scales

Calculating the determinant of a matrix for linear algebra applications

Finding the inverse of a matrix for solving linear equations

Multiplying two matrices for transformations or data analysis

Finding the remainder of a division for cyclic or grouping tasks

Rounding a number to the nearest specified multiple for precise adjustments

Calculating the multinomial coefficient for probability distributions

Rounding a number up to the nearest odd integer for specific alignments

Inserting the value of π for circular or trigonometric calculations

Raising a number to a specified power for exponential calculations

Multiplying a range of numbers for aggregate calculations

Finding the integer quotient of a division for whole-number results

Converting degrees to radians for trigonometric calculations

Generating a random decimal between 0 and 1 for simulations

Generating a random integer between two values for discrete sampling

Converting numbers to Roman numerals for outlines or labels

Rounding a number to a specified decimal place for precision control

Rounding a number down to a specified decimal place for conservative estimates

Rounding a number up to a specified decimal place for generous estimates

Calculating the secant of an angle for advanced trigonometric analysis

Calculating the hyperbolic secant for exponential modeling

Determining the sign of a number for directional analysis

Calculating the sine of an angle for trigonometric modeling

Calculating the hyperbolic sine for exponential analysis

Calculating the square root of a number for geometric or statistical analysis

Calculating the square root of a number times π for circular calculations

Calculating aggregates (sum, average, etc.) while ignoring filtered rows

Adding up a range of numbers for totals

Summing numbers based on a single condition for filtered totals

Summing numbers based on multiple conditions for detailed analysis

Multiplying and summing arrays for weighted totals or dot products

Summing the squares of numbers for variance or distance calculations

Calculating the tangent of an angle for slope or trigonometric analysis

Calculating the hyperbolic tangent for bounded exponential modeling

Truncating a number to a specified decimal place for precise trimming

Finding the mean of a range of numbers for statistical analysis

Finding the mean including text and logical values for broader averaging

Finding the mean of numbers meeting a single condition

Finding the mean of numbers meeting multiple conditions

Counting numeric cells in a range for data tallying

Counting non-empty cells in a range for completeness checks

Counting empty cells in a range for data gap analysis

Counting cells meeting a single condition for selective tallies

Counting cells meeting multiple conditions for detailed analysis

Finding the largest numeric value in a range for peak analysis

Finding the largest value including text and logicals for broader peaks

Finding the middle value in a range for central tendency

Finding the smallest numeric value in a range for low-point analysis

Finding the smallest value including text and logicals for broader lows

Finding the most frequent numeric value in a range

Finding a value at a specific percentile in a range

Finding quartile values in a range for distribution analysis

Finding the rank of a number within a list for ordering

Estimating sample standard deviation for statistical analysis

Estimating sample standard deviation including text and logical values

Calculating population standard deviation for full datasets

Calculating population standard deviation including text and logicals

Estimating sample variance for variability analysis

Estimating sample variance including text and logical values

Calculating population variance for full datasets

Calculating population variance including text and logical values

Converting a code to its character for text formatting

Removing non-printable characters from text for cleanup

Returning the ASCII code of a character for text analysis

Combining multiple text strings into one (deprecated, use CONCAT)

Combining text strings or ranges into one

Formatting a number as currency text

Comparing two text strings for exact match (case-sensitive)

Locating the position of text within a string (case-sensitive)

Formatting a number as text with fixed decimals

Extracting characters from the start of a text string

Counting the length of a text string

Converting text to lowercase for standardization

Extracting a substring from the middle of text

Capitalizing the first letter of each word in text

Replacing a portion of text with new text

Repeating text a specified number of times for patterns or formatting

Extracting characters from the end of a text string

Locating the position of text within a string (case-insensitive)

Replacing specific text with new text in a string

Converting a number to text with a specified format

Combining text from multiple ranges with a delimiter

Removing excess spaces from text for clean data

Converting text to uppercase for standardization

Converting text that represents a number to a numeric value

Testing if all conditions are TRUE for logical operations

Returning the logical value FALSE for conditional formulas

Performing a conditional test and returning different values based on the result

Handling errors in formulas by providing an alternative result

Handling #N/A errors with an alternative result

Testing multiple conditions and returning different results

Reversing the logical value of an expression

Testing if any condition is TRUE for logical operations

Evaluating an expression against multiple values and returning a matching result

Returning the logical value TRUE for conditional formulas

Testing if exactly one condition is TRUE for exclusive logical operations

Creating a cell reference as text by providing row and column numbers

Selecting a value from a list based on position

Returning the column number of a reference for position-based calculations

Counting the number of columns in a range for dimension analysis

Looking up a value in the top row and returning a value from a specified row

Returning a value from a table based on its position

Converting a text string into a cell reference for dynamic referencing

Finding an approximate match in a sorted range or two arrays

Finding the position of a value in a range

Creating dynamic references with a specified offset from a starting reference

Returning the row number of a reference for position-based calculations

Counting the number of rows in a range for dimension analysis

Converting a vertical range to horizontal or vice versa

Looking up a value in the first column and returning a value from the same row

Looking up values with enhanced flexibility and control

Finding the position of a value in a range with enhanced options

Creating a date value from year, month, and day components

Calculating the difference between two dates in various units

Converting a date stored as text to a serial number

Extracting the day of the month from a date value

Calculating the number of days between two dates

Calculating days between dates based on a 360-day year

Calculating a date that is a specified number of months before or after another date

Calculating the last day of a month that is a specified number of months from a date

Extracting the hour component from a time value

Finding the ISO week number of a date for standardized week numbering

Extracting the minute component from a time value

Extracting the month number from a date value

Calculating the number of working days between two dates

Retrieving the current date and time that updates when the workbook recalculates

Extracting the seconds component from a time value

Creating a time value from hour, minute, and second components

Converting a time stored as text to a serial number

Retrieving the current date that updates when the workbook recalculates

Determining the day of the week from a date

Calculating the week number within a year for a given date

Calculating a date that is a specified number of working days away

Extracting the year component from a date value

Calculating the fraction of a year between two dates

Calculating accrued interest for a security that pays periodic interest

Calculating depreciation using the French accounting system's degressive method

Calculating depreciation using the French accounting system's linear method

Calculating the days from the beginning of the coupon period to the settlement date

Calculating the number of days in the coupon period containing the settlement date

Calculating cumulative interest paid on a loan between two periods

Calculating cumulative principal paid on a loan between two periods

Calculating asset depreciation using the declining balance method

Calculating asset depreciation using the double-declining balance method

Calculating the future value of an investment with regular payments

Calculating the interest payment for a specific period of a loan

Calculating the internal rate of return for a series of cash flows

Calculating the interest payment for a loan with straight-line amortization

Calculating the modified internal rate of return for a series of cash flows

Calculating the number of periods required for an investment or loan

Calculating the net present value of an investment based on a series of cash flows

Calculating the payment for a loan based on constant payments and interest rate

Calculating the principal payment for a specific period of a loan

Calculating the present value of an investment based on future payments

Calculating the interest rate for a loan or investment

Calculating the straight-line depreciation of an asset for a single period

Calculating the sum-of-years-digits depreciation of an asset for a specified period

Returning a number corresponding to a specific Excel error type

Checking if a cell is empty

Checking if a value is any error except #N/A

Checking if a value is any error type

Checking if a number is even

Checking if a cell contains a formula

Checking if a value is a logical value (TRUE or FALSE)

Checking if a value is the #N/A error

Checking if a value is not text

Checking if a value is a number

Checking if a number is odd

Checking if a value is a cell reference

Checking if a value is text

Converting values to numbers for calculations

Returning the #N/A error value to indicate unavailable data

Returning a number indicating the data type of a value

Converting a binary number to decimal format

Converting a binary number to hexadecimal format

Converting a binary number to octal format

Creating a complex number from real and imaginary coefficients

Converting a measurement from one unit to another

Converting a decimal number to binary format for numeral system conversion

Converting a decimal number to hexadecimal format for compact number representation

Converting a decimal number to octal format for specific numeral system requirements

Converting a hexadecimal number to binary format for digital system analysis

Converting a hexadecimal number to decimal format for standard numerical calculations

Converting a hexadecimal number to octal format for specific numerical system transformations

Calculating the absolute value (modulus) of a complex number

Extracting the imaginary coefficient of a complex number

Calculating the argument (theta) of a complex number in radians

Calculating the complex conjugate of a complex number

Dividing two complex numbers

Calculating the exponential of a complex number

Calculating the natural logarithm of a complex number

Calculating the base-10 logarithm of a complex number

Calculating the base-2 logarithm of a complex number

Raising a complex number to a power

Multiplying complex numbers together

Extracting the real coefficient from a complex number for complex number analysis

Calculating the sine of a complex number for complex analysis

Calculating the square root of a complex number for complex analysis

Subtracting one complex number from another for complex number operations

Calculating the tangent of a complex number for complex analysis

Converting an octal number to binary for number base conversion

Converting an octal number to decimal for number base conversion

Converting an octal number to hexadecimal for number base conversion

Calculating the average of values in a database that match specific criteria

Counting numeric cells in a database column that match specific criteria

Counting non-blank cells in a database column that match specific criteria

Extracting a single value from a database that matches specific criteria

Finding the maximum value in a database column that matches specific criteria

Finding the minimum value in a database column that matches specific criteria

Adding up values in a database column that match specific criteria