ApiWorksheetFunction

Name	Description
ABS	Returns the absolute value of a number, a number without its sign.
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 in the range 0 to Pi. The arccosine is the angle whose cosine is Number.
ACOSH	Returns the inverse hyperbolic cosine of a number.
ACOT	Returns the arccotangent of a number, in radians in the range 0 to Pi..
ACOTH	Returns the inverse hyperbolic cotangent of a number.
AGGREGATE	Returns an aggregate in a list or database.
AMORDEGRC	Returns the prorated linear depreciation of an asset for each accounting period..
AMORLINC	Returns the prorated linear depreciation of an asset for each accounting period..
AND	Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE.
ARABIC	Converts a Roman numeral to Arabic.
ASC	For double-byte character set (DBCS) languages, the function changes full-width (double-byte) characters to half-width (single-byte) characters.
ASIN	Returns the arcsine of a number in radians, in the range -Pi/2 to Pi/2.
ASINH	Returns the inverse hyperbolic sine of a number.
ATAN	Returns the arctangent of a number in radians, in the range -Pi/2 to Pi/2.
ATAN2	Returns the arctangent of the specified x and y coordinates, in radians between -Pi and Pi, excluding -Pi.
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 specified arguments.
AVERAGEA	Returns the average (arithmetic mean) of the specified arguments, evaluating text and false in arguments as 0; true evaluates as 1.
AVERAGEIF	Finds the average (arithmetic mean) for the cells specified by a given condition or criteria.
AVERAGEIFS	Finds the average (arithmetic mean) for the cells specified by a given set of conditions or criteria.
BASE	Converts a number into a text representation with the given radix (base).
BESSELI	Returns the modified Bessel function In(x).
BESSELJ	Returns the Bessel function Jn(x).
BESSELK	Returns the modified Bessel function Kn(x).
BESSELY	Returns the Bessel function Yn(x).
BETADIST	Returns the cumulative beta probability density function.
BETAINV	Returns the inverse of the cumulative beta probability density function for a specified beta distribution (BETADIST).
BETA_DIST	Returns the beta probability distribution function.
BETA_INV	Returns the inverse of the cumulative beta probability density function (BETA_DIST).
BIN2DEC	Converts a binary number to decimal.
BIN2HEX	Converts a binary number to hexadecimal.
BIN2OCT	Converts a binary number to octal.
BINOMDIST	Returns the individual term binomial distribution probability.
BINOM_DIST	Returns the individual term binomial distribution probability.
BINOM_DIST_RANGE	Returns the probability of a trial result using a binomial distribution.
BINOM_INV	Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
BITAND	Returns a bitwise 'And' of two numbers.
BITLSHIFT	Returns a number shifted left by shift_amount bits.
BITOR	Returns a bitwise 'Or' of two numbers.
BITRSHIFT	Returns a number shifted right by shift_amount bits.
BITXOR	Returns a bitwise 'Exclusive Or' of two numbers.
CEILING	Rounds a number up, to the nearest multiple of significance.
CEILING_MATH	Rounds a number up, to the nearest integer or to the nearest multiple of significance.
CEILING_PRECISE	Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.
CHAR	Returns the character specified by the code number from your computer's character set.
CHIDIST	Returns the right-tailed probability of the chi-squared distribution.
CHIINV	Returns the inverse of the right-tailed probability of the chi-squared distribution.
CHISQ_DIST	Returns the left-tailed probability of the chi-squared distribution.
CHISQ_DIST_RT	Returns the right-tailed probability of the chi-squared distribution.
CHISQ_INV	Returns the inverse of the left-tailed probability of the chi-squared distribution.
CHISQ_INV_RT	Returns the inverse of the right-tailed probability of the chi-squared distribution.
CHITEST	Returns the test for independence: the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.
CHOOSE	Chooses a value or action to perform from a list of values, based on an index number.
CLEAN	Removes all the nonprintable characters from the text.
CODE	Returns the code number from your computer's character set for the first character in the specified text string.
COLUMNS	Returns the number of columns in an array or reference.
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.
CONCATENATE	Combines multiple text strings into one text string.
CONFIDENCE	Returns the confidence interval for a population mean, using a normal distribution.
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.
CONVERT	Converts a number from one measurement system to another.
COS	Returns the cosine of an angle.
COSH	Returns the hyperbolic cosine of a number.
COT	Returns the cotangent of an angle.
COTH	Returns the hyperbolic cotangent of a number.
COUNT	Counts a number of cells in a range that contains numbers ignoring empty cells or those contaning text.
COUNTA	Counts a number of cells in a range that are not empty.
COUNTBLANK	Counts a number of empty cells in a specified range of cells.
COUNTIF	Counts a number of cells within a range that meet the given condition.
COUNTIFS	Counts a number of cells specified by a given set of conditions or criteria.
COUPDAYBS	Returns the number of days from the beginning of the coupon period to the settlement date.
COUPDAYS	Returns the number of days in the coupon period that contains the settlement date.
COUPDAYSNC	Returns the number of days from the settlement date to the next coupon date.
COUPNCD	Returns the next coupon date after the settlement date.
COUPNUM	Returns the number of coupons payable between the settlement date and maturity date.
COUPPCD	Returns the previous coupon date before the settlement date.
CRITBINOM	Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
CSC	Returns the cosecant of an angle.
CSCH	Returns the hyperbolic cosecant of an angle.
CUMIPMT	Returns the cumulative interest paid between two periods.
CUMPRINC	Returns the cumulative principal paid on a loan between two periods.
DATE	Returns a number that represents the date in the date-time code.
DATEVALUE	Converts a date in the form of text to a number that represents the date in the date-time code.
DAVERAGE	Averages the values in a column in a list or database that match conditions you specify.
DAY	Returns the day of the date given in the numerical format, a number from 1 to 31.
DAYS	Returns the number of days between the two dates.
DAYS360	Returns the number of days between two dates based on a 360-day year (twelve 30-day months).
DB	Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
DCOUNT	Counts the cells containing numbers in the field (column) of records in the database that match the conditions you specify.
DCOUNTA	Counts nonblank cells in the field (column) of records in the database that match the conditions you specify.
DDB	Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.
DEC2BIN	Converts a decimal number to binary.
DEC2HEX	Converts a decimal number to hexadecimal.
DEC2OCT	Converts a decimal number to octal.
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 numbers are equal.
DEVSQ	Returns the sum of squares of deviations of data points from their sample mean.
DGET	Extracts from a database a single record that matches the conditions you specify.
DISC	Returns the discount rate for a security.
DMAX	Returns the largest number in the field (column) of records in the database that match the conditions you specify.
DMIN	Returns the smallest number in the field (column) of records in the database that match the conditions you specify.
DOLLAR	Converts a number to text, using a currency format $#.##.
DOLLARDE	Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.
DOLLARFR	Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.
DPRODUCT	Multiplies the values in the field (column) of records in the database that match the conditions you specify.
DSTDEV	Estimates the standard deviation based on a sample from selected database entries.
DSTDEVP	Calculates the standard deviation based on the entire population of selected database entries.
DSUM	Adds the numbers in the field (column) of records in the database that match the conditions you specify.
DURATION	Returns the annual duration of a security with periodic interest payments.
DVAR	Estimates variance based on a sample from selected database entries.
DVARP	Calculates variance based on the entire population of selected database entries.
ECMA_CEILING	Rounds the number up to the nearest multiple of significance.
EDATE	Returns the serial number of the date which comes the indicated number of months before or after the start date.
EFFECT	Returns the effective annual interest rate.
EOMONTH	Returns the serial number of the last day of the month before or after a specified number of months.
ERF	Returns the error function.
ERFC	Returns the complementary error function.
ERFC_PRECISE	Returns the complementary error function.
ERF_PRECISE	Returns the error function.
ERROR_TYPE	Returns a number matching an error value..
EVEN	Rounds a positive number up and negative number down to the nearest even integer.
EXACT	Checks whether two text strings are exactly the same, and returns true or false. This function is case-sensitive.
EXP	Returns e raised to the power of a given number.
EXPONDIST	Returns the exponential distribution.
EXPON_DIST	Returns the exponential distribution.
FACT	Returns the factorial of a number, equal to 123... Number.
FACTDOUBLE	Returns the double factorial of a number.
FALSE	Returns the logical value FALSE.
FDIST	Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets.
FIND	Returns the starting position of one text string within another text string. This function is case-sensitive.
FINDB	Finds the specified substring within another string and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.
FINV	Returns the inverse of the (right-tailed) F probability distribution: if p = FDIST(x,...), then FINV(p,...) = x.
FISHER	Returns the Fisher transformation.
FISHERINV	Returns the inverse of the Fisher transformation: if y = FISHER(x), then FISHERINV(y) = x.
FIXED	Rounds a number to the specified number of decimals and returns the result as text with or without commas.
FLOOR	Rounds a number down to the nearest multiple of significance.
FLOOR_MATH	Rounds a number down, to the nearest integer or to the nearest multiple of significance.
FLOOR_PRECISE	Returns a number that is rounded down to the nearest integer or to the nearest multiple of significance.
FORECAST_ETS	Сalculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm.
FORECAST_ETS_CONFINT	Returns a confidence interval for the forecast value at the specified target date.
FORECAST_ETS_SEASONALITY	Returns the length of the repetitive pattern an application detects for the specified time series.
FORECAST_ETS_STAT	Returns the requested statistic for the forecast.
FREQUENCY	Calculates how often values occur within a range of values and then returns the first value of the returned vertical array of numbers.
FV	Returns the future value of an investment based on periodic, constant payments and a constant interest rate.
FVSCHEDULE	Returns the future value of an initial principal after applying a series of compound interest rates.
F_DIST	Returns the (left-tailed) F probability distribution (degree of diversity) for two data sets.
F_DIST_RT	Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets.
F_INV	Returns the inverse of the (left-tailed) F probability distribution: if p = F.DIST(x,...), then F.INV(p,...) = x.
F_INV_RT	Returns the inverse of the (right-tailed) F probability distribution: if p = F.DIST.RT(x,...), then F.INV.RT(p,...) = x.
GAMMA	Returns the gamma function value.
GAMMADIST	Returns the gamma distribution.
GAMMAINV	Returns the inverse of the gamma cumulative distribution: if p = GAMMADIST(x,...), then GAMMAINV(p,...) = x.
GAMMALN	Returns the natural logarithm of the gamma function.
GAMMALN_PRECISE	Returns the natural logarithm of the gamma function.
GAMMA_DIST	Returns the gamma distribution.
GAMMA_INV	Returns the inverse of the gamma cumulative distribution: if p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x.
GAUSS	Calculates the probability that a member of a standard normal population will fall between the mean and arg1 standard deviations from the mean.
GCD	Returns the greatest common divisor.
GEOMEAN	Returns the geometric mean of an array or range of positive numeric data.
GESTEP	Tests whether a number is greater than a threshold value.
GROWTH	Calculates predicted exponential growth by using existing data.
HARMEAN	Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals.
HEX2BIN	Converts a Hexadecimal number to binary.
HEX2DEC	Converts a hexadecimal number to decimal.
HEX2OCT	Converts a hexadecimal number to octal.
HLOOKUP	Looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify.
HOUR	Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.)..
HYPERLINK	Creates a shortcut or jump that opens a document stored on your hard drive, a network server, or on the Internet.
HYPGEOMDIST	Returns the hypergeometric distribution.
HYPGEOM_DIST	Returns the hypergeometric distribution.
IF	Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.
IFERROR	Returns value_if_error if expression is an error and the value of the expression itself otherwise.
IFNA	Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.
IMABS	Returns the absolute value (modulus) of a complex number.
IMAGINARY	Returns the imaginary coefficient of a complex number.
IMARGUMENT	Returns the argument q, an angle expressed in radians.
IMCONJUGATE	Returns the complex conjugate of a complex number.
IMCOS	Returns the cosine of a complex number.
IMCOSH	Returns the hyperbolic cosine of a complex number.
IMCOT	Returns the cotangent of a complex number.
IMCSC	Returns the cosecant of a complex number.
IMCSCH	Returns the 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 an integer power.
IMPRODUCT	Returns the product of 1 to 255 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 of 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.
INT	Rounds a number down to the nearest integer.
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	Returns the internal rate of return for a series of cash flows.
ISERR	Checks whether a value is an error other than #N/A, and returns TRUE or FALSE.
ISERROR	Checks whether a value is an error, and returns TRUE or FALSE.
ISEVEN	Returns TRUE if the number is even.
ISFORMULA	Checks whether a reference is to a cell containing a formula, and returns TRUE or FALSE.
ISLOGICAL	Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE.
ISNA	Checks whether a value is #N/A, and returns TRUE or FALSE.
ISNONTEXT	Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE.
ISNUMBER	Checks whether a value is a number, and returns TRUE or FALSE.
ISODD	Returns TRUE if the number is odd.
ISOWEEKNUM	Returns the ISO week number in the year for a given date.
ISO_CEILING	Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance regardless of the sign of the number. However, if the number or the significance is zero, zero is returned..
ISPMT	Returns the interest paid during a specific period of an investment.
ISREF	Checks whether a value is a reference, and returns TRUE or FALSE.
ISTEXT	Checks whether a value is text, and returns TRUE or FALSE.
KURT	Returns the kurtosis of a data set.
LARGE	Returns the k-th largest value in a data set. For example, the fifth largest number.
LCM	Returns the least common multiple.
LEFT	Returns the specified number of characters from the start of a text string.
LEFTB	Extracts the substring from the specified string starting from the left character and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.
LEN	Returns the number of characters in a text string.
LENB	Analyses the specified string and returns the number of characters it contains and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.
LINEST	Returns statistics that describe a linear trend matching known data points, by fitting a straight line using the least squares method.
LN	Returns the natural logarithm of a number.
LOG	Returns the logarithm of a number to the base you specify.
LOG10	Returns the base-10 logarithm of a number.
LOGEST	Returns statistics that describe an exponential curve matching known data points.
LOGINV	Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with the specified parameters.
LOGNORMDIST	Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with the specified parameters.
LOGNORM_DIST	Returns the lognormal distribution of x, where ln(x) is normally distributed with the specified parameters.
LOGNORM_INV	Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with the specified parameters.
LOOKUP	Looks up a value either from a one-row or one-column range or from an array. Provided for backwards compatibility.
LOWER	Converts all letters in a text string to lowercase.
MATCH	Returns the relative position of an item in an array that matches a specified value in a specified order.
MAX	Returns the largest value in a set of values. Ignores logical values and text.
MAXA	Returns the largest value in a set of values. Does not ignore logical values and text.
MDURATION	Returns the Macauley modified duration for a security with an assumed par value of $100.
MEDIAN	Returns the median, or the number in the middle of the set of given numbers.
MID	Returns the characters from the middle of a text string, given a starting position and length.
MIDB	Extracts the characters from the specified string starting from any position and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.
MIN	Returns the smallest number in a set of values. Ignores logical values and text.
MINA	Returns the smallest value in a set of values. Does not ignore logical values and text.
MINUTE	Returns the minute, a number from 0 to 59..
MIRR	Returns the internal rate of return for a series of periodic cash flows, considering both cost of investment and interest on reinvestment of cash.
MOD	Returns the remainder after a number is divided by a divisor.
MONTH	Returns the month, a number from 1 (January) to 12 (December)..
MROUND	Returns a number rounded to the desired multiple.
MULTINOMIAL	Returns the multinomial of a set of numbers.
MUNIT	Returns the unit matrix for the specified dimension.
N	Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero).
NA	Returns the error value #N/A (value not available).
NEGBINOMDIST	Returns the negative binomial distribution, the probability that there will be the specified number of failures before the last success, with the specified probability of a success.
NEGBINOM_DIST	Returns the negative binomial distribution, the probability that there will be the specified number of failures before the last success, with the specified probability of a success.
NETWORKDAYS	Returns the number of whole workdays between two dates.
NETWORKDAYS_INTL	Returns the number of whole workdays between two dates with custom weekend parameters.
NOMINAL	Returns the annual nominal interest rate.
NORMDIST	Returns the normal cumulative distribution for the specified mean and standard deviation.
NORMINV	Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORMSDIST	Returns the standard normal cumulative distribution (has a mean of zero and a standard deviation of one).
NORMSINV	Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one).
NORM_DIST	Returns the normal distribution for the specified mean and standard deviation.
NORM_INV	Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORM_S_DIST	Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
NORM_S_INV	Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one).
NOT	Changes FALSE to TRUE, or TRUE to FALSE.
NOW	Returns the current date and time formatted as a date and time..
NPER	Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
NPV	Returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values).
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 positive number up and negative number down to the nearest odd integer.
ODDFPRICE	Returns the price per $100 face value of a security with an odd first period.
ODDFYIELD	Returns the yield of a security with an odd first period.
ODDLPRICE	Returns the price per $100 face value of a security with an odd last period.
ODDLYIELD	Returns the yield of a security with an odd last period.
OR	Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE.
PDURATION	Returns the number of periods required by an investment to reach a specified value.
PERCENTILE	Returns the k-th percentile of values in a range.
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.
PERCENTRANK	Returns the rank of a value in a data set as a percentage of the data set.
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.
PERMUT	Returns the number of permutations for a given number of objects that can be selected from the total objects.
PERMUTATIONA	Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.
PHI	Returns the value of the density function for a standard normal distribution.
PI	Returns the value of Pi, 3.14159265358979, accurate to 15 digits.
PMT	Calculates the payment for a loan based on constant payments and a constant interest rate.
POISSON	Returns the Poisson distribution.
POISSON_DIST	Returns the Poisson distribution.
POWER	Returns the result of a number raised to a power.
PPMT	Returns the payment on the principal for a given investment based on periodic, constant payments and a constant interest rate.
PRICE	Returns the price per $100 face value of a security that pays periodic interest.
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.
PRODUCT	Multiplies all the numbers given as arguments.
PROPER	Converts a text string to proper case: the first letter in each word to uppercase, and all other letters to lowercase.
PV	Returns the present value of an investment: the total amount that a series of future payments is worth now.
QUARTILE	Returns the quartile of a data set.
QUARTILE_EXC	Returns the quartile of a data set, based on percentile values from 0..1, exclusive.
QUARTILE_INC	Returns the quartile of a data set, based on percentile values from 0..1, inclusive.
QUOTIENT	Returns the integer portion of a division.
RADIANS	Converts degrees to radians.
RAND	Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation).
RANDBETWEEN	Returns a random number between the numbers you specify.
RANK	Returns the rank of a number in a list of numbers: its size relative to other values in the list.
RANK_AVG	Returns the rank of a number in a list of numbers: its size relative to other values in the list. If more than one value has the same rank, the average rank is returned.
RANK_EQ	Returns the rank of a number in a list of numbers: its size relative to other values in the list. If more than one value has the same rank, the top rank of that set of values is returned.
RATE	Returns the interest rate per period of a loan or an investment. For example, use 6%/4 for quarterly payments at 6% APR.
RECEIVED	Returns the amount received at maturity for a fully invested security.
REPLACE	Replaces part of a text string with a different text string.
REPLACEB	Replaces a set of characters, based on the number of characters and the start position specified, with a new set of characters and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.
REPT	Repeats text a given number of times. Use this function to fill a cell with a number of instances of a text string.
RIGHT	Returns the specified number of characters from the end of a text string.
RIGHTB	Extracts a substring from a string starting from the right-most character, based on the specified number of characters and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.
ROMAN	Converts an Arabic numeral to Roman, as text.
ROUND	Rounds a number to a specified number of digits.
ROUNDDOWN	Rounds a number down, towards zero.
ROUNDUP	Rounds a number up, away from zero.
ROWS	Returns the number of rows in a reference or array.
RRI	Returns an equivalent interest rate for the growth of an investment.
SEARCH	Returns the number of the character at which a specific character or text string is first found, reading left to right (not case-sensitive).
SEARCHB	Returns the location of the specified substring in a string and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.
SEC	Returns the secant of an angle.
SECH	Returns the hyperbolic secant of an angle.
SECOND	Returns the second, a number from 0 to 59..
SERIESSUM	Returns the sum of a power series based on the formula.
SHEET	Returns the sheet number of the referenced sheet.
SHEETS	Returns the number of sheets in a reference.
SIGN	Returns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative.
SIN	Returns the sine of an angle.
SINH	Returns the hyperbolic sine of a number.
SKEW	Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution around its mean.
SKEW_P	Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean.
SLN	Returns the straight-line depreciation of an asset for one period.
SMALL	Returns the k-th smallest value in a data set. For example, the fifth smallest number.
SQRT	Returns the square root of a number.
SQRTPI	Returns the square root of (number * Pi).
STANDARDIZE	Returns a normalised value from a distribution characterised by a mean and standard deviation.
STDEV	Estimates standard deviation based on a sample (ignores logical values and text in the sample).
STDEVA	Estimates standard deviation based on a sample, including logical values and text. Text and the false logical value have the value 0; the true logical value has the value 1.
STDEVP	Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).
STDEVPA	Calculates standard deviation based on an entire population, including logical values and text. Text and the false logical value have the value 0; the true logical value has the value 1.
STDEV_P	Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).
STDEV_S	Estimates standard deviation based on a sample (ignores logical values and text in the sample).
SUBSTITUTE	Replaces existing text with new text in a text string.
SUBTOTAL	Returns a subtotal in a list or database.
SUM	Adds all the numbers in a range of cells.
SUMIF	Adds the cells specified by a given condition or criteria.
SUMIFS	Adds the cells specified by a given set of conditions or criteria.
SUMSQ	Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names or references to cells that contain numbers.
SYD	Returns the sum-of-years' digits depreciation of an asset for a specified period.
T	Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not.
TAN	Returns the tangent of an angle.
TANH	Returns the hyperbolic tangent of a number.
TBILLEQ	Returns the bond-equivalent yield for a treasury bill.
TBILLPRICE	Returns the price per $100 face value for a treasury bill.
TBILLYIELD	Returns the yield for a treasury bill.
TDIST	Returns the Student's t-distribution.
TEXT	Converts a value to text in a specific number format.
TIME	Converts hours, minutes and seconds given as numbers to a serial number, formatted with a time format.
TIMEVALUE	Converts a text time to a serial number for a time, a number from 0 (12:00:00 AM) to 0.999988426 (11:59:59 PM). Format the number with a time format after entering the formula.
TINV	Returns the two-tailed inverse of the Student's t-distribution.
TODAY	Returns the current date formatted as a date..
TRANSPOSE	Converts a vertical range of cells to a horizontal range, or vice versa.
TREND	Returns numbers in a linear trend matching known data points, using the least squares method.
TRIM	Removes all spaces from a text string except for single spaces between words.
TRIMMEAN	Returns the mean of the interior portion of a set of data values.
TRUE	Returns the logical value TRUE.
TRUNC	Truncates a number to an integer by removing the decimal, or fractional, part of the number.
TYPE	Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; array = 64; compound data = 128.
T_DIST	Returns the left-tailed Student's t-distribution.
T_DIST_2T	Returns the two-tailed Student's t-distribution.
T_DIST_RT	Returns the right-tailed Student's t-distribution.
T_INV	Returns the left-tailed inverse of the Student's t-distribution.
T_INV_2T	Returns the two-tailed inverse of the Student's t-distribution.
UNICHAR	Returns the Unicode character referenced by the given numeric value.
UNICODE	Returns the number (code point) corresponding to the first character of the text.
UPPER	Converts a text string to all uppercase letters.
VALUE	Converts a text string that represents a number to a number.
VAR	Estimates variance based on a sample (ignores logical values and text in the sample).
VARA	Estimates variance based on a sample, including logical values and text. Text and the false logical value have the value 0; the true logical value has the value 1.
VARP	Calculates variance based on the entire population (ignores logical values and text in the population).
VARPA	Calculates variance based on the entire population, including logical values and text. Text and the false logical value have the value 0; the true logical value has the value 1.
VAR_P	Calculates variance based on the entire population (ignores logical values and text in the population).
VAR_S	Estimates variance based on a sample (ignores logical values and text in the sample).
VDB	Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify.
VLOOKUP	Looks for a value in the leftmost column of a table and then returns a value in the same row from a column that you specify. By default, the table must be sorted in an ascending order.
WEEKDAY	Returns a number from 1 to 7 identifying the day of the week of a date..
WEEKNUM	Returns the week number in the year.
WEIBULL	Returns the Weibull distribution.
WEIBULL_DIST	Returns the Weibull distribution.
WORKDAY	Returns the serial number of the date before or after a specified number of workdays.
WORKDAY_INTL	Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters.
XIRR	Returns the internal rate of return for a schedule of cash flows.
XNPV	Returns the net present value for a schedule of cash flows.
XOR	Returns a logical 'Exclusive Or' of all arguments.
YEAR	Returns the year of a date, an integer in the range 1900-9999..
YEARFRAC	Returns the year fraction representing the number of whole days between start_date and end_date.
YIELD	Returns the yield on a security that pays periodic interest.
YIELDDISC	Returns the annual yield for a discounted security. For example, a treasury bill.
YIELDMAT	Returns the annual yield of a security that pays interest at maturity.
ZTEST	Returns the one-tailed P-value of a z-test.
Z_TEST	Returns the one-tailed P-value of a z-test.

ABS

Returns the absolute value of a number, a number without its sign.

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 in the range 0 to Pi. The arccosine is the angle whose cosine is Number.

ACOSH

Returns the inverse hyperbolic cosine of a number.

ACOT

Returns the arccotangent of a number, in radians in the range 0 to Pi..

ACOTH

Returns the inverse hyperbolic cotangent of a number.

AGGREGATE

Returns an aggregate in a list or database.

AMORDEGRC

Returns the prorated linear depreciation of an asset for each accounting period..

AMORLINC

Returns the prorated linear depreciation of an asset for each accounting period..

AND

Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE.

ARABIC

Converts a Roman numeral to Arabic.

ASC

For double-byte character set (DBCS) languages, the function changes full-width (double-byte) characters to half-width (single-byte) characters.

ASIN

Returns the arcsine of a number in radians, in the range -Pi/2 to Pi/2.

ASINH

Returns the inverse hyperbolic sine of a number.

ATAN

Returns the arctangent of a number in radians, in the range -Pi/2 to Pi/2.

ATAN2

Returns the arctangent of the specified x and y coordinates, in radians between -Pi and Pi, excluding -Pi.

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 specified arguments.

AVERAGEA

Returns the average (arithmetic mean) of the specified arguments, evaluating text and false in arguments as 0; true evaluates as 1.

AVERAGEIF

Finds the average (arithmetic mean) for the cells specified by a given condition or criteria.

AVERAGEIFS

Finds the average (arithmetic mean) for the cells specified by a given set of conditions or criteria.

BASE

Converts a number into a text representation with the given radix (base).

BESSELI

Returns the modified Bessel function In(x).

BESSELJ

Returns the Bessel function Jn(x).

BESSELK

Returns the modified Bessel function Kn(x).

BESSELY

Returns the Bessel function Yn(x).

BETADIST

Returns the cumulative beta probability density function.

BETAINV

Returns the inverse of the cumulative beta probability density function for a specified beta distribution (BETADIST).

BETA_DIST

Returns the beta probability distribution function.

BETA_INV

Returns the inverse of the cumulative beta probability density function (BETA_DIST).

BIN2DEC

Converts a binary number to decimal.

BIN2HEX

Converts a binary number to hexadecimal.

BIN2OCT

Converts a binary number to octal.

BINOMDIST

Returns the individual term binomial distribution probability.

BINOM_DIST

Returns the individual term binomial distribution probability.

BINOM_DIST_RANGE

Returns the probability of a trial result using a binomial distribution.

BINOM_INV

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

BITAND

Returns a bitwise 'And' of two numbers.

BITLSHIFT

Returns a number shifted left by shift_amount bits.

BITOR

Returns a bitwise 'Or' of two numbers.

BITRSHIFT

Returns a number shifted right by shift_amount bits.

BITXOR

Returns a bitwise 'Exclusive Or' of two numbers.

CEILING

Rounds a number up, to the nearest multiple of significance.

CEILING_MATH

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

CEILING_PRECISE

Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.

CHAR

Returns the character specified by the code number from your computer's character set.

CHIDIST

Returns the right-tailed probability of the chi-squared distribution.

CHIINV

Returns the inverse of the right-tailed probability of the chi-squared distribution.

CHISQ_DIST

Returns the left-tailed probability of the chi-squared distribution.

CHISQ_DIST_RT

Returns the right-tailed probability of the chi-squared distribution.

CHISQ_INV

Returns the inverse of the left-tailed probability of the chi-squared distribution.

CHISQ_INV_RT

Returns the inverse of the right-tailed probability of the chi-squared distribution.

CHITEST

Returns the test for independence: the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.

CHOOSE

Chooses a value or action to perform from a list of values, based on an index number.

CLEAN

Removes all the nonprintable characters from the text.

CODE

Returns the code number from your computer's character set for the first character in the specified text string.

COLUMNS

Returns the number of columns in an array or reference.

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.

CONCATENATE

Combines multiple text strings into one text string.

CONFIDENCE

Returns the confidence interval for a population mean, using a normal distribution.

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.

CONVERT

Converts a number from one measurement system to another.

COS

Returns the cosine of an angle.

COSH

Returns the hyperbolic cosine of a number.

COT

Returns the cotangent of an angle.

COTH

Returns the hyperbolic cotangent of a number.

COUNT

Counts a number of cells in a range that contains numbers ignoring empty cells or those contaning text.

COUNTA

Counts a number of cells in a range that are not empty.

COUNTBLANK

Counts a number of empty cells in a specified range of cells.

COUNTIF

Counts a number of cells within a range that meet the given condition.

COUNTIFS

Counts a number of cells specified by a given set of conditions or criteria.

COUPDAYBS

Returns the number of days from the beginning of the coupon period to the settlement date.

COUPDAYS

Returns the number of days in the coupon period that contains the settlement date.

COUPDAYSNC

Returns the number of days from the settlement date to the next coupon date.

COUPNCD

Returns the next coupon date after the settlement date.

COUPNUM

Returns the number of coupons payable between the settlement date and maturity date.

COUPPCD

Returns the previous coupon date before the settlement date.

CRITBINOM

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

CSC

Returns the cosecant of an angle.

CSCH

Returns the hyperbolic cosecant of an angle.

CUMIPMT

Returns the cumulative interest paid between two periods.

CUMPRINC

Returns the cumulative principal paid on a loan between two periods.

DATE

Returns a number that represents the date in the date-time code.

DATEVALUE

Converts a date in the form of text to a number that represents the date in the date-time code.

DAVERAGE

Averages the values in a column in a list or database that match conditions you specify.

DAY

Returns the day of the date given in the numerical format, a number from 1 to 31.

DAYS

Returns the number of days between the two dates.

DAYS360

Returns the number of days between two dates based on a 360-day year (twelve 30-day months).

DB

Returns the depreciation of an asset for a specified period using the fixed-declining balance method.

DCOUNT

Counts the cells containing numbers in the field (column) of records in the database that match the conditions you specify.

DCOUNTA

Counts nonblank cells in the field (column) of records in the database that match the conditions you specify.

DDB

Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.

DEC2BIN

Converts a decimal number to binary.

DEC2HEX

Converts a decimal number to hexadecimal.

DEC2OCT

Converts a decimal number to octal.

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 numbers are equal.

DEVSQ

Returns the sum of squares of deviations of data points from their sample mean.

DGET

Extracts from a database a single record that matches the conditions you specify.

DISC

Returns the discount rate for a security.

DMAX

Returns the largest number in the field (column) of records in the database that match the conditions you specify.

DMIN

Returns the smallest number in the field (column) of records in the database that match the conditions you specify.

DOLLAR

Converts a number to text, using a currency format $#.##.

DOLLARDE

Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.

DOLLARFR

Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.

DPRODUCT

Multiplies the values in the field (column) of records in the database that match the conditions you specify.

DSTDEV

Estimates the standard deviation based on a sample from selected database entries.

DSTDEVP

Calculates the standard deviation based on the entire population of selected database entries.

DSUM

Adds the numbers in the field (column) of records in the database that match the conditions you specify.

DURATION

Returns the annual duration of a security with periodic interest payments.

DVAR

Estimates variance based on a sample from selected database entries.

DVARP

Calculates variance based on the entire population of selected database entries.

ECMA_CEILING

Rounds the number up to the nearest multiple of significance.

EDATE

Returns the serial number of the date which comes the indicated number of months before or after the start date.

EFFECT

Returns the effective annual interest rate.

EOMONTH

Returns the serial number of the last day of the month before or after a specified number of months.

ERF

Returns the error function.

ERFC

Returns the complementary error function.

ERFC_PRECISE

Returns the complementary error function.

ERF_PRECISE

Returns the error function.

ERROR_TYPE

Returns a number matching an error value..

EVEN

Rounds a positive number up and negative number down to the nearest even integer.

EXACT

Checks whether two text strings are exactly the same, and returns true or false. This function is case-sensitive.

EXP

Returns e raised to the power of a given number.

EXPONDIST

Returns the exponential distribution.

EXPON_DIST

Returns the exponential distribution.

FACT

Returns the factorial of a number, equal to 123*...* Number.

FACTDOUBLE

Returns the double factorial of a number.

FALSE

Returns the logical value FALSE.

FDIST

Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets.

FIND

Returns the starting position of one text string within another text string. This function is case-sensitive.

FINDB

Finds the specified substring within another string and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

FINV

Returns the inverse of the (right-tailed) F probability distribution: if p = FDIST(x,...), then FINV(p,...) = x.

FISHER

Returns the Fisher transformation.

FISHERINV

Returns the inverse of the Fisher transformation: if y = FISHER(x), then FISHERINV(y) = x.

FIXED

Rounds a number to the specified number of decimals and returns the result as text with or without commas.

FLOOR

Rounds a number down to the nearest multiple of significance.

FLOOR_MATH

Rounds a number down, to the nearest integer or to the nearest multiple of significance.

FLOOR_PRECISE

Returns a number that is rounded down to the nearest integer or to the nearest multiple of significance.

FORECAST_ETS

Сalculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm.

FORECAST_ETS_CONFINT

Returns a confidence interval for the forecast value at the specified target date.

FORECAST_ETS_SEASONALITY

Returns the length of the repetitive pattern an application detects for the specified time series.

FORECAST_ETS_STAT

Returns the requested statistic for the forecast.

FREQUENCY

Calculates how often values occur within a range of values and then returns the first value of the returned vertical array of numbers.

FV

Returns the future value of an investment based on periodic, constant payments and a constant interest rate.

FVSCHEDULE

Returns the future value of an initial principal after applying a series of compound interest rates.

F_DIST

Returns the (left-tailed) F probability distribution (degree of diversity) for two data sets.

F_DIST_RT

Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets.

F_INV

Returns the inverse of the (left-tailed) F probability distribution: if p = F.DIST(x,...), then F.INV(p,...) = x.

F_INV_RT

Returns the inverse of the (right-tailed) F probability distribution: if p = F.DIST.RT(x,...), then F.INV.RT(p,...) = x.

GAMMA

Returns the gamma function value.

GAMMADIST

Returns the gamma distribution.

GAMMAINV

Returns the inverse of the gamma cumulative distribution: if p = GAMMADIST(x,...), then GAMMAINV(p,...) = x.

GAMMALN

Returns the natural logarithm of the gamma function.

GAMMALN_PRECISE

Returns the natural logarithm of the gamma function.

GAMMA_DIST

Returns the gamma distribution.

GAMMA_INV

Returns the inverse of the gamma cumulative distribution: if p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x.

GAUSS

Calculates the probability that a member of a standard normal population will fall between the mean and arg1 standard deviations from the mean.

GCD

Returns the greatest common divisor.

GEOMEAN

Returns the geometric mean of an array or range of positive numeric data.

GESTEP

Tests whether a number is greater than a threshold value.

GROWTH

Calculates predicted exponential growth by using existing data.

HARMEAN

Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals.

HEX2BIN

Converts a Hexadecimal number to binary.

HEX2DEC

Converts a hexadecimal number to decimal.

HEX2OCT

Converts a hexadecimal number to octal.

HLOOKUP

Looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify.

HOUR

Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.)..

HYPERLINK

Creates a shortcut or jump that opens a document stored on your hard drive, a network server, or on the Internet.

HYPGEOMDIST

Returns the hypergeometric distribution.

HYPGEOM_DIST

Returns the hypergeometric distribution.

IF

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.

IFERROR

Returns value_if_error if expression is an error and the value of the expression itself otherwise.

IFNA

Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.

IMABS

Returns the absolute value (modulus) of a complex number.

IMAGINARY

Returns the imaginary coefficient of a complex number.

IMARGUMENT

Returns the argument q, an angle expressed in radians.

IMCONJUGATE

Returns the complex conjugate of a complex number.

IMCOS

Returns the cosine of a complex number.

IMCOSH

Returns the hyperbolic cosine of a complex number.

IMCOT

Returns the cotangent of a complex number.

IMCSC

Returns the cosecant of a complex number.

IMCSCH

Returns the 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 an integer power.

IMPRODUCT

Returns the product of 1 to 255 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 of 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.

INT

Rounds a number down to the nearest integer.

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

Returns the internal rate of return for a series of cash flows.

ISERR

Checks whether a value is an error other than #N/A, and returns TRUE or FALSE.

ISERROR

Checks whether a value is an error, and returns TRUE or FALSE.

ISEVEN

Returns TRUE if the number is even.

ISFORMULA

Checks whether a reference is to a cell containing a formula, and returns TRUE or FALSE.

ISLOGICAL

Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE.

ISNA

Checks whether a value is #N/A, and returns TRUE or FALSE.

ISNONTEXT

Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE.

ISNUMBER

Checks whether a value is a number, and returns TRUE or FALSE.

ISODD

Returns TRUE if the number is odd.

ISOWEEKNUM

Returns the ISO week number in the year for a given date.

ISO_CEILING

Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance regardless of the sign of the number. However, if the number or the significance is zero, zero is returned..

ISPMT

Returns the interest paid during a specific period of an investment.

ISREF

Checks whether a value is a reference, and returns TRUE or FALSE.

ISTEXT

Checks whether a value is text, and returns TRUE or FALSE.

KURT

Returns the kurtosis of a data set.

LARGE

Returns the k-th largest value in a data set. For example, the fifth largest number.

LCM

Returns the least common multiple.

LEFT

Returns the specified number of characters from the start of a text string.

LEFTB

Extracts the substring from the specified string starting from the left character and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

LEN

Returns the number of characters in a text string.

LENB

Analyses the specified string and returns the number of characters it contains and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

LINEST

Returns statistics that describe a linear trend matching known data points, by fitting a straight line using the least squares method.

LN

Returns the natural logarithm of a number.

LOG

Returns the logarithm of a number to the base you specify.

LOG10

Returns the base-10 logarithm of a number.

LOGEST

Returns statistics that describe an exponential curve matching known data points.

LOGINV

Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with the specified parameters.

LOGNORMDIST

Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with the specified parameters.

LOGNORM_DIST

Returns the lognormal distribution of x, where ln(x) is normally distributed with the specified parameters.

LOGNORM_INV

Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with the specified parameters.

LOOKUP

Looks up a value either from a one-row or one-column range or from an array. Provided for backwards compatibility.

LOWER

Converts all letters in a text string to lowercase.

MATCH

Returns the relative position of an item in an array that matches a specified value in a specified order.

MAX

Returns the largest value in a set of values. Ignores logical values and text.

MAXA

Returns the largest value in a set of values. Does not ignore logical values and text.

MDURATION

Returns the Macauley modified duration for a security with an assumed par value of $100.

MEDIAN

Returns the median, or the number in the middle of the set of given numbers.

MID

Returns the characters from the middle of a text string, given a starting position and length.

MIDB

Extracts the characters from the specified string starting from any position and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

MIN

Returns the smallest number in a set of values. Ignores logical values and text.

MINA

Returns the smallest value in a set of values. Does not ignore logical values and text.

MINUTE

Returns the minute, a number from 0 to 59..

MIRR

Returns the internal rate of return for a series of periodic cash flows, considering both cost of investment and interest on reinvestment of cash.

MOD

Returns the remainder after a number is divided by a divisor.

MONTH

Returns the month, a number from 1 (January) to 12 (December)..

MROUND

Returns a number rounded to the desired multiple.

MULTINOMIAL

Returns the multinomial of a set of numbers.

MUNIT

Returns the unit matrix for the specified dimension.

N

Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero).

NA

Returns the error value #N/A (value not available).

NEGBINOMDIST

Returns the negative binomial distribution, the probability that there will be the specified number of failures before the last success, with the specified probability of a success.

NEGBINOM_DIST

Returns the negative binomial distribution, the probability that there will be the specified number of failures before the last success, with the specified probability of a success.

NETWORKDAYS

Returns the number of whole workdays between two dates.

NETWORKDAYS_INTL

Returns the number of whole workdays between two dates with custom weekend parameters.

NOMINAL

Returns the annual nominal interest rate.

NORMDIST

Returns the normal cumulative distribution for the specified mean and standard deviation.

NORMINV

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

NORMSDIST

Returns the standard normal cumulative distribution (has a mean of zero and a standard deviation of one).

NORMSINV

Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one).

NORM_DIST

Returns the normal distribution for the specified mean and standard deviation.

NORM_INV

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

NORM_S_DIST

Returns the standard normal distribution (has a mean of zero and a standard deviation of one).

NORM_S_INV

Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one).

NOT

Changes FALSE to TRUE, or TRUE to FALSE.

NOW

Returns the current date and time formatted as a date and time..

NPER

Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

NPV

Returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values).

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 positive number up and negative number down to the nearest odd integer.

ODDFPRICE

Returns the price per $100 face value of a security with an odd first period.

ODDFYIELD

Returns the yield of a security with an odd first period.

ODDLPRICE

Returns the price per $100 face value of a security with an odd last period.

ODDLYIELD

Returns the yield of a security with an odd last period.

OR

Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE.

PDURATION

Returns the number of periods required by an investment to reach a specified value.

PERCENTILE

Returns the k-th percentile of values in a range.

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.

PERCENTRANK

Returns the rank of a value in a data set as a percentage of the data set.

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.

PERMUT

Returns the number of permutations for a given number of objects that can be selected from the total objects.

PERMUTATIONA

Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.

PHI

Returns the value of the density function for a standard normal distribution.

PI

Returns the value of Pi, 3.14159265358979, accurate to 15 digits.

PMT

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

POISSON

Returns the Poisson distribution.

POISSON_DIST

Returns the Poisson distribution.

POWER

Returns the result of a number raised to a power.

PPMT

Returns the payment on the principal for a given investment based on periodic, constant payments and a constant interest rate.

PRICE

Returns the price per $100 face value of a security that pays periodic interest.

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.

PRODUCT

Multiplies all the numbers given as arguments.

PROPER

Converts a text string to proper case: the first letter in each word to uppercase, and all other letters to lowercase.

PV

Returns the present value of an investment: the total amount that a series of future payments is worth now.

QUARTILE

Returns the quartile of a data set.

QUARTILE_EXC

Returns the quartile of a data set, based on percentile values from 0..1, exclusive.

QUARTILE_INC

Returns the quartile of a data set, based on percentile values from 0..1, inclusive.

QUOTIENT

Returns the integer portion of a division.

RADIANS

Converts degrees to radians.

RAND

Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation).

RANDBETWEEN

Returns a random number between the numbers you specify.

RANK

Returns the rank of a number in a list of numbers: its size relative to other values in the list.

RANK_AVG

Returns the rank of a number in a list of numbers: its size relative to other values in the list. If more than one value has the same rank, the average rank is returned.

RANK_EQ

Returns the rank of a number in a list of numbers: its size relative to other values in the list. If more than one value has the same rank, the top rank of that set of values is returned.

RATE

Returns the interest rate per period of a loan or an investment. For example, use 6%/4 for quarterly payments at 6% APR.

RECEIVED

Returns the amount received at maturity for a fully invested security.

REPLACE

Replaces part of a text string with a different text string.

REPLACEB

Replaces a set of characters, based on the number of characters and the start position specified, with a new set of characters and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

REPT

Repeats text a given number of times. Use this function to fill a cell with a number of instances of a text string.

RIGHT

Returns the specified number of characters from the end of a text string.

RIGHTB

Extracts a substring from a string starting from the right-most character, based on the specified number of characters and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

ROMAN

Converts an Arabic numeral to Roman, as text.

ROUND

Rounds a number to a specified number of digits.

ROUNDDOWN

Rounds a number down, towards zero.

ROUNDUP

Rounds a number up, away from zero.

ROWS

Returns the number of rows in a reference or array.

RRI

Returns an equivalent interest rate for the growth of an investment.

SEARCH

Returns the number of the character at which a specific character or text string is first found, reading left to right (not case-sensitive).

SEARCHB

Returns the location of the specified substring in a string and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

SEC

Returns the secant of an angle.

SECH

Returns the hyperbolic secant of an angle.

SECOND

Returns the second, a number from 0 to 59..

SERIESSUM

Returns the sum of a power series based on the formula.

SHEET

Returns the sheet number of the referenced sheet.

SHEETS

Returns the number of sheets in a reference.

SIGN

Returns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative.

SIN

Returns the sine of an angle.

SINH

Returns the hyperbolic sine of a number.

SKEW

Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution around its mean.

SKEW_P

Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean.

SLN

Returns the straight-line depreciation of an asset for one period.

SMALL

Returns the k-th smallest value in a data set. For example, the fifth smallest number.

SQRT

Returns the square root of a number.

SQRTPI

Returns the square root of (number * Pi).

STANDARDIZE

Returns a normalised value from a distribution characterised by a mean and standard deviation.

STDEV

Estimates standard deviation based on a sample (ignores logical values and text in the sample).

STDEVA

Estimates standard deviation based on a sample, including logical values and text. Text and the false logical value have the value 0; the true logical value has the value 1.

STDEVP

Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).

STDEVPA

Calculates standard deviation based on an entire population, including logical values and text. Text and the false logical value have the value 0; the true logical value has the value 1.

STDEV_P

Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).

STDEV_S

Estimates standard deviation based on a sample (ignores logical values and text in the sample).

SUBSTITUTE

Replaces existing text with new text in a text string.

SUBTOTAL

Returns a subtotal in a list or database.

SUM

Adds all the numbers in a range of cells.

SUMIF

Adds the cells specified by a given condition or criteria.

SUMIFS

Adds the cells specified by a given set of conditions or criteria.

SUMSQ

Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names or references to cells that contain numbers.

SYD

Returns the sum-of-years' digits depreciation of an asset for a specified period.

T

Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not.

TAN

Returns the tangent of an angle.

TANH

Returns the hyperbolic tangent of a number.

TBILLEQ

Returns the bond-equivalent yield for a treasury bill.

TBILLPRICE

Returns the price per $100 face value for a treasury bill.

TBILLYIELD

Returns the yield for a treasury bill.

TDIST

Returns the Student's t-distribution.

TEXT

Converts a value to text in a specific number format.

TIME

Converts hours, minutes and seconds given as numbers to a serial number, formatted with a time format.

TIMEVALUE

Converts a text time to a serial number for a time, a number from 0 (12:00:00 AM) to 0.999988426 (11:59:59 PM). Format the number with a time format after entering the formula.

TINV

Returns the two-tailed inverse of the Student's t-distribution.

TODAY

Returns the current date formatted as a date..

TRANSPOSE

Converts a vertical range of cells to a horizontal range, or vice versa.

TREND

Returns numbers in a linear trend matching known data points, using the least squares method.

TRIM

Removes all spaces from a text string except for single spaces between words.

TRIMMEAN

Returns the mean of the interior portion of a set of data values.

TRUE

Returns the logical value TRUE.

TRUNC

Truncates a number to an integer by removing the decimal, or fractional, part of the number.

TYPE

Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; array = 64; compound data = 128.

T_DIST

Returns the left-tailed Student's t-distribution.

T_DIST_2T

Returns the two-tailed Student's t-distribution.

T_DIST_RT

Returns the right-tailed Student's t-distribution.

T_INV

Returns the left-tailed inverse of the Student's t-distribution.

T_INV_2T

Returns the two-tailed inverse of the Student's t-distribution.

UNICHAR

Returns the Unicode character referenced by the given numeric value.

UNICODE

Returns the number (code point) corresponding to the first character of the text.

UPPER

Converts a text string to all uppercase letters.

VALUE

Converts a text string that represents a number to a number.

VAR

Estimates variance based on a sample (ignores logical values and text in the sample).

VARA

Estimates variance based on a sample, including logical values and text. Text and the false logical value have the value 0; the true logical value has the value 1.

VARP

Calculates variance based on the entire population (ignores logical values and text in the population).

VARPA

Calculates variance based on the entire population, including logical values and text. Text and the false logical value have the value 0; the true logical value has the value 1.

VAR_P

Calculates variance based on the entire population (ignores logical values and text in the population).

VAR_S

Estimates variance based on a sample (ignores logical values and text in the sample).

VDB

Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify.

VLOOKUP

Looks for a value in the leftmost column of a table and then returns a value in the same row from a column that you specify. By default, the table must be sorted in an ascending order.

WEEKDAY

Returns a number from 1 to 7 identifying the day of the week of a date..

WEEKNUM

Returns the week number in the year.

WEIBULL

Returns the Weibull distribution.

WEIBULL_DIST

Returns the Weibull distribution.

WORKDAY

Returns the serial number of the date before or after a specified number of workdays.

WORKDAY_INTL

Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters.