This appendix lists all of the functions in Microsoft Excel alphabetically.
Function | Excel Category | Description |
|---|---|---|
ABS | Math & Trigonometry | Returns the absolute value of a number |
ACCRINT | Financial | Returns the accrued interest for a security that pays periodic interest |
ACCRINTM | Financial | Returns the accrued interest for a security that pays interest at maturity |
ACOS | Math & Trigonometry | Returns the arc cosine or the inverse cosine of a number |
ACOSH | Math & Trigonometry | Returns the inverse hyperbolic cosine of a number |
ADDRESS | Lookup & Reference | Returns a reference to a table cell as text |
AGGREGATE (2010) | Math & Trigonometry | Returns an aggregate in a list or database |
AMORDEGRC | Financial | Returns the depreciation amount to apply to a billing cycle based on the French accounting system |
AMORLINC | Financial | Calculates the linear depreciation amount for assets |
AND | Logical | Returns |
AREAS | Lookup & Reference | Returns the number of ranges within a reference |
ASC | Text & Data | Converts double-byte characters into single-byte characters |
ASIN | Math & Trigonometry | Returns the arc sine of a number |
ASINH | Math & Trigonometry | Returns the inverse hyperbolic sine of a number |
ATAN | Math & Trigonometry | Returns the arctangent of a number |
ATAN2 | Math & Trigonometry | Returns the arctangent based on an x-coordinate or y-coordinate |
ATANH | Math & Trigonometry | Returns the inverse hyperbolic tangent of a number |
AVEDEV | Statistical | Returns the average absolute variance of characteristic values and the average value |
AVERAGE | Statistical | Returns the mean average, which is the number value that is calculated by dividing sums |
AVERAGEA | Statistical | Calculates the mean value (mean average) of the values in an argument list |
AVERAGEIF | Statistical | Returns the mean value (mean average) of all cells in a range that meet a specified criterion |
AVERAGEIFS | Statistical | Returns the mean value (mean average) of all cells meeting several criteria |
BAHTTEXT | Text & Data | Converts a number into Thai characters and adds the suffix Baht |
BESSELI | Engineering | Returns the modified Bessel function In(x) that corresponds with the Bessel function Jn evaluated for imaginary arguments |
BESSELJ | Engineering | Returns the Bessel function Jn(x) |
BESSELK | Engineering | Returns the modified Bessel function Kn(x) that corresponds with the Bessel functions Jn and Yn evaluated for imaginary arguments |
BESSELY | Engineering | Returns the Bessel function Yn(x) |
BETADIST | Statistical (2010 compatibility) | Returns the values of the cumulative beta distribution function |
BETA.DIST (2010) | Statistical | See BETADIST |
BETAINV | Statistical (2010 compatibility) | Returns the quantile of the given beta distribution |
BETA.INV (2010) | Statistical | See BETAINV |
BIN2DEC | Engineering | Converts a binary number into a decimal number |
BIN2HEX | Engineering | Converts a binary number into a hexadecimal number |
BIN2OCT | Engineering | Converts a binary number into an octal number |
BINOM.DIST (2010) | Statistical | See BINOMDIST |
BINOM.INV (2010) | Statistical | Returns the smallest value for which the cumulative probabilities of the binominal distribution are greater than or equal to a marginal probability |
BINOMDIST | Statistical (2010 compatibility) | Returns the probabilities of a binominal distributed random variable |
CEILING | Math & Trigonometry | Rounds a number to the smallest multiple of the increments |
CEILING.PRECISE (2010) | Math & Trigonometry | See CEILING |
CELL | Information | Returns information about the formatting, the position, and the content of the upper-left cell in a reference |
CHAR | Text & Data | Returns the code of a character |
CHIDIST | Statistical (2010 compatibility) | Returns the values of a distribution function (1 alpha) of a chi-square distributed random variable |
CHIINV | Statistical (2010 compatibility) | Returns the quantile of the γ2 distribution |
CHISQ.DIST (2010) | Statistical | Returns the values of the left distribution function (1 alpha) of a chi-square distributed random variable |
CHISQ.DIST.RT (2010) | Statistical | Returns the values of the right distribution function (1 alpha) of a chi-square distributed random variable |
CHISQ.INV (2010) | Statistical | Returns the quantile of the left γ2 distribution |
CHISQ.INV.RT (2010) | Statistical | Returns the quantile of the right γ2 distribution |
CHISQ.TEST (2010) | Statistical | See CHITEST |
CHITEST | Statistical (2010 compatibility) | Returns the test statistics of a γ independence test |
CHOOSE | Lookup & Reference | Uses an index to return a value from the value argument list |
CLEAN | Text & Data | Deletes all nonprintable characters from the text |
CODE | Text & Data | Returns the code of the first character in the text |
COLUMN | Lookup & Reference | Returns the column number of a reference |
COLUMNS | Lookup & Reference | Returns the number of columns in a matrix or a reference |
COMBIN | Math & Trigonometry | Returns the number of combinations without repetition of k elements in an n element set |
COMPLEX | Engineering | Converts real and imaginary coefficients into a complex number (x + yi or x + yj) |
CONCATENATE | Text & Data | Combines several strings into one string |
CONFIDENCE | Statistical (2010 compatibility) | Returns a value used to create a confidence interval for the expected value of a random variable |
CONFIDENCE.NORM | Statistical | See CONFIDENCE |
CONFIDENCE.T (2010) | Statistical | Returns a value used to create a confidence interval for the expected value of a t-distributed random variable |
CONVERT | Engineering | Converts a number into a different system of measurement |
CORREL | Statistical | Returns the correlation coefficient of a two-dimensional random variable with values in the cell ranges Matrix1 and Matrix2 |
COS | Math & Trigonometry | Returns the cosine of a number |
COSH | Math & Trigonometry | Returns the hyperbolic cosine of a number |
COUNT | Statistical | Calculates how many numbers are included in an argument list |
COUNTA | Statistical | Calculates how many values are included in an argument list |
COUNTBLANK | Statistical | Counts the empty cells in a cell range |
COUNTIF | Statistical | Counts the cells of a range whose contents match the search criteria |
COUNTIFS | Statistical | Counts the cells of a range whose contents match several criteria |
COUPDAYBS | Financial | Returns the number of days from the beginning of the interest date to the settlement date |
COUPDAYS | Financial | Returns the number of days of the interest period including the settlement date |
COUPDAYSNC | Financial | Returns the number of days between the settlement date and the next interest date (coupon settled day) |
COUPNCD | Financial | Returns a number indicating the next interest date after the settlement date |
COUPNUM | Financial | Returns the number of interest payments between the settlement date and the due date |
COUPPCD | Financial | Returns a number indicating the last interest date before the settlement date |
COVAR | Statistical (2010 compatibility) | Returns the covariance, the average of the products of deviations for each data point pair |
COVARIANCE.P (2010) | Statistical | See COVAR |
COVARIANCE.S (2010) | Statistical | Returns the covariance of a sample, the average of the products of deviations for each data point pair |
CRITBINOM | Statistical | Returns the smallest value for which the cumulative probabilities of the binominal distribution are greater than or equal to a marginal probability |
CUBEMEMBER | Cube | Returns the dimension element for the given dimension path |
CUBEMEMBERPROPERTY | Cube | Returns the requested property (attribute) for a dimension element |
CUBEKPIMEMBER | Cube | Returns the requested property for the Key Performance Indicators of a cube |
CUBERANKEDMEMBER | Cube | Returns the element in a set defined by the rank |
CUBESET | Cube | Returns the defined element set of a cube |
CUBESETCOUNT | Cube | Returns the number of elements in a set |
CUBEVALUE | Cube | Returns the value for a given address from a data cube |
CUMIPMT | Financial | Calculates the cumulated interest payable between two periods |
CUMPRINC | Financial | Calculates the accrued loan repayment payable between two periods |
DATE | Date & Time | Returns the serial number for a given date |
DATEDIF | Date & Time | Calculates the difference between the start and end date in years, months, or days |
DATEVALUE | Date & Time | Converts a date formatted as text into a serial number |
DAVERAGE | Database | Returns the average values from a list or database column that meets the given conditions |
DAY | Date & Time | Returns the day of a date as a serial number |
DAYS360 | Date & Time | Calculates the number of days between two dates based on a year with 360 days |
DB | Financial | Returns the geometric degressive depreciation of an asset for a given period |
DCOUNT | Database | Counts the number of cells in a column in a list or database that meets the specified conditions |
DCOUNTA | Database | Counts the number of cells in a column in a list or database that meets the specified conditions |
DDB | Financial | Returns the depreciation of an asset for a given period using the double-declining-balance depreciation (or the specified multiple-declining method) |
DEC2BIN | Engineering | Converts a decimal number into a binary number |
DEC2HEX | Engineering | Converts a decimal number into a hexadecimal number |
DEC2OCT | Engineering | Converts a decimal number into an octal number |
DEGREES | Math & Trigonometry | Converts a radian measure into degrees |
DELTA | Engineering | Tests whether two numbers are equal |
DEVSQ | Statistical | Returns the sum of the squared variances of data points based on the sample average value |
DGET | Database | Extracts the values from a column in a list or database that meets the specified conditions |
DISC | Financial | Returns the discount rate for a security (in percent) |
DMAX | Database | Returns the highest number from a column in a list or database that meets the specified conditions |
DMIN | Database | Returns the lowest number from a column in a list or database that meets the specified conditions |
DOLLAR | Text & Data | Converts a number into a text format and assigns a currency format and a currency symbol |
DOLLARDE | Financial | Converts a dollar price from a decimal fraction into a decimal number |
DOLLARFR | Financial | Converts a dollar price from a decimal number into a decimal fraction |
DPRODUCT | Database | Multiplies the values in a column in a list or database that meets the specified conditions |
DSTDEV | Database | Calculates the standard variance of the population based on the numbers in a column in a list or database that meets the specified conditions |
DSTDEVP | Database | Calculates the standard variance of the full population based on the numbers in a column in a list or database that meets the specified conditions |
DSUM | Database | Adds the numbers in a column in a list or database that meets the specified conditions |
DURATION | Financial | Returns the Macauley duration for a security |
DVAR | Database | Calculates the variance of the population based on a sample using the numbers in a column in a list or database that meets the specified conditions |
DVARP | Database | Calculates the variance of the full population based on the numbers in a column in a list or database that meets the specified conditions |
EDATE | Date & Time | Returns the serial number of the date that is the indicated number of months before or after the start date |
EFFECT | Financial | Returns the effective annual interest rate based on the nominal interest and the number of annual interest payments |
EOMONTH | Date & Time | Returns the serial number of the last day of the month that is the indicated number of months before or after the start date |
ERF | Engineering | Returns the Gaussian error function |
ERF.PRECISE (2010) | Engineering | See ERF |
ERFC | Engineering | Returns the complementary Gaussian error function |
ERFC.PRECISE (2010) | Engineering | See ERFC |
ERROR.TYPE | Information | Returns the number corresponding to one of the error values in Excel or the error value |
EVEN | Math & Trigonometry | Rounds a number to the next even integer |
EXACT | Text & Data | Checks whether two strings are exactly the same |
EXP | Math & Trigonometry | Returns e raised to the power of a given number; the constant e equals 2.71828182845904, which is the base of the natural logarithm |
EXPON.DIST (2010) | Statistical | See EXPONDIST |
EXPONDIST | Statistical (2010 compatibility) | Returns the probabilities of an exponential distributed random variable |
F.DIST (2010) | Statistical | Returns the values of a distribution function (1 alpha) of a left f-distributed random variable |
F.DIST.RT (2010) | Statistical | Returns the values of a distribution function (1 alpha) of a right f-distributed random variable |
F.INV (2010) | Statistical | Returns the quantile of the left f-distribution |
F.INV.RT (2010) | Statistical | Returns the quantile of the right f-distribution |
F.TEST (2010) | Statistical | See FTEST |
FACT | Math & Trigonometry | Returns the factorial of a number equal to 1*2*3*...* number |
FACTDOUBLE | Math & Trigonometry | Returns the double factorial of a number |
FALSE | Logical | Returns the logical value |
FDIST | Statistical (2010 compatibility) | Returns the values of a distribution function (1 alpha) of an f-distributed random variable |
FIND | Text & Data | Searches for a string within another string and returns the number of the initial position starting at the first character |
FINDB | Text & Data | Searches for a string within another string and returns the number of the initial position starting at the first character based on the bytes of each character |
FINV | Statistical (2010 compatibility) | Returns the quantile of the f-distribution |
FISHER | Statistical | Returns the Fisher transformation for x |
FISHERINV | Statistical | Returns the inversion of the Fisher transformation |
FIXED | Text & Data | Formats a number as text with a specified number of decimal places |
FLOOR | Math & Trigonometry | Rounds a number |
FLOOR.PRECISE (2010) | Math & Trigonometry | See FLOOR |
FORECAST | Statistical | Returns the estimated value for a linear trend |
FREQUENCY | Statistical | Returns a frequency distribution as a single-column matrix |
FTEST | Statistical (2010 compatibility) | Returns the test statistics of a f-test |
FV | Financial | Returns the future value (end value) of an investment |
FVSCHEDULE | Financial | Returns the accumulated value of the initial capital for several periodic interest rates |
GAMMA.DIST (2010) | Statistical | See GAMMADIST |
GAMMA.INV (2010) | Statistical | See GAMMAINV |
GAMMADIST | Statistical (2010 compatibility) | Returns the probabilities of a gamma-distributed random variable |
GAMMAINV | Statistical (2010 compatibility) | Returns the quantile of the gamma distribution |
GAMMALN | Statistical | Returns the natural logarithm of the gamma function, Γ(x) |
GAMMALN.PRECISE (2010) | Statistical | See GAMMALN |
GCD | Math & Trigonometry | Returns the greatest common divisor |
GEOMEAN | Statistical | Returns the geometric mean of a set of positive numbers |
GESTEP | Engineering | Checks whether a number is greater than or equal to a given threshold value |
GETPIVOTDATA | Database | Returns data from a PivotTable report |
GROWTH | Statistical | Returns values from an exponential trend |
HARMEAN | Statistical | Returns the harmonic mean of a data set |
HEX2BIN | Engineering | Converts a hexadecimal number into a binary number |
HEX2DEC | Engineering | Converts a hexadecimal number into a decimal number |
HEX2OCT | Engineering | Converts a hexadecimal number into an octal number |
HLOOKUP | Lookup & Reference | Searches for values in the first row of a table or matrix and returns a value from a row in the column you specify in the table or matrix |
HOUR | Date & Time | Returns the hour of a time specification |
HYPERLINK | Lookup & Reference | Creates a connection to open a document saved on a network server or on an intranet or the Internet; can also be used to navigate to another sheet inside the current workbook |
HYPGEOM.DIST (2010) | Statistical | Returns the probabilities of a hypergeometric-distributed random variable |
HYPGEOMDIST | Statistical (2010 compatibility) | Returns the probabilities of a hypergeometric distributed random variable |
IF | Logical | Indicates the logical inquiry to be performed |
IFERROR | Logical | Calculates a specified output if an expression contains an error; otherwise returns the result of the expression |
IMABS | Engineering | Returns the absolute value of a complex number |
IMAGINARY | Engineering | Returns the imaginary part of a complex number in the form of x + yi or x + yj |
IMARGUMENT | Engineering | Returns the argument (ϕ) as an angle expressed as a radian measure |
IMCONJUGATE | Engineering | Returns the complex conjugate of a complex number (x + yi or x + yj) |
IMCOS | Engineering | Returns the cosine of a complex number (x + yi or x + yj) |
IMDIV | Engineering | Returns the quotient of two complex numbers expected as x + yi or x + yj |
IMEXP | Engineering | Returns the algebraic form of a complex exponential number with an exponent (x + yi or x + yj) |
IMLN | Engineering | Returns the natural logarithm of a complex number (x + yi or x + yj) |
IMLOG10 | Engineering | Returns the common logarithm of a complex number with a power of 10 (x + yi or x + yj) |
IMLOG2 | Engineering | Returns the base-2 logarithm of a complex number with a power of 2 (x + yi or x + yj) |
IMPOWER | Engineering | Exponentiates a complex number (x + yi or x + yj) with an integer |
IMPRODUCT | Engineering | Returns the product of complex numbers expected as x + yi or x + yj |
IMREAL | Engineering | Returns the real part of a complex number (x + yi or x + yj) |
IMSIN | Engineering | Returns the sine of a complex number (x + yi or x + yj) |
IMSQRT | Engineering | Returns the square root of a complex number (x + yi or x + yj) |
IMSUB | Engineering | Returns the difference of two complex numbers (x + yi or x + yj) |
IMSUM | Engineering | Returns the sum of complex numbers (x + yi or x + yj) |
INDEX | Lookup & Reference | Uses an index to select a value from a reference or a matrix |
INDIRECT | Lookup & Reference | Returns the reference of a text value; references are immediately evaluated to show the associated values |
INFO | Information | Returns information about the current operating system environment |
INT | Math & Trigonometry | Rounds a number to the next smaller integer |
INTERCEPT | Statistical | Returns the intersection of the regression line |
INTRATE | Financial | Returns the amount paid at maturity for a fully invested security |
IPMT | Financial | Returns the interest payment of an investment for the given period based on regular invariable payments and an invariable interest rate |
IRR | Financial | Returns the internal interest rate of an investment without finance charges or reinvestment gains |
ISBLANK | Information | Returns |
ISERR | Information | Returns |
ISERROR | Information | Returns |
ISEVEN | Information | Returns |
ISLOGICAL | Information | Returns |
ISNA | Information | Returns |
ISNONTEXT | Information | Returns |
ISNUMBER | Information | Returns |
ISODD | Information | Returns |
ISPMT | Financial | Calculates the interest for an investment paid within a certain period |
ISREF | Information | Returns |
ISTEXT | Information | Returns |
JIS | Text & Data | Converts Latin single-byte characters or Katakana within a string into Japanese double-byte characters |
KURT | Statistical | Returns the kurtosis of a data group |
LARGE | Statistical | Returns the highest K-value of a data group |
LCM | Math & Trigonometry | Returns the lowest common denominator of the integers specified as arguments |
LEFT | Text & Data | Returns the first character(s) of a string based on the specified number of characters |
LEN | Text & Data | Returns the number of characters in a string |
LINEST | Statistical | Calculates the statistics for a line by using the smallest squares to calculate a straight line appropriate for the data and returns a matrix describing a line |
LN | Math & Trigonometry | Returns the natural logarithm of a number |
LOG | Math & Trigonometry | Returns the logarithm of a number with the specified power |
LOG10 | Math & Trigonometry | Returns the base-10 logarithm of a number |
LOGEST | Statistical | Calculates the exponential curve in regression analyses and returns a value array describing this curve |
LOGINV | Statistical (2010 compatibility) | Returns the quantile of the log-normal distribution of x, where ln(x) is normally distributed with the parameters mean and standard_dev |
LOGNORM.DIST (2010) | Statistical | See LOGNORMDIST |
LOGNORM.INV (2010) | Statistical | See LOGINV |
LOGNORMDIST | Statistical | Returns values of the distribution function of a log-normal distributed random variable, where ln(x) is normally distributed with the parameters mean and standard_dev |
LOOKUP | Lookup & Reference | Searches for values from a vector or matrix |
LOWER | Text & Data | Converts text into lowercase |
MATCH | Lookup & Reference | Searches for values within a reference or matrix |
MAX | Statistical | Returns the highest value in an argument list |
MAXA | Statistical | Returns the highest value from an argument list, including numbers, text, and logical values |
MDETERM | Math & Trigonometry | Returns the determinant of a matrix |
MDURATION | Financial | Returns the modified duration for a security |
MEDIAN | Statistical | Returns the median of numbers from an argument list |
MID | Text & Data | Returns the number of characters in a string starting at the indicated position based on the specified number of characters |
MIN | Statistical | Returns the lowest value within an argument list |
MINA | Statistical | Returns the lowest value from an argument list, including numbers, text, and logical values |
MINUTE | Date & Time | Converts a serial number (time) into a minute number |
MINVERSE | Math & Trigonometry | Returns the inverse of a matrix |
MIRR | Financial | Returns the modified internal interest rate for positive and negative cash flows financed to different interest rates |
MMULT | Math & Trigonometry | Returns the product of two matrices |
MOD | Math & Trigonometry | Returns the remainder of a division operation; the result has the same algebraic sign as the divisor |
MODE | Statistical (2010 compatibility) | Returns the most frequent value of a data group |
MODE.MULT (2010) | Statistical | Returns a vertical array of the most frequent values in an array or a data range |
MODE.SNGL (2010) | Statistical | See MODE |
MONTH | Date & Time | Converts a serial number (date) into a month number |
MROUND | Math & Trigonometry | Returns a number rounded to a multiple |
MULTINOMINAL | Math & Trigonometry | Returns the polynomial coefficient of a number group |
N | Information | Returns a value converted into a number |
NA | Information | Returns the error value |
NEGBINOM.DIST (2010) | Statistical | See NEGBINOMDIST |
NEGBINOMDIST | Statistical (2010 compatibility) | Returns the probabilities of a negative binomial distributed random variable |
NETWORKDAYS | Date & Time | Returns the number of workdays within a time interval |
NETWORKDAY.INTL (2010) | Date & Time | Returns the number of workdays within a time interval considering the weekend definition |
NOMINAL | Financial | Returns the annual nominal interest based on the effective interest rate and the number of annual interest periods |
NORM.DIST (2010) | Statistical | See NORMDIST |
NORM.INV (2010) | Statistical | See NORMINV |
NORM.S.DIST (2010) | Statistical | See NORMSDIST |
NORM.S.INV (2010) | Statistical | See NORMSINV |
NORMDIST | Statistical (2010 compatibility) | Returns the normal distribution for an average value and a standard variance |
NORMINV | Statistical (2010 compatibility) | Returns the quantile of the normal distribution |
NORMSDIST | Statistical (2010 compatibility) | Returns the values of the distribution function of a standard normally distributed random variable |
NORMSINV | Statistical (2010 compatibility) | Returns the quantile of the standard normal distribution |
NOT | Logical | Reverts the value of an argument |
NOW | Date & Time | Returns the serial number of the current date and time |
NPER | Financial | Returns the number of payment periods for an investment based on periodical invariable payments and an invariable interest rate |
NPV | Financial | Returns the capital value of an investment based on a discount factor for several periodic payments |
OCT2BIN | Engineering | Converts an octal number into a binary number |
OCT2DEC | Engineering | Converts an octal number into a decimal number |
OCT2HEX | Engineering | Converts an octal number into a hexadecimal number |
ODD | Math & Trigonometry | Rounds a number to the next odd integer |
ODDFPRICE | Financial | Returns the price per $100 par value of a security with an odd first interest date |
ODDFYIELD | Financial | Returns the yield of a security with an odd first interest date |
ODDLPRICE | Financial | Returns the price per $100 par value of a security with an odd last interest date |
ODDLYIELD | Financial | Returns the yield of a security with an odd last interest date |
OFFSET | Lookup & Reference | Returns a reference offset from the specified reference |
OR | Logical | Returns |
PEARSON | Statistical | Returns the Pearson correlation coefficient r |
PERCENTILE | Statistical (2010 compatibility) | Returns the alpha quantile of a data group |
PERCENTILE.EXC (2010) | Statistical | Returns the k-quantile of a data group where k is between 0 and 1, excluding 0 and 1 |
PERCENTILE.INC (2010) | Statistical | Returns the k-quantile of a data group where k can be between 0 and 1, including 0 and 1 |
PERCENTRANK | Statistical (2010 compatibility) | Returns the rank of a value (alpha) as a percentage |
PERCENTRANK.EXC (2010) | Statistical | Returns the rank of a value (alpha) as a percentage between 0 and 1 |
PERCENTRANK.INC (2010) | Statistical | Returns the rank of a value (alpha) as a percentage including 0 and 1 |
PERMUT | Statistical | Returns the number of possibilities to query k elements from a n element set |
PHONETIC | Text & Data | Extracts the phonetic (Furigana) characters from a string |
PI | Math & Trigonometry | Returns the value of Pi, 3.14159265358979, accurate to 15 digits |
PMT | Financial | Returns the invariable payment of an annuity per period assuming invariable payments and an invariable interest rate |
POISSON | Statistical (2010 compatibility) | Returns the probabilities of a Poisson-distributed random variable |
POISSON.DIST (2010) | Statistical | See POISSON |
POWER | Math & Trigonometry | Returns an exponentiated number |
PPMT | Financial | Returns the repayment of principal of an investment for the indicated period |
PRICE | Financial | Returns the price per $100 par value of a security that pays periodic interest |
PRICEDISC | Financial | Returns the price per $100 par value of a noninterest security |
PRICEMAT | Financial | Returns the price per $100 par value of a security that pays interest at maturity |
PROB | Statistical | Returns the probability for an interval enclosed in two values |
PRODUCT | Math & Trigonometry | Multiplies the arguments and returns the product |
PROPER | Text & Data | Converts the first character of all words in a string into uppercase and all other characters into lowercase |
PV | Financial | Returns the cash value of an investment |
QUARTILE | Statistical (2010 compatibility) | Returns the quartile of a data group |
QUARTILE.EXC (2010) | Statistical | Returns the quartile of a data group only based on 0 to 1 |
QUARTILE.INC (2010) | Statistical | Returns the quartile of a data group including 0 and 1 |
QUOTIENT | Math & Trigonometry | Returns the integer part of a division operation |
RADIANS | Math & Trigonometry | Converts degrees into radian measures |
RAND | Math & Trigonometry | Returns a random number between 0 and 1 |
RANDBETWEEN | Math & Trigonometry | Returns a random integer from an indicated range |
RANK | Statistical (2010 compatibility) | Returns the rank of a number within a list of numbers |
RANK.AVG (2010) | Statistical | Returns the average rank of a number within a list of numbers |
RANK.EQ (2010) | Statistical | See RANK |
RATE | Financial | Returns the interest rate of an annuity per period |
RECEIVED | Financial | Returns the interest rate of a fully invested security |
REPLACE | Text & Data | Replaces part of a string with another string based on the specified number of characters |
REPLACEB | Text & Data | Replaces part of a string with another string based on the specified number of bytes |
REPT | Text & Data | Repeats text a specified number of times |
RIGHT | Text & Data | Returns the last character(s) of a string based on the specified number of characters |
ROMAN | Math & Trigonometry | Converts an Arabic number into a roman numeral |
ROUND | Math & Trigonometry | Rounds a number to a certain number of decimal places |
ROUNDDOWN | Math & Trigonometry | Rounds a number down to num_digits |
ROUNDUP | Math & Trigonometry | Rounds a number up to num_digits |
ROW | Lookup & Reference | Returns the row number of a reference |
ROWS | Lookup & Reference | Returns the number of rows within a reference or matrix |
RSQ | Statistical | Returns the square of the Pearson correlation coefficient according to the data points in known_y and known_x |
RTD | Lookup & Reference | Retrieves real-time data from a program supporting COM automation |
SEARCH | Text & Data | Returns the number of a character beginning with the start_num at which the wanted character or string was found first |
SECOND | Date & Time | Converts a serial number (time) into a second number |
SERIESSUM | Math & Trigonometry | Returns the sum of a power series |
SIGN | Math & Trigonometry | Returns the algebraic sign of a number |
SIN | Math & Trigonometry | Returns the sine of a number |
SINH | Math & Trigonometry | Returns the hyperbolic sine of a number |
SKEW | Statistical | Returns the skewness of a distribution |
SLN | Financial | Returns the linear depreciation of an asset per period |
SLOPE | Statistical | Returns the slope of the regression line adjusted to the data points in known_y and known_x |
SMALL | Statistical | Returns the lowest k-value of a data group |
SQRT | Math & Trigonometry | Returns the square root of a number |
SQRTPI | Math & Trigonometry | Returns the root of number multiplied by pi |
STANDARDIZE | Statistical | Returns the standardized value of a distribution characterized by an average value and a standard variance |
STDEV | Statistical (2010 compatibility) | Estimates the standard variance based on a sample |
STDEV.P (2010) | Statistical | See STDEVP |
STDEV.S (2010) | Statistical | See STDEV |
STDEVA | Statistical | Estimates the standard variance based on a sample |
STDEVP | Statistical (2010 compatibility) | Calculates the standard variance based on the population |
STDEVPA | Statistical | Calculates the standard variance based on a population indicated as arguments, including text and logical values |
STEYX | Statistical | Returns the standard error of the predicted y-values for each x in a regression |
SUBSTITUTE | Text & Data | Replaces old text in a string with new text |
SUBTOTAL | Math & Trigonometry | Returns a partial result in a list or database |
SUM | Math & Trigonometry | Adds arguments |
SUMIF | Math & Trigonometry | Adds numbers matching the search criteria |
SUMIFS | Math & Trigonometry | Adds numbers matching several search criteria |
SUMPRODUCT | Math & Trigonometry | Multiplies the matching components of the indicated matrices and returns the sum of these products |
SUMSQ | Math & Trigonometry | Adds squared arguments |
SUMX2MY2 | Math & Trigonometry | Adds the differences between the squares of two corresponding matrices |
SUMX2PY2 | Math & Trigonometry | Adds the sum of the squares of two corresponding matrices |
SUMXMY2 | Math & Trigonometry | Adds the squares of the differences of two corresponding matrices |
SYD | Financial | Returns the arithmetic degressive depreciation of an asset for a specified period |
T | Text & Data | Converts arguments into text |
T.DIST (2010) | Statistical | Returns the Student’s t-distribution of the left end range |
T.DIST.2T (2010) | Statistical | Returns the Student’s t-distribution of two end ranges |
T.DIST.RT (2010) | Statistical | Returns the Student’s t-distribution of the right end range |
T.INV (2010) | Statistical | See TINV |
T.INV.2T (2010) | Statistical | See TINV |
T.TEST (2010) | Statistical | See TTEST |
TAN | Math & Trigonometry | Returns the tangent of a number |
TANH | Math & Trigonometry | Returns the hyperbolic tangent of a number |
TBILLEQ | Financial | Converts the interest for a treasury bill into the annual simple interest common for bonds |
TBILLPRICE | Financial | Returns the price per $100 par value of a treasury bill |
TBILLYIELD | Financial | Returns the yield of a treasury bill |
TDIST | Statistical (2010 compatibility) | Returns the values of a distribution function (1 alpha) of a Student’s t-distributed random variable |
TEXT | Text & Data | Formats a number and converts it into text |
TIME | Date & Time | Returns the decimal number of a certain time |
TIMEVALUE | Date & Time | Converts a time formatted as text into a serial number (time) |
TINV | Statistical (2010 compatibility) | Returns the t-value of the t-distribution as a probability and degrees of freedom |
TODAY | Date & Time | Returns the serial number for the current date |
TRANSPOSE | Lookup & Reference | Returns the transposed matrix of the indicated matrix |
TREND | Statistical | Returns values from a linear trend |
TRIM | Text & Data | Deletes the spaces in the text not used as separators between words |
TRIMMEAN | Statistical | Returns the average value of a data group without considering the marginal values |
TRUE | Logical | Returns the logical value |
TRUNC | Math & Trigonometry | Truncates the decimal places of a number and returns an integer |
TTEST | Statistical (2010 compatibility) | Returns the test statistics of a Student’s t-test |
TYPE | Information | Returns a number indicating the data type of a given value |
UPPER | Text & Data | Converts text into uppercase |
VALUE | Text & Data | Converts a text argument into a number |
VAR | Statistical (2010 compatibility) | Estimates the variance based on a sample |
VAR.P (2010) | Statistical | See VARP |
VAR.S (2010) | Statistical | See VAR |
VARA | Statistical | Estimates the variance based on a sample |
VARP | Statistical (2010 compatibility) | Calculates the variance based on the population |
VARPA | Statistical | Calculates the variance based on the population, including numbers, text, and logical values |
VDB | Financial | Returns the double-declining–balance depreciation of an asset for a given period or a partial period |
VLOOKUP | Lookup & Reference | Searches for a value in the left table column and returns a value from the column you specify in the table |
WEEKDAY | Date & Time | Converts a serial number into a weekday number, ranging from 1 to 7 |
WEEKNUM | Date & Time | Returns a number indicating the week with the specified data |
WEIBULL | Statistical (2010 compatibility) | Returns the probabilities of a Weibull-distributed random variable |
WEIBULL.DIST (2010) | Statistical | See WEIBULL |
WORKDAY | Date & Time | Returns the date as a continuous day in the year before or after a certain number of workdays |
WORKDAY.INTL (2010) | Date & Time | Returns the date as a continuous day in the year before or after a certain number of workdays, considering the weekend definition for the date |
XIRR | Financial | Returns the internal interest rate for a series of nonperiodic payments |
XNPV | Financial | Returns the capital value for a series of nonperiodic payments |
YEAR | Date & Time | Converts a serial number (date) into a year number |
YEARFRAC | Date & Time | Converts the number of whole days between the start and end dates in year fractions |
YIELD | Financial | Returns the yield of a security that pays periodic interest |
YIELDDISC | Financial | Returns the annual yield of a noninterest security |
YIELDMAT | Financial | Returns the annual yield of a security that pays interest at maturity |
Z.TEST (2010) | Statistical | Returns the one-tailed probability value for a Gauss test (normal distribution) |
ZTEST | Statistical (2010 compatibility) | Returns the one-tailed probability value for a Gauss test (normal distribution) |