Array Functions
- FILTER Excel Function - Selectively extracts rows from a range based on specified criteria.
- MMULT Excel Function - Matrix multiplication function.
- RANDARRAY Excel Function - Generates an array of random numbers.
- SORT Excel Function - Arranges data in ascending or descending order based on specified criteria.
- SORTBY Excel Function - SORTBY sorts a range or array based on the values in corresponding ranges or arrays.
Cube Functions
- CUBEKPIMEMBER Excel Function - Retrieves the Key Performance Indicator (KPI) property of a KPI member from a cube.
- CUBEMEMBERPROPERTY Excel Function - CUBEMEMBERPROPERTY retrieves a property of a member from a cube.
- CUBEMEMBER Excel Function - CUBEMEMBER retrieves a member or tuple from a cube in an OLAP database.
- CUBESETCOUNT Excel Function - Returns the number of items in a set.
- CUBERANKEDMEMBER Excel Function - Retrieves a ranked member from a cube.
- CUBESET Excel Function - Creates a set of members or tuples for use in a cube function.
- CUBEVALUE Excel Function - Retrieves data from a cube.
Database Functions
- DGET Excel Function - DGET retrieves a single value from a database or table based on specified criteria.
Date and Time Functions
- DATE Excel Function - Creates a date value from separate year, month, and day components.
- DATEDIF Excel Function - DATEDIF calculates the difference between two dates in years, months, or days.
- DATEVALUE Excel Function - Converts a date stored as text to a serial number Excel can recognize as a date.
- DAYS360 Excel Function - Calculates the number of days between two dates based on a 360-day year.
- DAY Excel Function - Extracts the day from a date value.
- EDATE Excel Function - Returns a date that is a specified number of months before or after a given date.
- DAYS Excel Function - Calculates the number of days between two dates.
- EOMONTH Excel Function - Returns the last day of the month, a specified number of months before or after a given date.
- HOUR Excel Function - Extracts the hour from a time value.
- ISOWEEKNUM Excel Function - Returns the ISO week number of a specified date.
- MINUTE Excel Function - Extracts the minute value from a time.
- NETWORKDAYS Excel Function - Calculates the number of workdays between two dates, excluding weekends and optional holidays.
- MONTH Excel Function - Extracts the month from a date as a number between 1 and 12.
- NETWORKDAYS.INTL Excel Function - Calculates the number of workdays between two dates, excluding specified weekends and holidays.
- NOW Excel Function - Returns the current date and time as a serial number.
- RECEIVED Excel Function - The RECEIVED function calculates the amount received at maturity for a fully invested security.
- SECOND Excel Function - Extracts the seconds from a time value.
- TIME Excel Function - Creates a time value from separate hour, minute, and second components.
- TIMEVALUE Excel Function - Converts a time string to a decimal number representing the time.
- TODAY Excel Function - Returns the current date as a serial number.
Financial Functions
- ACCRINT Excel Function - Calculates accrued interest for a security that pays periodic interest.
- ACCRINTM Excel Function - Calculates the accrued interest for a security that pays interest at maturity.
- AMORDEGRC Excel Function - Calculates depreciation for each accounting period using a degressive coefficient.
- AMORLINC Excel Function - AMORLINC calculates the depreciation for each accounting period using the French linear amortization system.
- COUPDAYBS Excel Function - Calculates the number of days from the beginning of a coupon period to the settlement date.
- COUPDAYS Excel Function - Calculates the number of days in a coupon period.
- COUPDAYSNC Excel Function - Calculates the number of days from the settlement date to the next coupon date.
- COUPNCD Excel Function - Returns the next coupon date after the settlement date for a bond.
- COUPNUM Excel Function - Calculates the number of coupon payments between the settlement date and maturity date of a security.
- COUPPCD Excel Function - Returns the previous coupon date before the settlement date.
- CUMIPMT Excel Function - Calculates cumulative interest paid on a loan between two specified periods.
- CUMPRINC Excel Function - Calculates cumulative principal paid on a loan between two periods.
- DB Excel Function - DB retrieves data from a database-like table based on specified criteria.
- DDB Excel Function - The DDB function calculates depreciation using the double-declining balance method.
- DISC Excel Function - DISC calculates the discount rate for a security.
- DOLLARDE Excel Function - Converts a dollar price expressed as a fraction to a dollar price expressed as a decimal number.
- DOLLARFR Excel Function - Converts a dollar price expressed as a fraction to a dollar price expressed as a decimal number.
- DURATION Excel Function - DURATION calculates the Macaulay duration of a security with periodic interest payments.
- EFFECT Excel Function - Calculates the effective annual interest rate for a given nominal interest rate and number of compounding periods per year.
- EUROCONVERT Excel Function - Converts an amount from one European currency to another using the euro as an intermediate step.
- FV Excel Function - Calculates the future value of an investment based on periodic, constant payments and a constant interest rate.
- FVSCHEDULE Excel Function - FVSCHEDULE calculates the future value of an initial investment based on a series of variable interest rates.
- INTRATE Excel Function - Calculates the interest rate for a fully invested security.
- IPMT Excel Function - IPMT calculates the interest payment for a given period of a loan or investment based on constant payments and a constant interest rate.
- IRR Excel Function - Calculates the internal rate of return for a series of cash flows.
- ISPMT Excel Function - ISPMT calculates the interest payment for a loan with constant payments to principal.
- MDURATION Excel Function - MDURATION calculates the modified Macaulay duration of a security with an assumed par value of $100.
- MIRR Excel Function - MIRR calculates the modified internal rate of return for a series of cash flows, considering different rates for investment and reinvestment.
- NOMINAL Excel Function - Calculates the nominal annual interest rate given the effective rate and number of compounding periods per year.
- NPER Excel Function - NPER calculates the number of periods for an investment based on constant payments and interest rate.
- NPV Excel Function - Calculates the net present value of an investment using a discount rate and a series of future payments and income.
- ODDFPRICE Excel Function - Calculates the price per $100 face value of a security with an odd first period.
- ODDFYIELD Excel Function - Calculates the yield of a security with an odd first period.
- ODDLPRICE Excel Function - Calculates the price per $100 face value of a security with an odd last period.
- ODDLYIELD Excel Function - Calculates the yield of a security with an odd last period.
- PDURATION Excel Function - PDURATION calculates the number of periods required for an investment to reach a specified future value.
- PMT Excel Function - Calculates periodic loan payments.
- PPMT Excel Function - PPMT calculates the principal payment for a given period of a loan based on constant periodic payments and a constant interest rate.
- PRICE Excel Function - Calculates the price per $100 face value of a security that pays periodic interest.
- PRICEDISC Excel Function - Calculates the price of a discounted security.
- PRICEMAT Excel Function - Calculates the price per $100 face value of a security that pays interest at maturity.
- PV Excel Function - Calculates the present value of an investment.
- RATE Excel Function - Calculates the interest rate for a loan or investment.
- RRI Excel Function - RRI calculates the interest rate for the growth of an investment.
- SLN Excel Function - SLN calculates the straight-line depreciation of an asset for one period.
- SYD Excel Function - SYD calculates the sum-of-years' digits depreciation for an asset over a specified period.
- TBILLEQ Excel Function - Calculates the bond-equivalent yield for a Treasury bill.
- TBILLPRICE Excel Function - Calculates the price per $100 face value for a U.S. Treasury bill.
- TBILLYIELD Excel Function - Calculates the yield for a Treasury bill.
Information Functions
- CELL Excel Function - The CELL function retrieves information about the formatting, location, or contents of a specified cell.
- ERROR.TYPE Excel Function - Returns a number corresponding to a specific error type.
- FORMULATEXT Excel Function - Returns a formula as a string.
- INFO Excel Function - The INFO function retrieves system and environment information about the user's operating system and Excel version.
- ISBLANK Excel Function - Checks if a cell is empty.
- ISERR Excel Function - ISERR checks if a value is an error value (except #N/A).
- ISERROR Excel Function - ISERROR checks if a cell contains an error value and returns TRUE if it does, FALSE otherwise.
- ISFORMULA Excel Function - Checks if a cell contains a formula.
- ISNA Excel Function - Checks if a value is #N/A.
- ISNUMBER Excel Function - Checks if a value is a number.
- ISREF Excel Function - Checks if a value is a reference to a cell or range of cells.
- NA Excel Function - Returns the #N/A error value.
- REGISTER.ID Excel Function - Registers a custom function in Excel.
Logical Functions
- AND Excel Function - A logical function that returns TRUE if all specified conditions are true, otherwise FALSE.
- IF Excel Function - A conditional function that performs different actions based on whether a specified condition is true or false.
- IFERROR Excel Function - Error-handling function that returns a specified value if a formula results in an error.
- IFNA Excel Function - IFNA returns a specified value if the expression is #N/A, otherwise returns the result of the expression.
- IFS Excel Function - A nested IF function that allows multiple conditions and outcomes in a single formula.
- ISLOGICAL Excel Function - ISLOGICAL checks if a value is a logical (TRUE or FALSE) value.
- ISNONTEXT Excel Function - Checks if a value is not text.
- ISTEXT Excel Function - Checks if a value is text.
- OR Excel Function - A logical function that returns TRUE if any of its arguments are TRUE, and FALSE otherwise.
- NOT Excel Function - Logical operator that reverses the logical value of its argument.
- T Excel Function - The T function returns the text from a cell or expression.
- SWITCH Excel Function - Evaluates an expression against a list of values and returns the result corresponding to the first matching value.
Lookup and Reference Functions
- ADDRESS Excel Function - Returns a cell reference as text.
- AREAS Excel Function - Returns the number of areas in a reference.
- CHOOSE Excel Function - CHOOSE selects and returns a value from a list of options based on a specified index number.
- COLUMN Excel Function - Returns the column number of a reference.
- COLUMNS Excel Function - Returns the number of columns in a reference or array.
- HLOOKUP Excel Function - HLOOKUP searches for a value in the top row of a table and returns a corresponding value from a specified row.
- HYPERLINK Excel Function - Creates a clickable link to a specified location.
- INDIRECT Excel Function - A versatile function that converts a text string into a valid cell reference.
- INDEX Excel Function - Retrieves a value from a specified position within a range or array.
- LOOKUP Excel Function - A function that searches for a value in a range and returns a corresponding value from another range.
- MIDB Excel Function - Extracts a specified number of characters from the middle of a text string.
- MATCH Excel Function - Searches for a specified item in a range of cells and returns its relative position.
- OFFSET Excel Function - The OFFSET function returns a reference to a range that is offset from a specified starting cell or range by a given number of rows and columns.
- ROW Excel Function - Returns the row number of a reference.
- ROWS Excel Function - Returns the number of rows in a reference or array.
- RTD Excel Function - Real-time data function for retrieving live, continuously updating information from external sources.
- SEARCHB Excel Function - Searches for specified text in a range and returns its position, considering double-byte characters.
- SHEET Excel Function - Returns the sheet number of the referenced sheet.
- SHEETS Excel Function - Returns the number of sheets in a reference.
- TRANSPOSE Excel Function - Converts a vertical range of cells to a horizontal range, or vice versa.
Mathematical and Trigonometric Functions
- ABS Excel Function - Returns the absolute value of a number.
- ACOS Excel Function - Returns the arccosine, or inverse cosine, of a number.
- ACOSH Excel Function - Returns the inverse hyperbolic cosine of a number.
- ACOT Excel Function - ACOT calculates the arccotangent (inverse cotangent) of a number.
- ACOTH Excel Function - Inverse hyperbolic cotangent function.
- AGGREGATE Excel Function - A versatile function that performs various calculations while ignoring errors and filtered-out cells.
- ASIN Excel Function - Returns the arcsine (inverse sine) of a number.
- ASINH Excel Function - Calculates the inverse hyperbolic sine of a number.
- ATAN Excel Function - ATAN calculates the arctangent (inverse tangent) of a given number in radians.
- ATAN2 Excel Function - ATAN2 calculates the angle (in radians) between the positive x-axis and a line from the origin to a point with given x and y coordinates.
- ATANH Excel Function - ATANH calculates the inverse hyperbolic tangent of a number.
- BESSELI Excel Function - Calculates the modified Bessel function of the first kind.
- BESSELJ Excel Function - Calculates the Bessel function of the first kind.
- BESSELK Excel Function - BESSELK calculates the modified Bessel function of the second kind.
- BESSELY Excel Function - Calculates the Bessel function of the second kind.
- BITAND Excel Function - Performs a bitwise AND operation on two integers.
- BITLSHIFT Excel Function - Shifts the bits of a number to the left by a specified number of positions.
- BITOR Excel Function - Performs a bitwise OR operation on two numbers.
- BITRSHIFT Excel Function - Performs a bitwise right shift on a 32-bit binary number.
- BITXOR Excel Function - Performs a bitwise XOR operation on two numbers.
- CEILING Excel Function - Rounds a number up to the nearest multiple of a specified value.
- CEILING.MATH Excel Function - Rounds a number up to the nearest integer or multiple of significance.
- CEILING.PRECISE Excel Function - Rounds a number up to the nearest integer or multiple of significance, regardless of sign.
- COMBIN Excel Function - Calculates the number of combinations for a given number of items.
- COMBINA Excel Function - Calculates the number of combinations for a given number of items.
- COMPLEX Excel Function - Creates a complex number from real and imaginary coefficients.
- COS Excel Function - Calculates the cosine of a given angle in radians.
- COSH Excel Function - Calculates the hyperbolic cosine of a number.
- COT Excel Function - Calculates the cotangent of an angle specified in radians.
- COTH Excel Function - Hyperbolic cotangent function.
- CSC Excel Function - CSC calculates the cosecant of an angle specified in radians.
- CSCH Excel Function - Hyperbolic cosecant function.
- DEGREES Excel Function - Converts radians to degrees.
- DELTA Excel Function - The DELTA function compares two numbers and returns 1 if they are equal or 0 if they are not.
- ERF Excel Function - ERF calculates the error function integrated between zero and a given value.
- ERF.PRECISE Excel Function - ERF.PRECISE calculates the error function with higher precision than the standard ERF function.
- ERFC Excel Function - Complementary error function.
- ERFC.PRECISE Excel Function - Calculates the complementary error function with higher precision.
- EXP Excel Function - Returns e raised to the power of a given number.
- EVEN Excel Function - Rounds a number up to the nearest even integer.
- FACT Excel Function - Calculates the factorial of a given number.
- FACTDOUBLE Excel Function - Calculates the double factorial of a number.
- FIXED Excel Function - Rounds a number to a specified number of decimals and formats it as text.
- FLOOR Excel Function - Rounds a number down to the nearest multiple of a specified significance.
- FLOOR.MATH Excel Function - Rounds a number down to the nearest integer or multiple of significance.
- FLOOR.PRECISE Excel Function - Rounds a number down to the nearest integer or multiple of specified significance, with greater precision than the FLOOR function.
- GAMMALN.PRECISE Excel Function - Calculates the natural logarithm of the gamma function with high precision.
- GCD Excel Function - Calculates the greatest common divisor of two or more integers.
- GESTEP Excel Function - GESTEP returns 1 if a number is greater than or equal to a specified threshold, otherwise 0.
- IMABS Excel Function - Returns the absolute value of a complex number.
- IMAGINARY Excel Function - Returns the imaginary coefficient of a complex number.
- IMARGUMENT Excel Function - Returns the argument theta of a complex number.
- IMCONJUGATE Excel Function - Returns the complex conjugate of a complex number.
- IMCOS Excel Function - Returns the cosine of a complex number.
- IMCOSH Excel Function - Calculates the hyperbolic cosine of a complex number.
- IMCOT Excel Function - Calculates the cotangent of a complex number.
- IMCSC Excel Function - Calculates the inverse cosecant (arccosecant) of a complex number.
- IMCSCH Excel Function - Calculates the hyperbolic cosecant of a complex number.
- IMDIV Excel Function - IMDIV calculates the division of two complex numbers in x+yi format.
- IMEXP Excel Function - Returns the exponential of a complex number.
- IMLN Excel Function - Returns the natural logarithm of a complex number.
- IMLOG10 Excel Function - Returns the base-10 logarithm of a complex number.
- IMLOG2 Excel Function - Calculates the base-2 logarithm of a complex number.
- IMPOWER Excel Function - IMPOWER calculates a complex number raised to a power.
- IMPRODUCT Excel Function - Calculates the product of complex numbers.
- IMREAL Excel Function - Extracts the real coefficient of a complex number.
- IMSEC Excel Function - IMSEC calculates the secant of a complex number.
- IMSECH Excel Function - IMSECH calculates the hyperbolic secant of a complex number.
- IMSIN Excel Function - IMSIN calculates the sine of a complex number.
- IMSINH Excel Function - Calculates the hyperbolic sine of a complex number.
- IMSQRT Excel Function - Returns the square root of a complex number.
- IMSUB Excel Function - IMSUB returns the difference between two complex numbers.
- IMSUM Excel Function - IMSUM adds complex numbers.
- IMTAN Excel Function - Calculates the tangent of a complex number.
- INT Excel Function - Rounds a number down to the nearest integer.
- ISEVEN Excel Function - Checks if a number is even.
- ISODD Excel Function - Checks if a number is odd.
- ISO.CEILING Excel Function - Rounds a number up to the nearest integer or multiple of significance.
- LCM Excel Function - Calculates the least common multiple of integers.
- LN Excel Function - Natural logarithm function.
- LOG Excel Function - Calculates the logarithm of a number to a specified base.
- LOG10 Excel Function - Calculates the base-10 logarithm of a number.
- MDETERM Excel Function - Calculates the determinant of a square matrix.
- MINVERSE Excel Function - Calculates the inverse matrix of a square matrix.
- MOD Excel Function - Returns the remainder after division.
- MROUND Excel Function - MROUND rounds a number to the nearest multiple of a specified value.
- MULTINOMIAL Excel Function - Calculates the probability of a specific combination of outcomes in a multinomial distribution.
- MUNIT Excel Function - Multiplies numbers and concatenates text.
- ODD Excel Function - Returns a number rounded up to the nearest odd integer.
- PERMUT Excel Function - Calculates the number of permutations for a given number of objects.
- PERMUTATIONA Excel Function - PERMUTATIONA calculates the number of permutations for a given number of objects (with repetitions allowed) from a total number of objects.
- PHI Excel Function - PHI returns the golden ratio (approximately 1.618033988749895).
- PI Excel Function - Returns the mathematical constant pi (3.14159...).
- POWER Excel Function - Calculates a number raised to a specified power.
- PRODUCT Excel Function - Multiplies all the numbers given as arguments and returns the product.
- RADIANS Excel Function - Converts degrees to radians.
- QUOTIENT Excel Function - Returns the integer portion of a division.
- RAND Excel Function - Generates a random decimal number between 0 and 1.
- ROMAN Excel Function - Converts an Arabic numeral to a Roman numeral as text.
- ROUND Excel Function - Rounds a number to a specified number of decimal places.
- ROUNDDOWN Excel Function - Rounds a number down to the nearest specified multiple.
- ROUNDUP Excel Function - Rounds a number up to the nearest integer or specified number of decimal places.
- SEC Excel Function - Calculates the secant of an angle specified in radians.
- SECH Excel Function - Hyperbolic secant function.
- SERIESSUM Excel Function - SERIESSUM calculates the sum of a power series based on a specified formula.
- SIGN Excel Function - Returns 1 if the number is positive, -1 if negative, or 0 if zero.
- SIN Excel Function - Calculates the sine of a given angle in radians.
- SINH Excel Function - Calculates the hyperbolic sine of a number.
- SQRT Excel Function - Calculates the square root of a number.
- SQRTPI Excel Function - Calculates the square root of (number * pi).
- SUBTOTAL Excel Function - Calculates aggregate values while ignoring filtered-out rows and other SUBTOTAL functions.
- SUM Excel Function - Calculates the total of a range of cells.
- SUMPRODUCT Excel Function - Multiplies corresponding components in given arrays and returns the sum of those products.
- SUMSQ Excel Function - Calculates the sum of the squares of a set of numbers.
- SUMX2MY2 Excel Function - Calculates the sum of the squares of the differences between corresponding values in two arrays.
- SUMXMY2 Excel Function - Calculates the sum of squares of differences between corresponding values in two arrays.
- TAN Excel Function - Calculates the tangent of a given angle in radians.
- TANH Excel Function - Hyperbolic tangent function.
Number and Base Conversion Functions
- ARABIC Excel Function - Converts Roman numerals to Arabic numerals.
- BASE Excel Function - Converts a number into a text representation with a given base.
- BIN2DEC Excel Function - Converts a binary number to its decimal equivalent.
- BIN2HEX Excel Function - Converts a binary number to hexadecimal.
- BIN2OCT Excel Function - Converts a binary number to octal.
- CONVERT Excel Function - Converts a number from one measurement system to another.
- DEC2BIN Excel Function - Converts a decimal number to binary.
- DEC2HEX Excel Function - Converts a decimal number to hexadecimal.
- DEC2OCT Excel Function - Converts a decimal number to octal format.
- DECIMAL Excel Function - Converts a text representation of a number in a specified base to a decimal number.
- DOLLAR Excel Function - Converts a number to text using currency format.
- HEX2BIN Excel Function - Converts a hexadecimal number to binary.
- HEX2DEC Excel Function - Converts a hexadecimal number to decimal.
- HEX2OCT Excel Function - Converts a hexadecimal number to octal.
- NUMBERVALUE Excel Function - Converts text to a number in a locale-independent manner.
- OCT2BIN Excel Function - Converts an octal number to binary.
- OCT2DEC Excel Function - Converts an octal number to decimal.
- OCT2HEX Excel Function - Converts an octal number to hexadecimal.
Statistical Functions
- AVEDEV Excel Function - AVEDEV calculates the average of the absolute deviations of data points from their mean.
- AVERAGE Excel Function - Calculates the arithmetic mean of a range of numbers.
- AVERAGEA Excel Function - AVERAGEA calculates the average of a range of cells, including text and logical values.
- AVERAGEIF Excel Function - Calculates the average of values in a range that meet specified criteria.
- AVERAGEIFS Excel Function - Calculates the average of cells that meet multiple specified criteria.
- BETA.DIST Excel Function - Calculates the cumulative beta probability density function or its probability density.
- BETA.INV Excel Function - The BETA.INV function calculates the inverse of the cumulative beta probability density function.
- BETADIST Excel Function - The BETADIST function calculates the cumulative beta probability density function.
- BETAINV Excel Function - BETAINV calculates the inverse of the cumulative beta probability density function.
- BINOM.DIST Excel Function - Calculates the individual term binomial distribution probability.
- BINOM.DIST.RANGE Excel Function - Calculates the probability of a specified range of successes in a binomial distribution.
- BINOM.INV Excel Function - Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified probability.
- BINOMDIST Excel Function - Calculates the individual term binomial distribution probability.
- CHIDIST Excel Function - Statistical function calculating the right-tailed probability of the chi-squared distribution.
- CHIINV Excel Function - The CHIINV function calculates the inverse of the right-tailed probability of the chi-squared distribution.
- CHISQ.DIST Excel Function - Calculates the cumulative distribution function of the chi-squared distribution.
- CHISQ.DIST.RT Excel Function - Calculates the right-tailed probability of the chi-square distribution.
- CHISQ.INV Excel Function - Calculates the inverse of the left-tailed probability of the chi-squared distribution.
- CHISQ.INV.RT Excel Function - Returns the inverse of the right-tailed probability of the chi-squared distribution.
- CHISQ.TEST Excel Function - Statistical function that calculates the chi-square test for independence.
- CHITEST Excel Function - Statistical hypothesis test comparing observed and expected frequencies.
- CONFIDENCE Excel Function - Calculates the confidence interval for a population mean.
- CONFIDENCE.NORM Excel Function - Calculates the confidence interval for a population mean using a normal distribution.
- CONFIDENCE.T Excel Function - Calculates the confidence interval for a population mean using Student's t-distribution.
- CORREL Excel Function - Calculates the correlation coefficient between two sets of values.
- COUNT Excel Function - COUNT returns the number of cells containing numbers in a range.
- COUNTA Excel Function - COUNTA counts the number of non-empty cells in a range.
- COUNTBLANK Excel Function - Counts empty cells in a specified range.
- COUNTIF Excel Function - COUNTIF counts cells that meet a specified criterion.
- COUNTIFS Excel Function - COUNTIFS counts cells across multiple ranges that meet multiple criteria.
- COVAR Excel Function - Calculates the covariance between two sets of data.
- COVARIANCE.P Excel Function - Calculates population covariance between two datasets.
- COVARIANCE.S Excel Function - Calculates the sample covariance between two datasets.
- CRITBINOM Excel Function - CRITBINOM calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified probability.
- DAVERAGE Excel Function - DAVERAGE calculates the average of values in a database that match specified criteria.
- DCOUNT Excel Function - DCOUNT counts cells containing numbers in a database or list that match specified criteria.
- DCOUNTA Excel Function - DCOUNTA counts cells containing numbers in a database or list that match specified criteria.
- DEVSQ Excel Function - Calculates the sum of squared deviations from the mean.
- DMAX Excel Function - DMAX returns the maximum value in a database or list that matches specified criteria.
- DMIN Excel Function - Returns the minimum value in a field of a database that meets specified criteria.
- DPRODUCT Excel Function - DPRODUCT calculates the product of values in a column of a list or database that match specified criteria.
- DSTDEV Excel Function - DSTDEV calculates the standard deviation of a population based on a sample.
- DSTDEVP Excel Function - Calculates the standard deviation of a population based on the entire population.
- DSUM Excel Function - DSUM calculates the sum of values in a database that match specified criteria.
- DVAR Excel Function - DVAR calculates the sample variance of a population based on specified criteria.
- DVARP Excel Function - DVARP calculates the population variance of selected database entries based on specified criteria.
- EXPON.DIST Excel Function - Calculates the exponential distribution for a given value.
- EXPONDIST Excel Function - The EXPONDIST function calculates the exponential distribution for a given value.
- F.INV Excel Function - Returns the inverse of the F probability distribution.
- F.INV.RT Excel Function - Calculates the inverse of the right-tailed F probability distribution.
- FISHER Excel Function - Calculates the Fisher transformation of a given value.
- FISHERINV Excel Function - FISHERINV returns the inverse of the Fisher transformation.
- FORECAST Excel Function - Predicts a future value based on existing values using linear regression.
- FORECAST.ETS Excel Function - Time series forecasting function that uses exponential smoothing algorithms to predict future values based on historical data.
- FORECAST.ETS.CONFINT Excel Function - The FORECAST.ETS.CONFINT function calculates the confidence interval for a forecasted value using exponential triple smoothing (ETS) algorithm in Excel.
- FORECAST.ETS.SEASONALITY Excel Function - FORECAST.ETS.SEASONALITY determines the length of the seasonal pattern in a time series for use in the FORECAST.ETS function.
- FORECAST.ETS.STAT Excel Function - FORECAST.ETS.STAT returns statistical values associated with a forecast generated using the Exponential Triple Smoothing (ETS) algorithm.
- FORECAST.LINEAR Excel Function - Predicts a future value based on existing linear trend data.
- FREQUENCY Excel Function - Calculates how often values occur within a range of values.
- FTEST Excel Function - Statistical function that returns the result of an F-test, comparing the variances of two data sets.
- FTEST Excel Function - Statistical function that returns the result of an F-test, comparing the variances of two data sets.
- GAMMA Excel Function - The GAMMA function calculates the gamma function value for a given number.
- GAMMA.DIST Excel Function - The GAMMA.DIST function calculates the gamma distribution for a given set of parameters.
- GAMMA.INV Excel Function - The GAMMA.INV function calculates the inverse of the gamma cumulative distribution.
- GAMMADIST Excel Function - The GAMMADIST function calculates the gamma distribution for a given set of parameters.
- GAMMAINV Excel Function - GAMMAINV calculates the inverse of the gamma cumulative distribution function.
- GAMMALN Excel Function - Calculates the natural logarithm of the gamma function for a given value.
- GAUSS Excel Function - GAUSS returns the Gaussian distribution for a specified mean and standard deviation.
- GEOMEAN Excel Function - Calculates the geometric mean of a set of positive numbers.
- GROWTH Excel Function - Calculates predicted exponential growth using existing data.
- HARMEAN Excel Function - Calculates the harmonic mean of a dataset.
- HYPGEOM.DIST Excel Function - Calculates the hypergeometric distribution probability.
- HYPGEOMDIST Excel Function - Calculates the hypergeometric distribution probability.
- INTERCEPT Excel Function - Calculates the y-intercept of a linear regression line.
- KURT Excel Function - KURT calculates the kurtosis of a dataset, measuring the "tailedness" of a distribution.
- LARGE Excel Function - Returns the k-th largest value in a data set.
- LINEST Excel Function - LINEST calculates the statistics for a line using the least squares method to calculate a straight line that best fits your data.
- LOGEST Excel Function - Calculates an exponential regression curve for a dataset.
- LOGINV Excel Function - Returns the inverse of the lognormal cumulative distribution function.
- LOGNORM.DIST Excel Function - Calculates the lognormal distribution for a given x-value.
- LOGNORM.INV Excel Function - The LOGNORM.INV function returns the inverse of the lognormal cumulative distribution.
- LOGNORMDIST Excel Function - Calculates the cumulative lognormal distribution of x.
- MAX Excel Function - Returns the largest value in a set of numbers.
- MAXA Excel Function - Returns the largest value in a list of arguments, including numbers, text, and logical values.
- MAXIFS Excel Function - MAXIFS returns the maximum value among cells that meet multiple criteria.
- MEDIAN Excel Function - Returns the median of a set of numbers.
- MIN Excel Function - Returns the smallest value in a set of numbers.
- MINA Excel Function - Returns the smallest value in a list of arguments, including numbers, text, and logical values.
- MINIFS Excel Function - MINIFS returns the minimum value among cells that meet multiple criteria.
- MODE Excel Function - Returns the most frequently occurring value in a dataset.
- MODE.MULT Excel Function - Returns an array of the most frequently occurring values in a dataset.
- MODE.SNGL Excel Function - Returns the most frequently occurring value in a dataset.
- N Excel Function - COUNT function that returns the number of cells containing numeric values.
- NEGBINOM.DIST Excel Function - Calculates the negative binomial distribution probability.
- NEGBINOMDIST Excel Function - Calculates the negative binomial distribution probability.
- NORM.DIST Excel Function - Calculates the normal distribution for a specified mean and standard deviation.
- NORM.INV Excel Function - Returns the inverse of the normal cumulative distribution for a specified mean and standard deviation.
- NORM.S.DIST Excel Function - Calculates the standard normal cumulative distribution function for a given value.
- NORM.S.INV Excel Function - Returns the inverse of the standard normal cumulative distribution.
- NORMDIST Excel Function - Calculates the normal distribution for a specified mean and standard deviation.
- NORMINV Excel Function - NORMINV calculates the inverse of the normal cumulative distribution for a specified probability, mean, and standard deviation.
- NORMSDIST Excel Function - Calculates the standard normal cumulative distribution function for a given value.
- NORMSINV Excel Function - Returns the inverse of the standard normal cumulative distribution.
- PEARSON Excel Function - Calculates the Pearson correlation coefficient between two datasets.
- PERCENTILE.EXC Excel Function - Calculates the k-th percentile of values in a range, where k is in the range 0<k<1, excluding 0 and 1.
- PERCENTILE.INC Excel Function - Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
- PERCENTILE Excel Function - Returns the k-th percentile of values in a range.
- PERCENTRANK.EXC Excel Function - Calculates the relative percentile rank of a value within a dataset, excluding the lowest and highest values.
- PERCENTRANK.INC Excel Function - Calculates the relative percentile rank of a value within a dataset, including the specified value.
- PERCENTRANK Excel Function - Calculates the relative percentile rank of a value within a dataset.
- POISSON.DIST Excel Function - Calculates the Poisson probability distribution for a given set of parameters.
- POISSON Excel Function - Calculates the Poisson probability distribution for a given set of parameters.
- PROB Excel Function - Calculates the probability that values in a range are between two limits.
- QUARTILE Excel Function - Returns the specified quartile of a dataset.
- QUARTILE.EXC Excel Function - Calculates quartiles for a dataset, excluding the minimum and maximum values.
- RANDBETWEEN Excel Function - Generates a random integer between two specified numbers.
- QUARTILE.INC Excel Function - Returns the specified quartile of a dataset, including the minimum and maximum values.
- RANK.AVG Excel Function - Returns the statistical rank of a value within a dataset, considering ties.
- RANK.EQ Excel Function - Returns the rank of a number within a list of numbers.
- RANK Excel Function - Returns the rank of a number within a list of numbers.
- RSQ Excel Function - Calculates the square of the Pearson product moment correlation coefficient for two data sets.
- SKEW Excel Function - Measures the asymmetry of a distribution around its mean.
- SKEW.P Excel Function - Calculates the skewness of a distribution based on an entire population.
- SLOPE Excel Function - Calculates the slope of a linear regression line through a set of data points.
- SMALL Excel Function - Returns the k-th smallest value in a data set.
- STANDARDIZE Excel Function - Converts a value to its standardized equivalent based on a distribution's mean and standard deviation.
- STDEV Excel Function - Calculates the standard deviation of a sample.
- STDEV.P Excel Function - Calculates the standard deviation of an entire population.
- STDEV.S Excel Function - Calculates the sample standard deviation of a dataset.
- STDEVA Excel Function - STDEVA calculates the standard deviation of a dataset, including text and logical values.
- STDEVP Excel Function - Calculates the standard deviation of an entire population.
- STDEVPA Excel Function - STDEVPA calculates the standard deviation of a population, including text and logical values.
- STEYX Excel Function - STEYX calculates the standard error of the predicted y-value for each x in a linear regression.
- SUMIF Excel Function - Conditionally sums values based on specified criteria.
- SUMIFS Excel Function - SUMIFS sums values based on multiple criteria.
- SUMX2PY2 Excel Function - Calculates the sum of squares for two arrays of values.
- T.DIST Excel Function - Calculates the Student's t-distribution probability density function or cumulative distribution function.
- T.DIST.2T Excel Function - Calculates the two-tailed Student's t-distribution probability.
- T.DIST.RT Excel Function - Right-tailed Student's t-distribution probability function.
- T.INV Excel Function - Returns the left-tailed inverse of the Student's t-distribution.
- TDIST Excel Function - The TDIST function calculates the probability for Student's t-distribution.
- T.INV.2T Excel Function - Returns the two-tailed inverse of Student's t-distribution.
- TINV Excel Function - Returns the t-value of the Student's t-distribution for a specified probability and degrees of freedom.
- TREND Excel Function - TREND calculates or predicts future values based on existing linear trend data.
- TRIMMEAN Excel Function - Calculates the mean of a dataset after removing a specified percentage of outliers from both ends.
Text Functions
- ASC Excel Function - Converts full-width (double-byte) characters to half-width (single-byte) characters.
- BAHTTEXT Excel Function - Converts a number to Thai text and adds a "Baht" currency denomination.
- CHAR Excel Function - Converts a numeric code to its corresponding character.
- CLEAN Excel Function - Removes non-printable characters from text.
- CODE Excel Function - The CODE function returns the numeric code for the first character in a text string.
- CONCAT Excel Function - Combines text from multiple cells into one cell.
- CONCATENATE Excel Function - Combines text from multiple cells into one cell.
- DBCS Excel Function - Converts half-width (single-byte) characters to full-width (double-byte) characters.
- ENCODEURL Excel Function - Converts text to a URL-encoded string.
- EXACT Excel Function - Case-sensitive text comparison function.
- FIND Excel Function - Locates a specific character or text string within another text string, returning its position.
- FILTERXML Excel Function - Extracts data from XML content using XPath expressions.
- FINDB Excel Function - Searches for a text string within another text string, returning the starting position of the found text, and is case-sensitive and designed for double-byte character languages.
- JIS Excel Function - JIS converts half-width characters to full-width characters in Japanese text.
- LEFTB Excel Function - Extracts a specified number of characters from the left side of a text string, based on bytes.
- LEFT Excel Function - Extracts a specified number of characters from the left side of a text string.
- LEN Excel Function - Counts the number of characters in a text string.
- LENB Excel Function - LENB returns the number of bytes used to represent characters in a text string.
- LOWER Excel Function - Converts text to lowercase.
- MID Excel Function - Extracts a specified number of characters from the middle of a text string.
- PHONETIC Excel Function - Returns a phonetic (Soundex) representation of a text string.
- REPLACE Excel Function - Replaces characters within text.
- PROPER Excel Function - Capitalizes the first letter of each word in a text string.
- REPLACEB Excel Function - Replaces bytes in a text string with a different text string.
- REPT Excel Function - REPT repeats text a specified number of times.
- SEARCH Excel Function - Case-insensitive text search function that returns the starting position of a substring within a string.
- RIGHT Excel Function - Extracts a specified number of characters from the right side of a text string.
- RIGHTB Excel Function - Extracts a specified number of characters from the right side of a text string, based on the number of bytes.
- SUBSTITUTE Excel Function - Replaces specific text within a string with new text.
- TEXT Excel Function - Converts numbers to text in a specified format.
- TRIM Excel Function - Removes leading, trailing, and excess spaces from text.
- TEXTJOIN Excel Function - Combines text from multiple ranges and/or strings, with a specified delimiter between each text value.
