ApiWorksheetFunction

new ApiWorksheetFunction()

Class representing a worksheet function.

Methods

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.