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