ApiWorksheetFunction

Represents the ApiWorksheetFunction class.

Methods

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