Products

Documentation keyboard_arrow_right Formulas keyboard_arrow_right Functions

Available Excel-Like Formulas

Jspreadsheet Pro provides the most comprehensive JavaScript formula engine available. It can be used with Jspreadsheet or as a standalone solution, supporting both frontend and backend implementations for maximum flexibility across applications.

List of Available Formulas

We continuously work to expand formula support. Review the current implementation below. For security purposes, all formula references must use uppercase letters, including custom method implementations.

  • ABS: Returns the absolute value of a number.
  • ACCRINT: Returns the accrued interest for a security that pays periodic interest.
  • ACCRINTM: Returns the accrued interest for a security that pays interest at maturity.
  • ACOS: Returns the arccosine of a number, in radians.
  • ACOSH: Returns the inverse hyperbolic cosine of a number.
  • ACOT: Returns the arccotangent of a number, in radians.
  • ACOTH: Returns the inverse hyperbolic cotangent of a number.
  • ADD: Returns the sum of two numbers.
  • ADDRESS: Returns a cell reference as a string, given row and column numbers, and an optional flag indicating whether the reference should be absolute or relative.
  • AGGREGATE: Returns an aggregate calculation on a range of cells, such as AVERAGE, COUNT, MAX, MIN, etc. with the option to ignore hidden rows and error values.
  • AMORDEGRC: Returns the depreciation for an accounting period, based on the fixed-rate declining balance method.
  • AMORLINC: Returns the depreciation for an accounting period, based on the straight-line method.
  • AND: Returns TRUE if all its arguments evaluate to TRUE; returns FALSE if one or more arguments evaluates to FALSE.
  • ARABIC: Converts a Roman numeral to an Arabic numeral.
  • AREAS: Returns the number of areas in a reference.
  • ARRAYTOTEXT: Converts an array into a delimited text string.
  • ASC: Convert full-width characters to half-width characters.
  • ASIN: Returns the inverse sine of a number, in radians.
  • ASINH: Returns the inverse hyperbolic sine of a number.
  • ATAN: Returns the arctangent of a number, in radians.
  • ATAN2: Returns the arctangent of the specified x- and y-coordinates, in radians.
  • ATANH: Returns the inverse hyperbolic tangent of a number.
  • AVEDEV: Returns the average of the absolute deviations of data points from their mean.
  • AVERAGE: Returns the average (arithmetic mean) of the arguments.
  • AVERAGEA: Returns the average (arithmetic mean) of the arguments, including numbers, text, and logical values.
  • AVERAGEIF: Returns the average (arithmetic mean) of all cells in a range that meet a specified criteria.
  • AVERAGEIFS: Returns the average (arithmetic mean) of all cells in a range that meet multiple specified criteria.
  • BAHTTEXT: Converts a number to Thai text and adds a suffix of 'Baht' for currency.
  • BASE: Converts a number from decimal to binary, octal, or hexadecimal numbering systems.
  • BESSELI: Returns the modified Bessel function of the first kind, I(x), for a given number x.
  • BESSELJ: Returns the Bessel function of the first kind, J(x), for a given real or complex number x.
  • BESSELK: Returns the modified Bessel function of the second kind, K(x), for a given real or complex number x.
  • BESSELY: Returns the Bessel function of the second kind, Y(x), for a given positive real number x.
  • BETA.DIST: Returns the cumulative beta probability density function.
  • BETA.INV: Returns the inverse of the cumulative beta probability density function.
  • BETADIST: Returns the cumulative beta probability density function.
  • BETAINV: Returns the inverse of the cumulative beta probability density function.
  • BIN2DEC: Converts a binary number to decimal.
  • BIN2HEX: Converts a binary number to hexadecimal.
  • BIN2OCT: Converts a binary number to octal.
  • BINOM.DIST.RANGE: Calculates the probability of achieving a certain number of successes within a particular range of trials using the binomial distribution.
  • BINOM.DIST: Returns the individual term binomial distribution probability.
  • BINOM.INV: Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
  • BINOMDIST: Returns the individual term binomial distribution probability.
  • BITAND: Returns a bitwise 'AND' of two numbers.
  • BITLSHIFT: Shifts bits to the left, padding with zeroes on the right.
  • BITOR: Returns a bitwise 'OR' of two numbers.
  • BITRSHIFT: Shifts bits to the right, padding with zeroes on the left.
  • BITXOR: Returns a bitwise 'XOR' of two numbers.
  • BYCOL: Applies a lambda function to each column of a range and returns an array of the results.
  • BYROW: Returns a reference to a range that is a specified number of rows above or below a starting range.
  • CALL: Calls a macro from a module or run a function.
  • CEILING.MATH: Rounds a number up to the nearest multiple of a specified significance, regardless of the sign of the number.
  • CEILING.PRECISE: Rounds a number up to the nearest multiple of a specified significance, using bankers' rounding (round half up).
  • CEILING: Rounds a number up to the nearest multiple of a specified value.
  • CELL: Returns information about the formatting, location, or contents of a cell.
  • CHAR: Returns the character specified by a number.
  • CHIDIST: Returns the one-tailed probability of the chi-squared distribution.
  • CHIINV: Returns the inverse of the one-tailed probability of the chi-squared distribution.
  • CHISQ.DIST.RT: Returns the one-tailed probability of the chi-squared distribution.
  • CHISQ.DIST: Returns the one-tailed probability of the chi-squared distribution.
  • CHISQ.INV.RT: Returns the inverse of the one-tailed probability of the chi-squared distribution.
  • CHISQ.INV: Returns the inverse of the one-tailed probability of the chi-squared distribution.
  • CHISQ.TEST: Returns the test for independence.
  • CHITEST: Compares the observed and expected frequencies of categories in a contingency table to determine whether there is a significant association between the variables.
  • CHOOSE: Returns a value from a list of values based on its position in the list.
  • CHOOSECOLS: Returns a range of columns selected from a table based on their position in the table.
  • CHOOSEROWS: Returns a range of rows selected from a table based on their position in the table.
  • CLEAN: Removes all nonprintable characters from a text string.
  • CODE: Returns a numeric code for the first character in a text string.
  • COLUMN: Returns the column number of a reference.
  • COLUMNS: Returns the number of columns in a range or array.
  • COMBIN: Returns the number of combinations for a given number of items.
  • COMBINA: Returns the number of combinations with repetitions for a given number of items.
  • COMPLEX: Converts real and imaginary coefficients into a complex number in x + yi or x + yj text format.
  • CONCAT: Joins two or more text strings into one string.
  • CONCATENATE: Joins two or more text strings into one string.
  • CONFIDENCE.NORM: Returns the confidence interval for a population mean, using a normal distribution.
  • CONFIDENCE.T: Returns the confidence interval for a population mean, using a Student's t-distribution.
  • CONFIDENCE: Returns the confidence interval for a population mean.
  • CONVERT: Converts a number from one measurement system to another.
  • CORREL: Returns the correlation coefficient between two data sets.
  • COS: Returns the cosine of an angle provided in radians.
  • COSH: Returns the hyperbolic cosine of a number.
  • COT: Returns the cotangent of an angle provided in radians.
  • COTH: Returns the hyperbolic cotangent of a number.
  • COUNT: Counts the number of cells in a range that contain numbers.
  • COUNTA: Counts the number of cells in a range that are not empty.
  • COUNTBLANK: Counts the number of empty cells in a range.
  • COUNTIF: Counts the number of cells in a range that meet a specified criterion.
  • COUNTIFS: Counts the number of cells in a range that meet multiple specified criteria.
  • COUNTUNIQUE: Returns the number of unique values in a range of cells.
  • COUPDAYBS: Calculates the number of days from the beginning of the coupon period to the settlement date for a security that pays interest on a bond that has an odd first period.
  • COUPDAYS: Calculates the number of days in the coupon period that contains the settlement date for a security that pays periodic interest.
  • COUPDAYSNC: Calculates the number of days from the settlement date to the next coupon date for a security that pays periodic interest, but has an irregular first coupon period.
  • COUPNCD: Calculates the next coupon date after the settlement date for a security that pays periodic interest.
  • COUPNUM: Calculates the number of coupon payments between the settlement date and the maturity date for a security that pays periodic interest.
  • COUPPCD: Calculates the previous coupon date before the settlement date for a security that pays periodic interest.
  • COVAR: Calculates the covariance, which is a measure of how much two random variables change together, between two specified sets of data.
  • COVARIANCE.P: Calculates the population covariance, which is a measure of how much two random variables change together, between two specified sets of data.
  • COVARIANCE.S: Calculates the sample covariance, which is an estimate of how much two random variables change together, between two specified sets of data.
  • CRITBINOM: Calculates the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
  • CSC: Calculates the cosecant of an angle given in radians.
  • CSCH: Calculates the hyperbolic cosecant of an angle given in radians.
  • CUBEKPIMEMBER: Returns the value of a key performance indicator (KPI) and the name of the KPI in the cube.
  • CUBEMEMBER: Returns a member or tuple from a cube.
  • CUBEMEMBERPROPERTY: Returns the value of a member property from the cube.
  • CUBERANKEDMEMBER: Returns the nth ranked member from a set in a cube.
  • CUBESET: Defines a calculated set of members or tuples by sending a set expression to the cube on the specified connection.
  • CUBESETCOUNT: Returns the number of items in a set.
  • CUBEVALUE: Returns the value of a cell in a cube, as calculated by a Multidimensional Expressions (MDX) query.
  • CUMIPMT: Returns the cumulative interest paid on a loan between two periods.
  • CUMPRINC: Returns the cumulative principal paid on a loan between two periods.
  • DATE: Returns the date based on a year, month, and day.
  • DATEDIF: Calculates the difference between two dates based on the specified interval.
  • DATEVALUE: Converts a text string that represents a date to a serial number that Excel recognizes as a date.
  • DAVERAGE: Returns the average of selected database entries based on specified criteria.
  • DAY: Returns the day of the month as a number (1-31) for a given date.
  • DAYS: Calculates the number of days between two dates.
  • DAYS360: Calculates the number of days between two dates using a 360-day year.
  • DB: Calculates the depreciation of an asset for a specified period using the fixed-declining balance method.
  • DBCS: Checks whether a text string contains double-byte characters, which are used in some languages such as Japanese and Chinese.
  • DCOUNT: Counts the number of cells in a database that meet specified criteria.
  • DCOUNTA: Counts the number of non-blank cells in a database that meet specified criteria.
  • DDB: Calculates the depreciation of an asset for a specified period using the double-declining balance method.
  • DEC2BIN: Converts a decimal number to binary format.
  • DEC2HEX: Converts a decimal number to hexadecimal format.
  • DEC2OCT: Converts a decimal number to octal format.
  • DECIMAL: Converts a text representation of a number in a given base into a decimal number.
  • DEGREES: Converts radians to degrees.
  • DELTA: Tests whether two values are equal. Returns 1 if the values are equal, or 0 otherwise.
  • DEVSQ: Calculates the sum of squares of deviations from the mean of a dataset.
  • DGET: Extracts a single value from a database table-like array based on specified criteria.
  • DISC: Calculates the discount rate for a security based on its price, face value, and coupon rate.
  • DIVIDE: Returns the result of dividing two numbers.
  • DMAX: Returns the maximum value from a database table-like array based on specified criteria.
  • DMIN: Returns the minimum value from a database table-like array based on specified criteria.
  • DOLLAR: Converts a number to text using currency format with the specified number of decimal places.
  • DOLLARDE: Converts a fractional dollar price expressed as a decimal to a fraction using the specified denominator.
  • DOLLARFR: Converts a fraction to a decimal dollar value using the specified denominator.
  • DPRODUCT: Returns the product of values selected from a database table-like array based on specified criteria.
  • DROP: Removes a specified number of rows and columns from a given array, starting from the top-left corner.
  • DSTDEV: The DSTDEV function calculates the standard deviation of a population based on a sample of that population.
  • DSTDEVP: The DSTDEVP function calculates the standard deviation of a population.
  • DSUM: The DSUM function adds the numbers in a column or database that meet specified criteria.
  • DURATION: Calculates the Macaulay duration of a security with an assumed par value of $100.
  • DVAR: The DVAR function estimates variance based on a sample from selected database entries.
  • DVARP: The DVARP function calculates the variance of a population.
  • EDATE: The EDATE function returns the date that is the specified number of months before or after the start date.
  • EFFECT: Calculates the effective annual interest rate given the nominal annual interest rate and the number of compounding periods per year.
  • ENCODEURL: Encodes a text string for use as a valid part of a URL.
  • EOMONTH: The EOMONTH function returns the last day of the month that is a specified number of months before or after a given date.
  • EQ: Returns TRUE if two values are equal.
  • ERF.PRECISE: Returns the error function of a number, accurate to approximately 15 digits.
  • ERF: Returns the error function of a number.
  • ERFC.PRECISE: Returns the complementary error function of a number, which is equal to 1 minus the error function of the same number. The result is accurate to approximately 15 digits.
  • ERFC: Returns the complementary error function of a number, which is equal to 1 minus the error function of the same number.
  • ERROR.TYPE: Returns a number that corresponds to the error value in a cell.
  • EUROCONVERT: Converts a number from one currency to another.
  • EVEN: Rounds a number up to the nearest even integer.
  • EXACT: Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. The comparison is case-sensitive.
  • EXP: Returns the value of e raised to a given power.
  • EXPAND: Expands a range of cells into individual cells.
  • EXPON.DIST: Returns the exponential distribution for a specified set of parameters.
  • EXPONDIST: Returns the exponential distribution for a specified set of parameters.
  • F.DIST.RT: Returns the right-tailed F probability distribution.
  • F.DIST: Returns the cumulative distribution function of the F-distribution.
  • F.INV.RT: Returns the inverse of the right-tailed F probability distribution.
  • F.INV: Returns the inverse of the F probability distribution.
  • F.TEST: Returns the result of an F-test, which returns the one-tailed probability that the variances in two data sets are not significantly different.
  • FACT: Returns the factorial of a number.
  • FACTDOUBLE: Returns the factorial of a number, multiplied by the factorial of number-2.
  • FALSE: Returns the logical value 'FALSE'.
  • FDIST: Returns the cumulative distribution function of the F-distribution.
  • FILTER: Returns an array filtered by a set of criteria.
  • FILTERXML: Returns specific data from XML content by using an XPath string.
  • FIND: Returns the position of a string within another, allowing for case sensitivity. Search starts from the left-hand side of the string.
  • FINDB: Returns the position of a string within another, allowing for case sensitivity. Search starts from the right-hand side of the string.
  • FINV: Returns the inverse of the F probability distribution for a specified probability and degrees of freedom.
  • FISHER: Returns the Fisher transformation of a specified value.
  • FISHERINV: Returns the inverse of the Fisher transformation on a specified value.
  • FIXED: Rounds a number to the specified number of digits and formats the result with a fixed number of decimal places.
  • FLOOR.MATH: Rounds a number down to the nearest integer or to the nearest multiple of a specified factor.
  • FLOOR.PRECISE: Rounds a number down to the nearest integer or to the nearest multiple of a specified factor, based on a specified significance.
  • FLOOR: Rounds a number down to the nearest multiple of a specified factor.
  • FORECAST.ETS.CONFINT: Calculates the lower and upper bounds of the confidence interval for a predicted value by using the Exponential Smoothing (ETS) algorithm.
  • FORECAST.ETS.SEASONALITY: Returns the length of the seasonal pattern detected in time series data using the Exponential Smoothing (ETS) algorithm.
  • FORECAST.ETS.STAT: Calculates statistical values for the Exponential Smoothing (ETS) algorithm applied to a time series data set.
  • FORECAST.ETS: Calculates or predicts a future value based on existing (historical) values by using the Exponential Smoothing (ETS) algorithm.
  • FORECAST.LINEAR: Calculates or predicts a future value based on linear regression of a data set.
  • FORECAST: Calculates or predicts a future value by using linear regression.
  • FORMULATEXT: Returns the formula in a cell as text.
  • FREQUENCY: Calculates how often values occur within a range of values, and then returns a vertical array of numbers.
  • FTEST: Returns the result of an F-test, which returns the two-tailed probability that the variances in two data sets are equal.
  • FV: Calculates the future value of an investment based on a constant interest rate and periodic, constant payments.
  • FVSCHEDULE: Calculates the future value of an initial principal after applying a series of compound interest rates.
  • GAMMA.DIST: Calculates the gamma distribution, which is a continuous probability distribution that describes the shape of data that has positive skewness and a long right tail.
  • GAMMA.INV: Calculates the inverse of the gamma cumulative distribution function for a specified probability and parameter values.
  • GAMMA: Calculates the gamma function, which is a generalization of the factorial function to real and complex numbers.
  • GAMMADIST: Calculates the gamma distribution, which is a continuous probability distribution that describes the shape of data that has positive skewness and a long right tail.
  • GAMMAINV: Calculates the inverse of the gamma cumulative distribution function for a specified probability and parameter values.
  • GAMMALN.PRECISE: Calculates the natural logarithm of the gamma function, which is a generalization of the factorial function to real and complex numbers, using a more precise algorithm than GAMMALN.
  • GAMMALN: Calculates the natural logarithm of the gamma function, which is a generalization of the factorial function to real and complex numbers.
  • GAUSS: Returns the probability that a random variable follows a standard normal distribution.
  • GCD: Returns the greatest common divisor of two or more integers.
  • GEOMEAN: Returns the geometric mean of an array or range of positive numeric data.
  • GESTEP: Returns a numeric value indicating whether a number is greater than a threshold value, 1 for TRUE, 0 for FALSE.
  • GETPIVOTDATA: Returns data stored in a PivotTable report. The data can be returned as a summary report or as a list report.
  • GROWTH: Returns an array of y-values generated by evaluating an exponential curve that fits the data points.
  • GT: Determines whether the first value is greater than the second.
  • GTE: Determines whether the first value is greater than or equal to the second.
  • HARMEAN: Returns the harmonic mean of a data set.
  • HEX2BIN: Converts a hexadecimal number to binary.
  • HEX2DEC: Converts a hexadecimal number to decimal.
  • HEX2OCT: Converts a hexadecimal number to octal.
  • HLOOKUP: Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify.
  • HOUR: Returns the hour component of a specific time, in numeric format.
  • HSTACK: Horizontally stacks values from multiple arrays into a single array.
  • HYPERLINK: Creates a clickable link that opens a webpage, document, or email address.
  • HYPGEOM.DIST: The HYPGEOM.DIST function is used to calculate the probability of a specified number of successes in a population sample, given the population size, number of successes in the population, and sample size.
  • HYPGEOMDIST: The HYPGEOMDIST function is used to calculate the probability of a specified number of successes in a population sample, given the population size, number of successes in the population, and sample size.
  • IF: Performs a logical test and returns one value if the condition is true, and another value if the condition is false.
  • IFERROR: Returns a value if a formula results in an error, and another value if it does not.
  • IFNA: Returns a value if a formula returns the #N/A error, and another value if it does not.
  • IFS: Evaluates multiple conditions and returns a value that corresponds to the first true condition.
  • IMABS: The IMABS function is used to return the absolute value (magnitude) of a complex number.
  • IMAGINARY: The IMAGINARY function is used to return the imaginary coefficient of a complex number.
  • IMARGUMENT: The IMARGUMENT function is used to return the argument (phase angle) of a complex number in radians.
  • IMCONJUGATE: The IMCONJUGATE function is used to return the complex conjugate of a complex number.
  • IMCOS: The IMCOS function is used to return the cosine of a complex number.
  • IMCOSH: The IMCOSH function is used to return the hyperbolic cosine of a complex number.
  • IMCOT: Returns the cotangent of a complex number in x + yi or x + yj text format.
  • IMCSC: Calculates the cosecant of a complex number.
  • IMCSCH: Calculates the inverse hyperbolic cosecant of a complex number.
  • IMDIV: Returns the quotient of two complex numbers.
  • IMEXP: Returns the exponential of a complex number.
  • IMLN: Returns the natural logarithm of a complex number.
  • IMLOG10: Returns the base-10 logarithm of a complex number.
  • IMLOG2: Returns the base-2 logarithm of a complex number.
  • IMPOWER: Returns a complex number raised to a power.
  • IMPRODUCT: Returns the product of complex numbers.
  • IMREAL: Returns the real coefficient of a complex number.
  • IMSEC: Returns the secant of a complex number.
  • IMSECH: Returns the hyperbolic secant of a complex number.
  • IMSIN: Returns the sine of a complex number.
  • IMSINH: Returns the hyperbolic sine of a complex number.
  • IMSQRT: Returns the square root of a complex number.
  • IMSUB: Returns the difference between two complex numbers.
  • IMSUM: Returns the sum of complex numbers.
  • IMTAN: Returns the tangent of a complex number.
  • INDEX: Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.
  • INDIRECT: Returns the reference specified by a text string.
  • INFO: Returns information about the current operating environment, such as the version of Excel and the operating system.
  • INT: Returns the integer part of a number by rounding down to the nearest integer.
  • INTERCEPT: Returns the y-axis intercept of a line defined by a set of x- and y-values.
  • INTRATE: Returns the interest rate for a fully invested security.
  • IPMT: Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
  • IRR: Calculates the internal rate of return for a series of cash flows that occur at regular intervals.
  • ISBETWEEN: Returns true if a value is between a lower and upper bound, inclusive.
  • ISBLANK: Returns TRUE if a specified cell is empty, and FALSE otherwise.
  • ISERR: Returns TRUE if a value is any error value except #N/A, and FALSE otherwise.
  • ISERROR: Returns TRUE if a value is any error value, and FALSE otherwise.
  • ISEVEN: Checks if a given number is even and returns TRUE if the number is even, and FALSE otherwise.
  • ISFORMULA: Checks if a given cell contains a formula and returns TRUE if the cell contains a formula, and FALSE otherwise.
  • ISLOGICAL: Checks if a given value is a logical value (TRUE or FALSE) and returns TRUE if the value is a logical value, and FALSE otherwise.
  • ISNA: Checks if a given value is the error value #N/A and returns TRUE if the value is #N/A, and FALSE otherwise.
  • ISNONTEXT: Checks if a given value is not text (any non-textual value) and returns TRUE if the value is not text, and FALSE otherwise.
  • ISNUMBER: Checks if a given value is a number and returns TRUE if the value is a number, and FALSE otherwise.
  • ISO.CEILING: Rounds a number up to the nearest integer or to the nearest multiple of a specified significance, and returns a result that is on the ISO list of paper sizes.
  • ISODD: Checks if a given number is odd and returns TRUE if the number is odd, and FALSE otherwise.
  • ISOMITTED: Checks if a parameter in a formula is omitted and returns TRUE if the parameter is omitted, and FALSE otherwise.
  • ISOWEEKNUM: Returns the ISO week number for a given date as an integer between 1 and 53, where week 1 is the week containing January 4.
  • ISPMT: Calculates the interest payment for a given period of an investment based on a constant interest rate.
  • ISREF: Checks if a given value is a valid cell reference and returns TRUE if the value is a valid cell reference, and FALSE otherwise.
  • ISTEXT: Checks if a given value is text and returns TRUE if the value is text, and FALSE otherwise.
  • JIS: Converts a number to text in the JIS (Japanese Industrial Standards) format.
  • KURT: Returns the kurtosis of a data set, which is a measure of the peakedness or flatness of the distribution, relative to the normal distribution.
  • LAMBDA: Allows you to define custom functions using a lambda expression, which is a shorthand way of defining anonymous functions.
  • LARGE: Returns the k-th largest value in a range or array of numbers.
  • LCM: Returns the least common multiple of one or more integers. The least common multiple is the smallest positive integer that is a multiple of each integer in a given set.
  • LEFT: Returns a specified number of characters from the beginning (left side) of a text string.
  • LEFTB: Returns a specified number of bytes from the beginning (left side) of a text string.
  • LEN: Returns the number of characters in a text string.
  • LENB: Returns the number of bytes in a text string.
  • LET: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula.
  • LINEST: Calculates the statistics for a line by fitting a straight line to a set of known data points using the least squares method.
  • LN: Returns the natural logarithm of a number.
  • LOG: Returns the logarithm of a number to a specified base.
  • LOG10: Returns the base-10 logarithm of a number.
  • LOGEST: Calculates an exponential curve that fits a set of data and returns an array of values that describes the curve.
  • LOGINV: Returns the inverse of the lognormal cumulative distribution function with a specified mean and standard deviation.
  • LOGNORM.DIST: Returns the cumulative log-normal distribution for a specified value, mean, and standard deviation.
  • LOGNORM.INV: Returns the inverse of the cumulative log-normal distribution for a specified probability, mean, and standard deviation.
  • LOGNORMDIST: Returns the cumulative log-normal distribution for a specified value, mean, and standard deviation.
  • LOOKUP: Searches for a value in a range or array and returns a value in the same position from a second range or array.
  • LOWER: Converts all uppercase letters in a text string to lowercase.
  • LT: Determines whether the first value is less than the second.
  • LTE: Determines whether the first value is less than or equal to the second.
  • MAKEARRAY: Creates an array of specified dimensions and fills it with either a specified value or no value.
  • MAP: Applies a formula or function to every cell in a range and returns the results as a new array.
  • MATCH: Searches for a specified value in a range of cells, and returns the relative position of that value within the range.
  • MAX: Returns the largest value in a range of cells.
  • MAXA: Returns the largest value in a range of cells or an array.
  • MAXIFS: Returns the largest number in a range of cells that meets multiple criteria.
  • MDETERM: Returns the matrix determinant of a square matrix.
  • MDURATION: Returns the Macauley duration of a security with an assumed par value of $100.
  • MEDIAN: Returns the median value in a range of numbers.
  • MID: Returns a specific number of characters from a text string starting at the position you specify.
  • MIDB: Returns a specific number of bytes from a text string starting at the position you specify.
  • MIN: Returns the smallest number in a set of values, including numbers, arrays, and references.
  • MINA: Returns the smallest value in a list of supplied arguments, including numbers, arrays, and references.
  • MINIFS: Returns the smallest number among numbers that meet multiple criteria.
  • MINUS: Returns the difference between two numbers or cells.
  • MINUTE: Returns the minute of a time value. The minute is given as an integer, ranging from 0 to 59.
  • MINVERSE: Returns the matrix inverse of an array.
  • MIRR: Returns the modified internal rate of return for a series of periodic cash flows, considering both cost of investment and interest on reinvestment of cash.
  • MMULT: Returns the matrix product of two arrays.
  • MOD: Returns the remainder after a number is divided by a divisor.
  • MODE.MULT: Returns an array of the most frequently occurring values in a range of data.
  • MODE.SNGL: Returns the most frequently occurring value in a range of data. If multiple values occur equally frequently, the function returns the first one found.
  • MODE: Returns the most frequently occurring value in a range of data.
  • MONTH: Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).
  • MROUND: Rounds a number to the nearest multiple of another number.
  • MULTINOMIAL: Returns the multivariate factorial, which is the product of factorials of a series of numbers.
  • MULTIPLY: Returns the product of two numbers.
  • MUNIT: Returns the Unit matrix for a given size.
  • N: Returns a value converted to a number.
  • NA: Returns the error value #N/A which means "value not available" or "no value exists".
  • NE: Returns TRUE if the first value is not equal to the second value.
  • NEGBINOM.DIST: Returns the negative binomial distribution, which is the probability that there will be Number_f failures before the Number_s-th success, with Probability_s probability of a success.
  • NEGBINOMDIST: Returns the negative binomial distribution, which is the probability that there will be k failures before the rth success, with probability p of success.
  • NETWORKDAYS.INTL: Returns the number of whole workdays between start_date and end_date using parameters to indicate which and how many days are weekend days, and a given set of holidays.
  • NETWORKDAYS: Returns the number of whole workdays between start_date and end_date using parameters to indicate which and how many days are weekend days.
  • NOMINAL: Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.
  • NORM.DIST: Returns the probability density function or the cumulative distribution function for a specified normal distribution.
  • NORM.INV: Returns the inverse of the normal cumulative distribution for a specified mean and standard deviation.
  • NORM.S.DIST: Returns the standard normal cumulative distribution function.
  • NORM.S.INV: Returns the inverse of the standard normal cumulative distribution.
  • NORMDIST: Returns the normal distribution for the specified mean and standard deviation.
  • NORMINV: Returns the inverse of the normal cumulative distribution for a specified mean and standard deviation.
  • NORMSDIST: Returns the standard normal cumulative distribution function.
  • NORMSINV: Returns the inverse of the standard normal cumulative distribution.
  • NOT: Returns the opposite of a logical value, i.e., returns true if the value is false, and false if the value is true.
  • NOW: Returns the current date and time as a date/time value.
  • NPER: Calculates the number of payment periods for an investment based on a constant interest rate and periodic payments.
  • NPV: Calculates the net present value of an investment based on a series of future cash flows and a discount rate.
  • NUMBERVALUE: Converts text to a number in a locale-independent way.
  • OCT2BIN: Converts an octal number to binary.
  • OCT2DEC: Converts an octal number to decimal.
  • OCT2HEX: Converts an octal number to hexadecimal.
  • ODD: Rounds a number up to the nearest odd integer.
  • ODDFPRICE: Calculates the price per $100 face value of a security with an odd first period.
  • ODDFYIELD: Calculates the yield of a security with an odd first period.
  • ODDLPRICE: Calculates the price per $100 face value of a security with an odd last period.
  • ODDLYIELD: Calculates the yield of a security with an odd last period.
  • OFFSET: Returns a reference to a range that is offset from a starting cell or range.
  • OR: Returns true if any argument is true, and false otherwise.
  • PDURATION: Calculates the duration of a security with periodic interest payments.
  • PEARSON: Returns the Pearson product moment correlation coefficient between two data sets.
  • PERCENTILE.EXC: Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
  • PERCENTILE.INC: Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
  • PERCENTILE: Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive. If the data set has a small sample size or if k = 0 or k = 1, use PERCENTILE.INC instead.
  • PERCENTRANK.EXC: Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
  • PERCENTRANK.INC: Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set.
  • PERCENTRANK: Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set. If the data set has a small sample size, use PERCENTRANK.INC instead.
  • PERMUT: Returns the number of permutations for a given number of objects that can be selected from a set.
  • PERMUTATIONA: Returns the number of permutations for a given number of objects that can be selected from a set with repetition.
  • PHI: Returns the value of the standard normal cumulative distribution function (CDF) for a specified value.
  • PHONETIC: Returns the phonetic (furigana) representation of a text string.
  • PI: Returns the mathematical constant pi, accurate to 15 digits.
  • PMT: Calculates the payment for a loan based on constant payments and a constant interest rate.
  • POISSON.DIST: Returns the Poisson distribution, which is a statistical measure that shows how many times an event is likely to occur within a specified period of time.
  • POISSON: Calculates the Poisson distribution probability mass function.
  • POW: Returns the result of raising a number to a power.
  • POWER: Returns the result of a number raised to a power.
  • PPMT: Calculates the payment on the principal for a given investment based on constant-amount periodic payments and a constant interest rate.
  • PRICE: Returns the price per $100 face value of a security with an annual coupon rate.
  • PRICEDISC: Returns the price per $100 face value of a discounted security.
  • PRICEMAT: Returns the price per $100 face value of a security that pays interest at maturity.
  • PROB: Returns the probability of an outcome occurring given a range of values and associated probabilities.
  • PRODUCT: Returns the product of all values in a given range of cells.
  • PROPER: Capitalizes the first letter of each word in a text string and sets all other letters to lowercase.
  • PV: Calculates the present value of an investment or loan based on a constant interest rate and future payments or receipts.
  • QUARTILE.EXC: Calculates the exclusive quartile of a dataset, which is a value that separates the lowest 25% from the highest 75% of values. This function uses a slightly different calculation than the QUARTILE function.
  • QUARTILE.INC: Calculates the inclusive quartile of a dataset, which is a value that separates the lowest 25% from the highest 75% of values. This function uses a slightly different calculation than the QUARTILE function.
  • QUARTILE: Calculates the quartile of a dataset, which is a value that separates the lowest 25% from the highest 75% of values.
  • QUOTIENT: Returns the integer portion of a division operation. It discards the remainder and returns only the whole number that divides evenly into the dividend.
  • RADIANS: Converts degrees into radians. One radian is equal to the angle made at the center of a circle by an arc whose length is equal to the radius of the circle.
  • RAND: Generates a random decimal number between 0 and 1. The value of the number changes each time the worksheet is calculated or when the function is recalculated by pressing F9.
  • RANDARRAY: Generates an array of random numbers within a specified range or format.
  • RANDBETWEEN: Generates a random integer between two specified numbers (inclusive). The value of the number changes each time the worksheet is calculated or when the function is recalculated by pressing F9.
  • RANK.AVG: Returns the rank of a specified value in a dataset, with ties receiving an average rank. The returned rank is based on the order of values in the array or range, with the largest value receiving a rank of 1.
  • RANK.EQ: Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. If more than one value has the same rank, the average rank is returned.
  • RANK: Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. If two or more values have the same rank, the highest rank is assigned to all of them and the next rank(s) is skipped.
  • RATE: Returns the interest rate per period of an annuity.
  • RECEIVED: Returns the amount received at maturity for a fully invested security.
  • REDUCE: Reduces an array to an accumulated value by applying a LAMBDA function to each value and returning the total value in the accumulator.
  • REGEXEXTRACT: Extracts parts of a text using a regular expression.
  • REGEXMATCH: Determines whether a text matches a regular expression.
  • REGEXREPLACE: Replaces parts of a text using a regular expression.
  • REGISTER.ID: Generates an ID number for a specified entity or object.
  • REPLACE: Replaces a sequence of characters in a string with another set of characters.
  • REPLACEB: Replaces a sequence of bytes in a string with another set of bytes.
  • REPT: Repeats a text string a specified number of times.
  • RIGHT: Returns a specified number of characters from the end of a text string.
  • RIGHTB: Returns a specified number of bytes from the end of a text string.
  • ROMAN: Converts an Arabic numeral to a Roman numeral.
  • ROUND: Rounds a number to a specified number of digits.
  • ROUNDDOWN: Rounds a number down to a specified number of digits.
  • ROUNDUP: Rounds a number up to a specified number of digits.
  • ROW: Returns the row number of a reference.
  • ROWS: Returns the number of rows in a range or array.
  • RRI: Calculates the interest rate of a fully invested security.
  • RSQ: Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's.
  • RTD: Retrieves real-time data from a program that supports COM automation.
  • SCAN: Applies a calculation to each element in an array and returns an accumulated result based on the values in the array.
  • SEARCH: Returns the starting position of a text string within another text string, starting from the leftmost character. If the text is not found, returns #VALUE!. This function is case-insensitive.
  • SEARCHB: Returns the starting position of a text string within another text string, starting from the leftmost character. If the text is not found, returns #VALUE!. This function is case-insensitive and considers double-byte characters as separate characters.
  • SEC: Returns the secant of an angle specified in radians.
  • SECH: Returns the hyperbolic secant of a number.
  • SECOND: Returns the seconds of a time value.
  • SEQUENCE: Returns an array of sequential numbers with a given length and step value.
  • SERIESSUM: Returns the sum of a power series based on the formula
  • SHEET: Returns the sheet number of a reference.
  • SHEETS: Returns the number of sheets in a reference.
  • SIGN: Returns the sign of a number: 1 if the number is positive, -1 if negative, and 0 if zero.
  • SIN: Returns the sine of an angle in radians.
  • SINGLE: Returns the value from a range that shares the same column or row as the reference cell.
  • SINH: Returns the hyperbolic sine of a number.
  • SKEW.P: Returns the population skewness of a distribution, which is a measure of asymmetry.
  • SKEW: Returns the skewness of a distribution, which is a measure of asymmetry.
  • SLN: Returns the straight-line depreciation of an asset for a single period.
  • SLOPE: Returns the slope of a linear regression line that best fits a data set.
  • SMALL: Returns the k-th smallest value in a data set.
  • SORT: Returns a sorted range or array.
  • SORTBY: Sorts a range or array based on the values in another range or array.
  • SPLIT: Splits a text string into a table of substrings based on a delimiter.
  • SQRT: Returns the positive square root of a number.
  • SQRTPI: Returns the positive square root of a number multiplied by pi (\u03c0).
  • STANDARDIZE: Returns a normalized value (z-score) given a value, a population mean, and a standard deviation.
  • STDEV.P: Calculates the standard deviation of an entire population.
  • STDEV.S: Estimates the standard deviation of a population based on a sample of numbers.
  • STDEV: Estimates the standard deviation of a population based on a sample of numbers.
  • STDEVA: Estimates the standard deviation of a population based on a sample of numbers, including text and logical values.
  • STDEVP: Calculates the standard deviation of an entire population, including text and logical values.
  • STDEVPA: Estimates the standard deviation of an entire population, including text and logical values.
  • STEYX: Calculates the standard error of the predicted y-value for each x in a regression.
  • STOCKHISTORY: Returns historical stock prices for a given date range and ticker symbol.
  • SUBSTITUTE: Replaces a specified occurrence of text in a string with another text.
  • SUBTOTAL: Returns a subtotal for a range using a specified aggregation function.
  • SUM: Returns the sum of a range of numbers or cells.
  • SUMIF: Returns the sum of a range of cells that meet a specified criteria.
  • SUMIFS: Returns the sum of a range of cells that meet multiple specified criteria.
  • SUMPRODUCT: Returns the sum of the products of corresponding ranges or arrays.
  • SUMSQ: Returns the sum of the squares of a range of numbers or cells.
  • SUMX2MY2: Returns the sum of the difference of squares of corresponding values in two arrays or ranges.
  • SUMX2PY2: Returns the sum of the sum of squares of corresponding values in two arrays or ranges.
  • SUMXMY2: Returns the sum of the squares of differences of corresponding values in two arrays or ranges.
  • SWITCH: Evaluates an expression against a list of cases and returns the result corresponding to the first matching case.
  • SYD: Returns the straight-line depreciation of an asset for a specific period using the sum-of-years digits method.
  • T.DIST.2T: Returns the two-tailed Student's t-distribution.
  • T.DIST.RT: Returns the right-tailed Student's t-distribution.
  • T.DIST: Returns the left-tailed Student's t-distribution.
  • T.INV.2T: Returns the inverse of the two-tailed probability of a Student's t-distribution.
  • T.INV: Returns the inverse of the one-tailed probability of a Student's t-distribution.
  • T.TEST: Returns the probability associated with a Student's t-test.
  • T: Returns the text referred to by a value. If the value is text, T returns that value. If the value is not text, T returns an empty string.
  • TAKE: Returns a specified number of rows or columns from the start or end of an array.
  • TAN: Returns the tangent of an angle specified in radians.
  • TANH: Returns the hyperbolic tangent of a number.
  • TBILLEQ: Calculates the bond-equivalent yield for a Treasury bill based on a discount from face value.
  • TBILLPRICE: Calculates the price per $100 face value for a Treasury bill.
  • TBILLYIELD: Calculates the yield of a Treasury bill based on its price.
  • TDIST: Calculates the probability of a Student's t-distribution with a given input value.
  • TEXT: Converts a value to text in a specified number format.
  • TEXTAFTER: Returns the substring of text after a specified character or string.
  • TEXTBEFORE: Returns the substring of text before a specified character or string.
  • TEXTJOIN: Joins together text strings with a specified delimiter.
  • TEXTSPLIT: Splits a text string into an array of substrings based on specified delimiters.
  • TIME: Returns a decimal value representing a specific time.
  • TIMEVALUE: Converts a text string representing a time into a decimal value.
  • TINV: Returns the inverse of the Student's t-distribution as a two-tailed probability.
  • TOCOL: Converts an array into a single-column array.
  • TODAY: Returns the current date as a serial number.
  • TOROW: Converts an array into a single-row array.
  • TRANSPOSE: Returns a transposed range of cells.
  • TREND: Returns values along a linear trend.
  • TRIM: Removes all spaces from text except for single spaces between words.
  • TRIMMEAN: Returns the mean of the interior of a data set, based on a percentage you specify.
  • TRUE: Returns the logical value TRUE.
  • TRUNC: Truncates a number to a specified number of decimal places by removing the fractional part of the number.
  • TTEST: Returns the probability associated with a Student's t-test.
  • TYPE: Returns a number representing the data type of a value.
  • UMINUS: Returns the negation of a number.
  • UNARY_PERCENT: Converts a number into a percentage fraction by dividing it by 100.
  • UNICHAR: Returns the Unicode character that is referenced by the given numeric value.
  • UNICODE: Returns the Unicode value of the first character in a text string.
  • UNIQUE: Returns a list of unique values in a range or array.
  • UPLUS: Returns the specified number, unchanged.
  • UPPER: Converts all lowercase letters in a text string to uppercase.
  • VALUE: Converts a text string that represents a number to a number.
  • VALUETOTEXT: Converts a value to its textual representation in the number format of the current language and optionally with a specified format.
  • VAR.P: Calculates the variance based on an entire population.
  • VAR.S: Calculates the variance based on a sample. Provides an unbiased estimate of the population variance.
  • VAR: Estimates the variance based on a sample.
  • VARA: Estimates the variance based on a sample, including numbers, text, and logical values.
  • VARP: Calculates the variance based on an entire population. Provides a precise measure of how far the values in a population vary from the population mean.
  • VARPA: Calculates the variance based on an entire population, including numbers, and logical values.
  • VDB: Calculates the depreciation of an asset for a specific period using the double-declining balance method or other methods that you specify.
  • VLOOKUP: Searches for a value in the first column of a table or range of cells, and then returns a value in the same row from a column you specify.
  • VSTACK: Stacks values from multiple ranges vertically into a single column.
  • WEBSERVICE: Retrieves data from a web service on the internet or intranet.
  • WEEKDAY: Returns the day of the week corresponding to a given date.
  • WEEKNUM: Returns the week number of a given date.
  • WEIBULL.DIST: Returns the Weibull distribution, which is often used in reliability analysis.
  • WEIBULL: Returns the Weibull distribution, which is often used in reliability analysis.
  • WORKDAY.INTL: Returns the date that is the indicated number of working days before or after a date (the starting date), excluding weekends and holidays.
  • WORKDAY: Returns the date that is the indicated number of working days before or after a date (the starting date).
  • WRAPCOLS: Wraps the text in a cell based on the number of columns specified.
  • WRAPROWS: Wraps the text in a cell based on the number of rows specified.
  • XIRR: Returns the internal rate of return for a series of cash flows, taking into account both the time value of money and the irregular intervals between cash flows.
  • XLOOKUP: Searches a range or an array for a specified value and returns a corresponding value in the same position from another range or array.
  • XMATCH: Searches for a specified item in a range of cells, and returns the relative position of that item within the range.
  • XNPV: Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.
  • XOR: Returns a logical exclusive OR of all arguments.
  • YEAR: Returns the year corresponding to a given date.
  • YEARFRAC: Returns the fraction of a year between two dates, represented as a decimal value.
  • YIELD: Returns the yield on a security that pays periodic interest, based on its price and the interest rate.
  • YIELDDISC: Returns the annual yield of a discounted security, based on its price and face value.
  • YIELDMAT: Returns the yield of a security that pays interest at maturity, based on its price and face value.
  • Z.TEST: Returns the probability of a one-tailed, two-sample z-test.
  • ZTEST: Returns the probability of a one-tailed, one-sample z-test.

Edit this page on GitHub