Class representing a worksheet function.
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. |
builder.CreateFile("xlsx"); var oWorksheet = Api.GetActiveSheet(); var oFunction = Api.GetWorksheetFunction(); var ids = ["ID", 1, 2, 3, 4, 5]; var clients = ["Client", "John Smith", "Ella Tompson", "Mary Shinoda", "Lily-Ann Bates", "Clara Ray"]; var phones = ["Phone number", "12054097166", "13343943678", "12568542099", "12057032298", "12052914781"]; for (var i = 0; i < ids.length; i++) { oWorksheet.GetRange("A" + (i + 1)).SetValue(ids[i]); } for (var j = 0; j < clients.length; j++) { oWorksheet.GetRange("B" + (j + 1)).SetValue(clients[j]); } for (var n = 0; n < phones.length; n++) { oWorksheet.GetRange("C" + (n + 1)).SetValue(phones[n]); } oWorksheet.GetRange("C1").SetColumnWidth(15); oWorksheet.GetRange("F1").SetColumnWidth(15); oWorksheet.GetRange("B1").SetColumnWidth(15); oWorksheet.GetRange("E1").SetColumnWidth(15); oWorksheet.GetRange("E1").SetValue("Name"); oWorksheet.GetRange("E2").SetValue("Ella Tompson"); oWorksheet.GetRange("F1").SetValue("Phone number"); var oRange1 = oWorksheet.GetRange("B2:B6"); var oRange2 = oWorksheet.GetRange("C2:C6"); oWorksheet.GetRange("F2").SetValue(oFunction.LOOKUP("Ella Tompson", oRange1, oRange2)); oWorksheet.GetRange("E3").SetValue("John Smith"); var oRange3 = oWorksheet.GetRange("A1:C6"); oWorksheet.GetRange("F3").SetValue(oFunction.HLOOKUP("Phone number", oRange3, 2)); oWorksheet.GetRange("E4").SetValue("Clara Ray"); oWorksheet.GetRange("F4").SetValue(oFunction.VLOOKUP("Phone number", oRange3, 3)); var oRange4 = oWorksheet.GetRange("E2:E4"); oWorksheet.GetRange("E6").SetValue("Clients"); oWorksheet.GetRange("F6").SetValue(oFunction.COUNTA(oRange4)); builder.SaveFile("xlsx", "ApiWorksheetFunction.xlsx"); builder.CloseFile();