*HOME*
Complete List of Excel Functions

**ABS
**Returns the absolute value of a
number (removes + or - 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
**ACOSH **Returns the inverse hyperbolic
cosine of a number
**ADDRESS **Returns a reference as text to
a single cell in a worksheet
**AMORDEGRC **Returns the depreciation for
each accounting period by using a depreciation coefficient
**AMORLINC **Returns the depreciation for
each accounting period
**AND **Returns the value TRUE if all of the
arguments are TRUE
**AREAS **Returns the number of areas in
a reference
**ASC **Changes full-width
(double-byte) English letters or katakana within a character string to
half-width (single-byte) characters
**ASIN **Returns the arcsine of a number
**ASINH **Returns the inverse hyperbolic
sine of a number
**ATAN **Returns the arctangent of a
number
**ATAN2 **Returns the arctangent from x-
and y-coordinates
**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 of its
arguments
**AVERAGEA **Returns the average of its
arguments, including numbers, text, and logical values
**BAHTTEXT **Converts a number to text,
using the ? (baht) currency format
**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 beta cumulative
distribution function
**BETAINV **Returns the inverse of the
cumulative distribution function for a specified beta distribution
**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
**CEILING **Rounds a number to the nearest
integer or to the nearest multiple of significance
**Cell **Returns info about the
format, location, or contents of a cell
**CHAR **Returns the character specified
by the code number
**CHIDIST **Returns the one-tailed
probability of the chi-squared distribution
**CHIINV **Returns the inverse of the
one-tailed probability of the chi-squared distribution
**CHITEST **Returns the test for
independence
**CHOOSE **Chooses a value from a list of
values
**CLEAN **Removes all nonprintable
characters from text
**Clean **Removes all nonprintable
characters from text
**CODE **Returns a numeric code for the
first character in a text string
**COLUMN **Returns the column number of a
reference
**COLUMNS **Returns the number of columns
in a reference
**COMBIN **Returns the number of
combinations for a given number of objects
**COMPLEX **Converts real and imaginary
coefficients into a complex number
**Concatenate **Joins multiple text items into
one text item
**CONFIDENCE **Returns the confidence interval
for a population mean
**CONVERT **Converts a number from one
measurement system to another
**CORREL **Returns the correlation
coefficient between two data sets
**COS **Returns the cosine of a number
**COSH **Returns the hyperbolic cosine
of a number
**COUNT **Counts how many numbers are in
the list of arguments
**COUNTA **Counts how many values are in
the list of arguments
**COUNTBLANK **Counts the number of blank
cells within a range
**COUNTIF **Counts the number of nonblank
cells within a range that meet the given 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
**COVAR **Returns covariance, the average
of the products of paired deviations
**CRITBINOM **Returns the smallest value for
which the cumulative binomial distribution is less than or equal to a
criterion value
**CUMIPMT **Returns the cumulative interest
paid between two periods
**CUMPRINC **Returns the cumulative
principal paid on a loan between two periods
**DATE **Returns the serial number of a
particular date
**DATEVALUE **Converts a date in the form of
text to a serial number
**DAVERAGE **Returns the average of selected
database entries
**DAY **Converts a serial number to a
day of the month
**DAYS360 **Calculates the number of days
between two dates based on a 360-day year
**DB **Returns the depreciation of an
asset for a specified period by using the fixed-declining balance
method
**DCOUNT **Counts the cells that contain
numbers in a database
**DCOUNTA **Counts nonblank cells in a
database
**DDB **Returns the depreciation of an
asset for a specified period by using the double-declining balance
method or some other method that you specify
**DEC2BIN **Converts a decimal number to
binary
**DEC2HEX **Converts a decimal number to
hexadecimal
**DEC2OCT **Converts a decimal number to
octal
**DEGREES **Converts radians to degrees
**DELTA **Tests whether two values are
equal
**DEVSQ **Returns the sum of squares of
deviations
**DGET **Extracts from a database a
single record that matches the specified criteria
**DISC **Returns the discount rate for a
security
**DMAX **Returns the maximum value from
selected database entries
**DMIN **Returns the minimum value from
selected database entries
**DOLLAR **Converts a number to text,
using the $ (dollar) 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 a
particular field of records that match the criteria in a database
**DSTDEV **Estimates the standard
deviation based on a sample of 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 criteria
**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
**EDATE **Returns the serial number of
the date that is 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
**ERROR.TYPE **Returns a number corresponding
to an error type
**EUROCONVERT **Converts a number to euros,
converts a number from euros to a euro member currency, or converts a
number from one euro member currency to another by using the euro as an
intermediary (triangulation)
**EVEN **Rounds a number up to the
nearest even integer
**EXACT **Checks to see if two text
values are identical
**EXP **Returns e raised to the power
of a given number
**EXPONDIST **Returns the exponential
distribution
**FACT **Returns the factorial of a
number
**FACTDOUBLE **Returns the double factorial of
a number
**FALSE **Returns the logical value FALSE
**FDIST **Returns the F probability
distribution
**FIND, **FINDB Finds one text value
within another (case-sensitive)
**FINV **Returns the inverse of the F
probability distribution
**FISHER **Returns the Fisher
transformation
**FISHERINV **Returns the inverse of the
Fisher transformation
**FIXED **Formats a number as text with a
fixed number of decimals
**FLOOR **Rounds a number down, toward
zero
**FORECAST **Returns a value along a linear
trend
**FREQUENCY **Returns a frequency
distribution as a vertical array
**FTEST **Returns the result of an F-test
**FV **Returns the future value of an
investment
**FVSCHEDULE **Returns the future value of an
initial principal after applying a series of compound interest rates
**GAMMADIST **Returns the gamma distribution
**GAMMAINV **Returns the inverse of the
gamma cumulative distribution
**GAMMALN **Returns the natural logarithm
of the gamma function, G(x)
**GCD **Returns the greatest common
divisor
**GEOMEAN **Returns the geometric mean
**GESTEP **Tests whether a number is
greater than a threshold value
**GETPIVOTDATA **Returns data stored in a
PivotTable
**GROWTH **Returns values along an
exponential trend
**HARMEAN **Returns the harmonic mean
**HEX2BIN **Converts a hexadecimal number
to binary
**HEX2DEC **Converts a hexadecimal number
to decimal
**HEX2OCT **Converts a hexadecimal number
to octal
**HLOOKUP
**Looks
in the top row of an
array and returns the value of the indicated cell
**HOUR **Converts a serial number to an
hour
**HYPERLINK **Creates a shortcut or jump that
opens a document stored on a network server, an intranet, or the
Internet
**HYPGEOMDIST **Returns the hypergeometric
distribution
**IF **Specifies a logical test to
perform
**IMABS **Returns the absolute value
(modulus) of a complex number
**IMAGINARY **Returns the imaginary
coefficient of a complex number
**IMARGUMENT **Returns the argument theta, an
angle expressed in radians
**IMCONJUGATE **Returns the complex conjugate
of a complex number
**IMCOS **Returns the cosine 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 from 2
to 29 complex numbers
**IMREAL **Returns the real coefficient of
a complex number
**IMSIN **Returns the sine of a complex
number
**IMSQRT **Returns the square root of a
complex number
**IMSUB **Returns the difference between
two complex numbers
**IMSUM **Returns the sum of complex
numbers
**INDEX **Uses an index to choose a value
from a reference or array
**INDIRECT **Returns a reference indicated
by a text value
**INFO **Returns information about the
current operating environment
**INT **Rounds a number down to the
nearest integer
**INTERCEPT **Returns the intercept of the
linear regression line
**INTRATE **Returns the interest rate for a
fully invested security
**IPMT **Returns the interest payment
for an investment for a given period
**IRR **Returns the internal rate of
return for a series of cash flows
**ISBLANK **Returns TRUE if the value is
blank
**ISERR **#N/A
**ISERROR **Returns TRUE if the value is
any error value
**ISEVEN **Returns TRUE if the number is
even
**ISLOGICAL **Returns TRUE if the value is a
logical value
**ISNA **#N/A
**ISNONTEXT **Returns TRUE if the value is
not text
**ISNUMBER **Returns TRUE if the value is a
number
**ISODD **Returns TRUE if the number is
odd
**ISPMT **Calculates the interest paid
during a specific period of an investment
**ISREF **Returns TRUE if the value is a
reference
**ISTEXT **Returns TRUE if the value is
text
**JIS **Changes half-width
(single-byte) English letters or katakana within a character string to
full-width (double-byte) characters
**KURT **Returns the kurtosis of a data
set
**LARGE **Returns the k-th largest value
in a data set
**LCM **Returns the least common
multiple
**LEFT, **LEFTB Returns the leftmost
characters from a text value
**LEN, **LENB Returns the number of
characters in a text string
**LINEST **Returns the parameters of a
linear trend
**LN **Returns the natural logarithm
of a number
**LOG **Returns the logarithm of a
number to a specified base
**LOG10 **Returns the base-10 logarithm
of a number
**LOGEST **Returns the parameters of an
exponential trend
**LOGINV **Returns the inverse of the
lognormal distribution
**LOGNORMDIST **Returns the cumulative
lognormal distribution
**LOOKUP **Looks up values in a vector or
array
**LOWER **Converts text to lowercase
**MATCH **Looks up values in a reference
or array
**MAX **Returns the maximum value in a
list of arguments
**MAXA **Returns the maximum value in a
list of arguments, including numbers, text, and logical values
**MDETERM **Returns the matrix determinant
of an array
**MDURATION **Returns the Macauley modified
duration for a security with an assumed par value of 100
**MEDIAN **Returns the median of the given
numbers
**MID, **MIDB Returns a specific number
of characters from a text string starting at the position you specify
**MIN **Returns the minimum value in a
list of arguments
**MINA **Returns the smallest value in a
list of arguments, including numbers, text, and logical values
**MINUTE **Converts a serial number to a
minute
**MINVERSE **Returns the matrix inverse of
an array
**MIRR **Returns the internal rate of
return where positive and negative cash flows are financed at different
rates
**MMULT **Returns the matrix product of
two arrays
**MOD **Returns the remainder from
division
**MODE **Returns the most common value
in a data set
**MONTH **Converts a serial number to a
month
**MROUND **Returns a number rounded to the
desired multiple
**MULTINOMIAL **Returns the multinomial of a
set of numbers
**N **Returns a value converted to a
number
**NA **#N/A
**NEGBINOMDIST **Returns the negative binomial
distribution
**NETWORKDAYS **Returns the number of whole
workdays between two dates
**NOMINAL **Returns the annual nominal
interest rate
**NORMDIST **Returns the normal cumulative
distribution
**NORMINV **Returns the inverse of the
normal cumulative distribution
**NORMSDIST **Returns the standard normal
cumulative distribution
**NORMSINV **Returns the inverse of the
standard normal cumulative distribution
**NOT **Reverses the logic of its
argument
**NOW **Returns the serial number of
the current date and time
**NPER **Returns the number of periods
for an investment
**NPV **Returns the net present value
of an investment based on a series of periodic cash flows and a
discount rate
**OCT2BIN **Converts an octal number to
binary
**OCT2DEC **Converts an octal number to
decimal
**OCT2HEX **Converts an octal number to
hexadecimal
**ODD **Rounds a number up 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
**OFFSET **Returns a reference offset from
a given reference
**OR **Returns TRUE if any argument is
TRUE
**PEARSON **Returns the Pearson product
moment correlation coefficient
**PERCENTILE **Returns the k-th percentile of
values in a range
**Percentrank **Returns the percent rank of
a specific value in a data set
**PERMUT **Returns the number of
permutations for a given number of objects
**PHONETIC **Extracts the phonetic
(furigana) characters from a text string
**PI **Returns the value of pi
**PMT **Returns the periodic payment
for an annuity
**POISSON **Returns the Poisson
distribution
**POWER **Returns the result of a number
raised to a power
**PPMT **Returns the payment on the
principal for an investment for a given period
**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
**PROB **Returns the probability that
values in a range are between two limits
**PRODUCT **Multiplies its arguments
**PROPER **Capitalizes the first letter in
each word of a text value
**PV **Returns the present value of an
investment
**QUARTILE **Returns the quartile of a data
set
**QUOTIENT **Returns the integer portion of
a division
**RADIANS **Converts degrees to radians
**RAND **Returns a random number between
0 and 1
**RANDBETWEEN **Returns a random number between
the numbers you specify
**RANK **Returns the rank of a number in
a list of numbers
**RATE **Returns the interest rate per
period of an annuity
**RECEIVED **Returns the amount received at
maturity for a fully invested security
**REPLACE, **REPLACEB Replaces characters
within text
**REPT **Repeats text a given number of
times
**RIGHT, **RIGHTB Returns the rightmost
characters from a text value
**ROMAN **Converts an arabic numeral to
roman, as text
**ROUND **Rounds a number to a specified
number of digits
**ROUNDDOWN **Rounds a number down, toward
zero
**ROUNDUP **Rounds a number up, away from
zero
**ROW **Returns the row number of a
reference
**ROWS **Returns the number of rows in a
reference
**RSQ **Returns the square of the
Pearson product moment correlation coefficient
**RTD **Retrieves real-time data from a
program that supports COM automation (Automation: A way to work with an
application's objects from another application or development tool.
Formerly called OLE Automation, Automation is an industry standard and
a feature of the
**SEARCH, **SEARCHB Finds one text value
within another (not case-sensitive)
**SECOND **Converts a serial number to a
second
**SERIESSUM **Returns the sum of a power
series based on the formula
**SIGN **Returns the sign of a number
**SIN **Returns the sine of the given
angle
**SINH **Returns the hyperbolic sine of
a number
**SKEW **Returns the skewness of a
distribution
**SLN **Returns the straight-line
depreciation of an asset for one period
**SLOPE **Returns the slope of the linear
regression line
**SMALL **Returns the k-th smallest value
in a data set
**SQL.REQUEST **Connects with an external data
source and runs a query from a worksheet, then returns the result as an
array without the need for macro programming
**SQRT **Returns a positive square root
**SQRTPI **Returns the square root of
(number * pi)
**STANDARDIZE **Returns a normalized value
**STDEV **Estimates standard deviation
based on a sample
**STDEVA **Estimates standard deviation
based on a sample, including numbers, text, and logical values
**STDEVP **Calculates standard deviation
based on the entire population
**STDEVPA **Calculates standard deviation
based on the entire population, including numbers, text, and logical
values
**STEYX **Returns the standard error of
the predicted y-value for each x in the regression
**SUBSTITUTE **Substitutes new text for old
text in a text string
**SUBTOTAL **Returns a subtotal in a list or
database
**SUM **Adds its arguments
**SUMIF **Adds the cells specified by a
given criteria
**SUMPRODUCT **Returns the sum of the products
of corresponding array components
**SUMSQ **Returns the sum of the squares
of the arguments
**SUMX2MY2 **Returns the sum of the
difference of squares of corresponding values in two arrays
**SUMX2PY2 **Returns the sum of the sum of
squares of corresponding values in two arrays
**SUMXMY2 **Returns the sum of squares of
differences of corresponding values in two arrays
**SYD **Returns the sum-of-years'
digits depreciation of an asset for a specified period
**T **Converts its arguments to text
**TAN **Returns the tangent of a number
**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 **Formats a number and converts
it to text
**TIME **Returns the serial number of a
particular time
**TIMEVALUE **Converts a time in the form of
text to a serial number
**TINV **Returns the inverse of the
Student's t-distribution
**TODAY **Returns the serial number of
today's date
**TRANSPOSE **Returns the transpose of an
array
**TREND **Returns values along a linear
trend
**TRIM **Removes spaces from text
**TRIMMEAN **Returns the mean of the
interior of a data set
**TRUE **Returns the logical value TRUE
**TRUNC **Truncates a number to an
integer
**TTEST **Returns the probability
associated with a Student's t-test
**TYPE **Returns a number indicating the
data type of a value
**UPPER **Converts text to uppercase
**VALUE **Converts a text argument to a
number
**VAR **Estimates variance based on a
sample
**VARA **Estimates variance based on a
sample, including numbers, text, and logical values
**VARP **Calculates variance based on
the entire population
**VARPA **Calculates variance based on
the entire population, including numbers, text, and logical values
**VDB **Returns the depreciation of an
asset for a specified or partial period by using a declining balance
method
**VLOOKUP
**Looks in the first column of a set of data and finds a match, then moves across the row and returns a value in another column.
**WEEKDAY **Converts a serial number to a
day of the week
**WEEKNUM **Converts a serial number to a
number representing where the week falls numerically with a year
**WEIBULL **Returns the Weibull
distribution
**WORKDAY **Returns the serial number of
the date before or after a specified number of workdays
**XIRR **Returns the internal rate of
return for a schedule of cash flows that is not necessarily periodic
**XNPV **Returns the net present value
for a schedule of cash flows that is not necessarily periodic
**YEAR **Converts a serial number to a
year
**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
probability-value of a z-test