Ing. Ettore Masi
Worksheet Functions
(EXCEL 2007)
|
Category |
Function |
Description |
New? |
Help |
|
Cube |
Returns a member or tuple in a cube hierarchy |
TRUE |
||
|
Cube |
Returns an aggregated value from a cube |
TRUE |
||
|
Cube |
Defines a calculated set of members or tuples
by sending a set expression to the cube on the server |
TRUE |
||
|
Cube |
Returns the nth, or ranked, member in a set |
TRUE |
||
|
Cube |
CUBEKPIMEMBER |
Returns a key performance indicator name,
property, and measure, and displays the name and property in the cell. |
TRUE |
|
|
Cube |
Returns the value of a member property in the
cube |
TRUE |
||
|
Cube |
Returns the number of items in a set |
TRUE |
||
|
Database |
DAVERAGE |
Averages the values in a column of a list or
database that match conditions you specify |
FALSE |
|
|
Database |
DCOUNT |
Counts the cells that contain numbers in a
column of a list or database that match conditions you specify |
FALSE |
|
|
Database |
DCOUNTA |
Counts the nonblank cells in a column of a
list or database that match conditions you specify |
FALSE |
|
|
Database |
DGET |
Extracts a single value from a column of a
list or database that matches conditions you specify |
FALSE |
|
|
Database |
DMAX |
Returns the largest number in a column of a
list or database that matches conditions you specify |
FALSE |
|
|
Database |
DMIN |
Returns the smallest number in a column of a
list or database that matches conditions you specify |
FALSE |
|
|
Database |
DPRODUCT |
Multiplies the values in a column of a list or
database that match conditions you specify |
FALSE |
|
|
Database |
DSTDEV |
Estimates the standard deviation of a
population based on a sample by using the numbers in a column of a list or
database that match conditions you specify |
FALSE |
|
|
Database |
DSTDEVP |
Calculates the standard deviation of a
population based on the entire population, using the numbers in a column of a
list or database that match conditions you specify |
FALSE |
|
|
Database |
DSUM |
Adds the numbers in a column of a list or
database that match conditions you specify |
FALSE |
|
|
Database |
DVAR |
Estimates the variance of a population based
on a sample by using the numbers in a column of a list or database that match
conditions you specify |
FALSE |
|
|
Database |
DVARP |
Calculates the variance of a population based
on the entire population by using the numbers in a column of a list or
database that match conditions you specify |
FALSE |
|
|
Date & Time |
DATE |
Returns the serial number of a particular date |
FALSE |
|
|
Date & Time |
DATEVALUE |
Converts a date in the form of text to a
serial number |
FALSE |
|
|
Date & Time |
DAY |
Converts a serial number to a day of the month |
FALSE |
|
|
Date & Time |
DAYS360 |
Calculates the number of days between two
dates, based on a 360-day year |
FALSE |
|
|
Date & Time |
EDATE |
Returns the serial number of the date that is
the indicated number of months before or after the start date |
FALSE |
|
|
Date & Time |
EOMONTH |
Returns the serial number of the last day of
the month before or after a specified number of months |
FALSE |
|
|
Date & Time |
HOUR |
Converts a serial number to an hour |
FALSE |
|
|
Date & Time |
MINUTE |
Converts a serial number to a minute |
FALSE |
|
|
Date & Time |
MONTH |
Converts a serial number to a month |
FALSE |
|
|
Date & Time |
NETWORKDAYS |
Returns the number of whole workdays between
two dates |
FALSE |
|
|
Date & Time |
NOW |
Returns the serial number of the current date
and time |
FALSE |
|
|
Date & Time |
SECOND |
Converts a serial number to a second |
FALSE |
|
|
Date & Time |
TIME |
Returns the serial number of a particular time |
FALSE |
|
|
Date & Time |
TIMEVALUE |
Converts a time in the form of text to a
serial number |
FALSE |
|
|
Date & Time |
TODAY |
Returns the serial number of today’s date |
FALSE |
|
|
Date & Time |
WEEKDAY |
Converts a serial number to a day of the week |
FALSE |
|
|
Date & Time |
WEEKNUM |
Returns the week number in the year |
FALSE |
|
|
Date & Time |
WORKDAY |
Returns the serial number of the date before
or after a specified number of workdays |
FALSE |
|
|
Date & Time |
YEAR |
Converts a serial number to a year |
FALSE |
|
|
Date & Time |
YEARFRAC |
Returns the year fraction representing the
number of whole days between start_date
and end_date |
FALSE |
|
|
Engineering |
BESSELI |
Returns the modified Bessel function In(x) |
FALSE |
|
|
Engineering |
BESSELJ |
Returns the Bessel function Jn(x) |
FALSE |
|
|
Engineering |
BESSELK |
Returns the modified Bessel function Kn(x) |
FALSE |
|
|
Engineering |
BESSELY |
Returns the Bessel function Yn(x) |
FALSE |
|
|
Engineering |
BIN2DEC |
Converts a binary number to decimal |
FALSE |
|
|
Engineering |
BIN2HEX |
Converts a binary number to hexadecimal |
FALSE |
|
|
Engineering |
BIN2OCT |
Converts a binary number to octal |
FALSE |
|
|
Engineering |
COMPLEX |
Converts real and imaginary coefficients into
a complex number |
FALSE |
|
|
Engineering |
CONVERT |
Converts a number from one measurement system
to another |
FALSE |
|
|
Engineering |
DEC2BIN |
Converts a decimal number to binary |
FALSE |
|
|
Engineering |
DEC2HEX |
Converts a decimal number to hexadecimal |
FALSE |
|
|
Engineering |
DEC2OCT |
Converts a decimal number to octal |
FALSE |
|
|
Engineering |
DELTA |
Tests whether two values are equal |
FALSE |
|
|
Engineering |
ERF |
Returns the error function |
FALSE |
|
|
Engineering |
ERFC |
Returns the complementary error function |
FALSE |
|
|
Engineering |
GESTEP |
Tests whether a number is greater than a
threshold value |
FALSE |
|
|
Engineering |
HEX2BIN |
Converts a hexadecimal number to binary |
FALSE |
|
|
Engineering |
HEX2DEC |
Converts a hexadecimal number to decimal |
FALSE |
|
|
Engineering |
HEX2OCT |
Converts a hexadecimal number to octal |
FALSE |
|
|
Engineering |
IMABS |
Returns the absolute value (modulus) of a
complex number |
FALSE |
|
|
Engineering |
IMAGINARY |
Returns the imaginary coefficient of a complex
number |
FALSE |
|
|
Engineering |
IMARGUMENT |
Returns the argument theta, an angle
expressed in radians |
FALSE |
|
|
Engineering |
IMCONJUGATE |
Returns the complex conjugate of a complex
number |
FALSE |
|
|
Engineering |
IMCOS |
Returns the cosine of a complex number |
FALSE |
|
|
Engineering |
IMDIV |
Returns the quotient of two complex numbers |
FALSE |
|
|
Engineering |
IMEXP |
Returns the exponential of a complex number |
FALSE |
|
|
Engineering |
IMLN |
Returns the natural logarithm of a complex number |
FALSE |
|
|
Engineering |
IMLOG10 |
Returns the base-10 logarithm of a complex
number |
FALSE |
|
|
Engineering |
IMLOG2 |
Returns the base-2 logarithm of a complex
number |
FALSE |
|
|
Engineering |
IMPOWER |
Returns a complex number raised to an integer
power |
FALSE |
|
|
Engineering |
IMPRODUCT |
Returns the product of complex numbers |
FALSE |
|
|
Engineering |
IMREAL |
Returns the real coefficient of a complex
number |
FALSE |
|
|
Engineering |
IMSIN |
Returns the sine of a complex number |
FALSE |
|
|
Engineering |
IMSQRT |
Returns the square root of a complex number |
FALSE |
|
|
Engineering |
IMSUB |
Returns the difference of two complex numbers |
FALSE |
|
|
Engineering |
IMSUM |
Returns the sum of complex numbers |
FALSE |
|
|
Engineering |
OCT2BIN |
Converts an octal number to binary |
FALSE |
|
|
Engineering |
OCT2DEC |
Converts an octal number to decimal |
FALSE |
|
|
Engineering |
OCT2HEX |
Converts an octal number to hexadecimal |
FALSE |
|
|
Financial |
ACCRINT |
Returns the accrued interest for a security
that pays periodic interest |
FALSE |
|
|
Financial |
ACCRINTM |
Returns the accrued interest for a security
that pays interest at maturity |
FALSE |
|
|
Financial |
AMORDEGRC |
Returns the depreciation for each accounting
period |
FALSE |
|
|
Financial |
AMORLINC |
Returns the depreciation for each accounting
period (the depreciation coefficient depends on the life of the assets) |
FALSE |
|
|
Financial |
COUPDAYBS |
Returns the number of days from the beginning
of the coupon period to the settlement date |
FALSE |
|
|
Financial |
COUPDAYS |
Returns the number of days in the coupon
period that contains the settlement date |
FALSE |
|
|
Financial |
COUPDAYSNC |
Returns the number of days from the settlement
date to the next coupon date |
FALSE |
|
|
Financial |
COUPNCD |
Returns the next coupon date after the
settlement date |
FALSE |
|
|
Financial |
COUPNUM |
Returns the number of coupons payable between
the settlement date and maturity date |
FALSE |
|
|
Financial |
COUPPCD |
Returns the previous coupon date before the
settlement date |
FALSE |
|
|
Financial |
CUMIPMT |
Returns the cumulative interest paid between
two periods |
FALSE |
|
|
Financial |
CUMPRINC |
Returns the cumulative principal paid on a
loan between two periods |
FALSE |
|
|
Financial |
DB |
Returns the depreciation of an asset for a
specified period, using the fixed-declining-balance method |
FALSE |
|
|
Financial |
DDB |
Returns the depreciation of an asset for a
specified period, using the double-declining-balance method or some other
method that you specify |
FALSE |
|
|
Financial |
DISC |
Returns the discount rate for a security |
FALSE |
|
|
Financial |
DOLLARDE |
Converts a dollar price, expressed as a
fraction, into a dollar price, expressed as a decimal number |
FALSE |
|
|
Financial |
DOLLARFR |
Converts a dollar price, expressed as a
decimal number, into a dollar price, expressed as a fraction |
FALSE |
|
|
Financial |
DURATION |
Returns the annual duration of a security with
periodic interest payments |
FALSE |
|
|
Financial |
EFFECT |
Returns the effective annual interest rate |
FALSE |
|
|
Financial |
FVSCHEDULE |
Returns the future value of an initial
principal after applying a series of compound interest rates |
FALSE |
|
|
Financial |
INTRATE |
Returns the interest rate for a fully invested
security |
FALSE |
|
|
Financial |
IPMT |
Returns the interest payment for an investment
for a given period |
FALSE |
|
|
Financial |
IRR |
Returns the internal rate of return for a
series of cash flows |
FALSE |
|
|
Financial |
ISPMT |
Returns the interest associated with a
specific loan payment |
FALSE |
|
|
Financial |
MDURATION |
Returns the Macauley modified duration for a
security with an assumed par value of $100 |
FALSE |
|
|
Financial |
MIRR |
Returns the internal rate of return where
positive and negative cash flows are financed at different rates |
FALSE |
|
|
Financial |
NOMINAL |
Returns the annual nominal interest rate |
FALSE |
|
|
Financial |
NPER |
Returns the number of periods for an
investment |
FALSE |
|
|
Financial |
ODDFPRICE |
Returns the price per $100 face value of a
security with an odd first period |
FALSE |
|
|
Financial |
ODDFYIELD |
Returns the yield of a security with an odd
first period |
FALSE |
|
|
Financial |
ODDLPRICE |
Returns the price per $100 face value of a
security with an odd last period |
FALSE |
|
|
Financial |
ODDLYIELD |
Returns the yield of a security with an odd
last period |
FALSE |
|
|
Financial |
PRICE |
Returns the price per $100 face value of a
security that pays periodic interest |
FALSE |
|
|
Financial |
PRICEDISC |
Returns the price per $100 face value of a
discounted security |
FALSE |
|
|
Financial |
PRICEMAT |
Returns the price per $100 face value of a
security that pays interest at maturity |
FALSE |
|
|
Financial |
PV |
Returns the present value of an investment |
FALSE |
|
|
Financial |
RATE |
Returns the interest rate per period of an annuity |
FALSE |
|
|
Financial |
RECEIVED |
Returns the amount received at maturity for a
fully invested security |
FALSE |
|
|
Financial |
SLN |
Returns the straight-line depreciation of an
asset for one period |
FALSE |
|
|
Financial |
SYD |
Returns the sum-of-years’ digits depreciation
of an asset for a specified period |
FALSE |
|
|
Financial |
TBILLEQ |
Returns the bond-equivalent yield for a
Treasury bill |
FALSE |
|
|
Financial |
TBILLPRICE |
Returns the price per $100 face value for a
Treasury bill |
FALSE |
|
|
Financial |
TBILLYIELD |
Returns the yield for a Treasury bill |
FALSE |
|
|
Financial |
VDB |
Returns the depreciation of an asset for a
specified or partial period using a declining-balance method |
FALSE |
|
|
Financial |
XIRR |
Returns the internal rate of return for a
schedule of cash flows that is not necessarily periodic |
FALSE |
|
|
Financial |
XNPV |
Returns the net present value for a schedule
of cash flows that is not necessarily periodic |
FALSE |
|
|
Financial |
YIELD |
Returns the yield on a security that pays
periodic interest |
FALSE |
|
|
Financial |
YIELDDISC |
Returns the annual yield for a discounted
security, for example, a Treasury bill |
FALSE |
|
|
Financial |
YIELDMAT |
Returns the annual yield of a security that
pays interest at maturity |
FALSE |
|
|
Financial |
FV |
Returns the future value of an investment |
FALSE |
|
|
Financial |
NPV |
Returns the net present value of an investment
based on a series of periodic cash flows and a discount rate |
FALSE |
|
|
Financial |
PMT |
Returns the periodic payment for an annuity |
FALSE |
|
|
Financial |
PPMT |
Returns the payment on the principal for an
investment for a given period |
FALSE |
|
|
Information |
CELL |
Returns information about the formatting,
location, or contents of a cell |
FALSE |
|
|
Information |
ERROR.TYPE |
Returns a number corresponding to an error
type |
FALSE |
|
|
Information |
INFO |
Returns information about the current
operating environment |
FALSE |
|
|
Information |
ISEVEN |
Returns TRUE if the number is even |
FALSE |
|
|
Information |
ISODD |
Returns TRUE if the number is odd |
FALSE |
|
|
Information |
N |
Returns a value converted to a number |
FALSE |
|
|
Information |
NA |
Returns the error value #N/A |
FALSE |
|
|
Information |
TYPE |
Returns a number indicating the data type of a
value |
FALSE |
|
|
Information |
ISBLANK |
Returns TRUE if the value is blank |
FALSE |
|
|
Information |
ISERR |
Returns TRUE if the value is any error value
except #N/A |
FALSE |
|
|
Information |
ISERROR |
Returns TRUE if the value is any error value |
FALSE |
|
|
Information |
ISLOGICAL |
Returns TRUE if the value is a logical value |
FALSE |
|
|
Information |
ISNA |
Returns TRUE if the value is the #N/A error
value |
FALSE |
|
|
Information |
ISNONTEXT |
Returns TRUE if the value is not text |
FALSE |
|
|
Information |
ISNUMBER |
Returns TRUE if the value is a number |
FALSE |
|
|
Information |
ISREF |
Returns TRUE if the value is a reference |
FALSE |
|
|
Information |
ISTEXT |
Returns TRUE if the value is text |
FALSE |
|
|
Logical |
IFERROR |
Returns a different result if the first
argument evaluates to an error |
TRUE |
|
|
Logical |
FALSE |
Returns the logical value FALSE |
FALSE |
|
|
Logical |
NOT |
Reverses the logic of its argument |
FALSE |
|
|
Logical |
OR |
Returns TRUE if any argument is TRUE |
FALSE |
|
|
Logical |
TRUE |
Returns the logical value TRUE |
FALSE |
|
|
Logical |
AND |
Returns TRUE if all its arguments are TRUE |
FALSE |
|
|
Logical |
IF |
Specifies a logical test to perform |
FALSE |
|
|
Lookup & Reference |
ADDRESS |
Returns a reference as text to a single cell
in a worksheet |
FALSE |
|
|
Lookup & Reference |
AREAS |
Returns the number of areas in a reference |
FALSE |
|
|
Lookup & Reference |
COLUMN |
Returns the column number of a reference |
FALSE |
|
|
Lookup & Reference |
COLUMNS |
Returns the number of columns in a reference |
FALSE |
|
|
Lookup & Reference |
HLOOKUP |
Searches for a value in the top column of a
table and then returns a value in the same column from a row you specify in
the table |
FALSE |
|
|
Lookup & Reference |
HYPERLINK |
Creates a shortcut that opens a document on
your hard drive, a server, or the Internet |
FALSE |
|
|
Lookup & Reference |
INDIRECT |
Returns a reference indicated by a text value |
FALSE |
|
|
Lookup & Reference |
MATCH |
Returns the relative position of an item in an
array |
FALSE |
|
|
Lookup & Reference |
OFFSET |
Returns a reference offset from a given
reference |
FALSE |
|
|
Lookup & Reference |
ROWS |
Returns the number of rows in a reference |
FALSE |
|
|
Lookup & Reference |
RTD |
Returns real-time data from a program that
supports COM automation |
FALSE |
|
|
Lookup & Reference |
GETPIVOTDATA |
Returns data stored in a PivotTable |
FALSE |
|
|
Lookup & Reference |
CHOOSE |
Chooses a value from a list of values |
FALSE |
|
|
Lookup & Reference |
INDEX |
Uses an index to choose a value from a
reference or array |
FALSE |
|
|
Lookup & Reference |
LOOKUP |
Returns a value either from a one-row or
one-column range or from an array |
FALSE |
|
|
Lookup & Reference |
ROW |
Returns the row number of a reference |
FALSE |
|
|
Lookup & Reference |
TRANSPOSE |
Returns the transpose of an array |
FALSE |
|
|
Lookup & Reference |
VLOOKUP |
Searches for a value in the leftmost column of
a table and then returns a value in the same row from a column you specify in
the table |
FALSE |
|
|
Math & Trig |
SUMIFS |
Adds the cells specified by a multiple
criteria |
TRUE |
|
|
Math & Trig |
ABS |
Returns the absolute value of a number |
FALSE |
|
|
Math & Trig |
ACOS |
Returns the arccosine of a number |
FALSE |
|
|
Math & Trig |
ACOSH |
Returns the inverse hyperbolic cosine of a
number |
FALSE |
|
|
Math & Trig |
ASIN |
Returns the arcsine of a number |
FALSE |
|
|
Math & Trig |
ASINH |
Returns the inverse hyperbolic sine of a
number |
FALSE |
|
|
Math & Trig |
ATAN |
Returns the arctangent of a number |
FALSE |
|
|
Math & Trig |
ATAN2 |
Returns the arctangent from x and y
coordinates |
FALSE |
|
|
Math & Trig |
ATANH |
Returns the inverse hyperbolic tangent of a
number |
FALSE |
|
|
Math & Trig |
CEILING |
Rounds a number to the nearest integer or to
the nearest multiple of significance |
FALSE |
|
|
Math & Trig |
COMBIN |
Returns the number of combinations for a given
number of objects |
FALSE |
|
|
Math & Trig |
COS |
Returns the cosine of a number |
FALSE |
|
|
Math & Trig |
COSH |
Returns the hyperbolic cosine of a number |
FALSE |
|
|
Math & Trig |
DEGREES |
Converts radians to degrees |
FALSE |
|
|
Math & Trig |
EVEN |
Rounds a number up to the nearest even integer |
FALSE |
|
|
Math & Trig |
EXP |
Returns e raised to the power of a
given number |
FALSE |
|
|
Math & Trig |
FACT |
Returns the factorial of a number |
FALSE |
|
|
Math & Trig |
FACTDOUBLE |
Returns the double factorial of a number |
FALSE |
|
|
Math & Trig |
FLOOR |
Rounds a number down, toward 0 |
FALSE |
|
|
Math & Trig |
GCD |
Returns the greatest common divisor |
FALSE |
|
|
Math & Trig |
INT |
Rounds a number down to the nearest integer |
FALSE |
|
|
Math & Trig |
LCM |
Returns the least common multiple |
FALSE |
|
|
Math & Trig |
LN |
Returns the natural logarithm of a number |
FALSE |
|
|
Math & Trig |
LOG |
Returns the logarithm of a number to a
specified base |
FALSE |
|
|
Math & Trig |
LOG10 |
Returns the base-10 logarithm of a number |
FALSE |
|
|
Math & Trig |
MDETERM |
Returns the matrix determinant of an array |
FALSE |
|
|
Math & Trig |
MOD |
Returns the remainder from division |
FALSE |
|
|
Math & Trig |
MROUND |
Returns a number rounded to the desired
multiple |
FALSE |
|
|
Math & Trig |
MULTINOMIAL |
Returns the multinomial of a set of numbers |
FALSE |
|
|
Math & Trig |
ODD |
Rounds a number up to the nearest odd integer |
FALSE |
|
|
Math & Trig |
PI |
Returns the value of pi |
FALSE |
|
|
Math & Trig |
POWER |
Returns the result of a number raised to a
power |
FALSE |
|
|
Math & Trig |
PRODUCT |
Multiplies its arguments |
FALSE |
|
|
Math & Trig |
QUOTIENT |
Returns the integer portion of a division |
FALSE |
|
|
Math & Trig |
RADIANS |
Converts degrees to radians |
FALSE |
|
|
Math & Trig |
RAND |
Returns a random number between 0 and 1 |
FALSE |
|
|
Math & Trig |
RANDBETWEEN |
Returns a random number between the numbers
that you specify |
FALSE |
|
|
Math & Trig |
ROMAN |
Converts an Arabic numeral to Roman, as text |
FALSE |
|
|
Math & Trig |
ROUND |
Rounds a number to a specified number of
digits |
FALSE |
|
|
Math & Trig |
ROUNDDOWN |
Rounds a number down, toward 0 |
FALSE |
|
|
Math & Trig |
ROUNDUP |
Rounds a number up, away from 0 |
FALSE |
|
|
Math & Trig |
SERIESSUM |
Returns the sum of a power series based on the
formula |
FALSE |
|
|
Math & Trig |
SIGN |
Returns the sign of a number |
FALSE |
|
|
Math & Trig |
SIN |
Returns the sine of the given angle |
FALSE |
|
|
Math & Trig |
SQRT |
Returns a positive square root |
FALSE |
|
|
Math & Trig |
SQRTPI |
Returns the square root of pi |
FALSE |
|
|
Math & Trig |
SUBTOTAL |
Returns a subtotal in a list or database |
FALSE |
|
|
Math & Trig |
SUM |
Adds its arguments |
FALSE |
|
|
Math & Trig |
SUMIF |
Adds the cells specified by a given criteria |
FALSE |
|
|
Math & Trig |
SUMPRODUCT |
Returns the sum of the products of
corresponding array components |
FALSE |
|
|
Math & Trig |
SUMSQ |
Returns the sum of the squares of the
arguments |
FALSE |
|
|
Math & Trig |
SUMX2MY2 |
Returns the sum of the difference of squares
of corresponding values in two arrays |
FALSE |
|
|
Math & Trig |
SUMX2PY2 |
Returns the sum of the sum of squares of
corresponding values in two arrays |
FALSE |
|
|
Math & Trig |
SUMXMY2 |
Returns the sum of squares of differences of
corresponding values in two arrays |
FALSE |
|
|
Math & Trig |
TAN |
Returns the tangent of a number |
FALSE |
|
|
Math & Trig |
TANH |
Returns the hyperbolic tangent of a number |
FALSE |
|
|
Math & Trig |
TRUNC |
Truncates a number (you specify the precision
of the truncation) |
FALSE |
|
|
Math & Trig |
MINVERSE |
Returns the matrix inverse of an array |
FALSE |
|
|
Math & Trig |
MMULT |
Returns the matrix product of two arrays |
FALSE |
|
|
Math & Trig |
SINH |
Returns the hyperbolic sine of a number |
FALSE |
|
|
Statistical |
AVERAGEIF |
Returns the average for the cells specified by
a given criterion |
TRUE |
|
|
Statistical |
AVERAGEIFS |
Returns the average for the cells specified by
multiple criteria |
TRUE |
|
|
Statistical |
COUNTIFS |
Counts the number of cells that meet multiple
criteria |
TRUE |
|
|
Statistical |
COUNTBLANK |
Counts the number of blank cells in the
argument range |
FALSE |
|
|
Statistical |
AVEDEV |
Returns the average of the absolute deviations
of data points from their mean |
FALSE |
|
|
Statistical |
AVERAGE |
Returns the average of its arguments |
FALSE |
|
|
Statistical |
AVERAGEA |
Returns the average of its arguments and
includes evaluation of text and logical values |
FALSE |
|
|
Statistical |
BETADIST |
Returns the cumulative beta probability
density function |
FALSE |
|
|
Statistical |
BETAINV |
Returns the inverse of the cumulative beta
probability density function |
FALSE |
|
|
Statistical |
BINOMDIST |
Returns the individual term binomial
distribution probability |
FALSE |
|
|
Statistical |
CHIDIST |
Returns the one-tailed probability of the
chi-squared distribution |
FALSE |
|
|
Statistical |
CHIINV |
Returns the inverse of the one-tailed
probability of the chi-squared distribution |
FALSE |
|
|
Statistical |
CHITEST |
Returns the test for independence |
FALSE |
|
|
Statistical |
CONFIDENCE |
Returns the confidence interval for a
population mean |
FALSE |
|
|
Statistical |
CORREL |
Returns the correlation coefficient between
two data sets |
FALSE |
|
|
Statistical |
COUNT |
Counts how many numbers are in the list of
arguments |
FALSE |
|
|
Statistical |
COUNTA |
Counts how many values are in the list of
arguments |
FALSE |
|
|
Statistical |
COVAR |
Returns covariance, the average of the
products of paired deviations |
FALSE |
|
|
Statistical |
CRITBINOM |
Returns the smallest value for which the
cumulative binomial distribution is less than or equal to a criterion value |
FALSE |
|
|
Statistical |
DEVSQ |
Returns the sum of squares of deviations |
FALSE |
|
|
Statistical |
EXPONDIST |
Returns the exponential distribution |
FALSE |
|
|
Statistical |
FDIST |
Returns the F probability distribution |
FALSE |
|
|
Statistical |
FINV |
Returns the inverse of the F probability
distribution |
FALSE |
|
|
Statistical |
FISHER |
Returns the Fisher transformation |
FALSE |
|
|
Statistical |
FISHERINV |
Returns the inverse of the Fisher
transformation |
FALSE |
|
|
Statistical |
FORECAST |
Returns a value along a linear trend |
FALSE |
|
|
Statistical |
FREQUENCY |
Returns a frequency distribution as a vertical
array |
FALSE |
|
|
Statistical |
FTEST |
Returns the result of an F-Test |
FALSE |
|
|
Statistical |
GAMMADIST |
Returns the gamma distribution |
FALSE |
|
|
Statistical |
GAMMAINV |
Returns the inverse of the gamma cumulative
distribution |
FALSE |
|
|
Statistical |
GAMMALN |
Returns the natural logarithm of the gamma
function, G(x) |
FALSE |
|
|
Statistical |
GEOMEAN |
Returns the geometric mean |
FALSE |
|
|
Statistical |
GROWTH |
Returns values along an exponential trend |
FALSE |
|
|
Statistical |
HARMEAN |
Returns the harmonic mean |
FALSE |
|
|
Statistical |
HYPGEOMDIST |
Returns the hypergeometric distribution |
FALSE |
|
|
Statistical |
INTERCEPT |
Returns the intercept of the linear regression
line |
FALSE |
|
|
Statistical |
KURT |
Returns the kurtosis of a data set |
FALSE |
|
|
Statistical |
LARGE |
Returns the kth largest value in a data
set |
FALSE |
|
|
Statistical |
LOGINV |
Returns the inverse of the lognormal
distribution |
FALSE |
|
|
Statistical |
LOGNORMDIST |
Returns the cumulative lognormal distribution |
FALSE |
|
|
Statistical |
MAX |
Returns the maximum value in a list of
arguments, ignoring logical values and text |
FALSE |
|
|
Statistical |
MAXA |
Returns the maximum value in a list of
arguments, including logical values and text |
FALSE |
|
|
Statistical |
MEDIAN |
Returns the median of the given numbers |
FALSE |
|
|
Statistical |
MIN |
Returns the minimum value in a list of
arguments, ignoring logical values and text |
FALSE |
|
|
Statistical |
MINA |
Returns the minimum value in a list of
arguments, including logical values and text |
FALSE |
|
|
Statistical |
MODE |
Returns the most common value in a data set |
FALSE |
|
|
Statistical |
NEGBINOMDIST |
Returns the negative binomial distribution |
FALSE |
|
|
Statistical |
NORMDIST |
Returns the normal cumulative distribution |
FALSE |
|
|
Statistical |
NORMINV |
Returns the inverse of the normal cumulative
distribution |
FALSE |
|
|
Statistical |
NORMSDIST |
Returns the standard normal cumulative
distribution |
FALSE |
|
|
Statistical |
NORMSINV |
Returns the inverse of the standard normal
cumulative distribution |
FALSE |
|
|
Statistical |
PEARSON |
Returns the Pearson product moment correlation
coefficient |
FALSE |
|
|
Statistical |
PERCENTILE |
Returns the kth percentile of values in
a range |
FALSE |
|
|
Statistical |
PERCENTRANK |
Returns the percentage rank of a value in a
data set |
FALSE |
|
|
Statistical |
PERMUT |
Returns the number of permutations for a given
number of objects |
FALSE |
|
|
Statistical |
POISSON |
Returns the Poisson distribution |
FALSE |
|
|
Statistical |
PROB |
Returns the probability that values in a range
are between two limits |
FALSE |
|
|
Statistical |
QUARTILE |
Returns the quartile of a data set |
FALSE |
|
|
Statistical |
RANK |
Returns the rank of a number in a list of
numbers |
FALSE |
|
|
Statistical |
RSQ |
Returns the square of the Pearson product
moment correlation coefficient |
FALSE |
|
|
Statistical |
SKEW |
Returns the skewness of a distribution |
FALSE |
|
|
Statistical |
SLOPE |
Returns the slope of the linear regression
line |
FALSE |
|
|
Statistical |
SMALL |
Returns the kth smallest value in a
data set |
FALSE |
|
|
Statistical |
STANDARDIZE |
Returns a normalized value |
FALSE |
|
|
Statistical |
STDEV |
Estimates standard deviation based on a
sample, ignoring text and logical values |
FALSE |
|
|
Statistical |
STDEVA |
Estimates standard deviation based on a
sample, including text and logical values |
FALSE |
|
|
Statistical |
STDEVP |
Calculates standard deviation based on the
entire population, ignoring text and logical values |
FALSE |
|
|
Statistical |
STDEVPA |
Calculates standard deviation based on the
entire population, including text and logical values |
FALSE |
|
|
Statistical |
STEYX |
Returns the standard error of the predicted
y-value for each x in the regression |
FALSE |
|
|
Statistical |
TDIST |
Returns the student’s t-distribution |
FALSE |
|
|
Statistical |
TINV |
Returns the inverse of the student’s
t-distribution |
FALSE |
|
|
Statistical |
TREND |
Returns values along a linear trend |
FALSE |
|
|
Statistical |
TRIMMEAN |
Returns the mean of the interior of a data set |
FALSE |
|
|
Statistical |
TTEST |
Returns the probability associated with a
student’s t-Test |
FALSE |
|
|
Statistical |
VAR |
Estimates variance based on a sample, ignoring
logical values and text |
FALSE |
|
|
Statistical |
VARA |
Estimates variance based on a sample,
including logical values and text |
FALSE |
|
|
Statistical |
VARP |
Calculates variance based on the entire
population, ignoring logical values and text |
FALSE |
|
|
Statistical |
VARPA |
Calculates variance based on the entire
population, including logical values and text |
FALSE |
|
|
Statistical |
WEIBULL |
Returns the Weibull distribution |
FALSE |
|
|
Statistical |
ZTEST |
Returns the two-tailed P-value of a z-test |
FALSE |
|
|
Statistical |
LINEST |
Returns the parameters of a linear trend |
FALSE |
|
|
Statistical |
LOGEST |
Returns the parameters of an exponential trend |
FALSE |
|
|
Statistical |
COUNTIF |
Counts the number of cells that meet the
criteria you specify in the argument |
FALSE |
|
|
Text |
BAHTTEXT |
Converts a number to Baht text |
FALSE |
|
|
Text |
CHAR |
Returns the character specified by the code
number |
FALSE |
|
|
Text |
CLEAN |
Removes all nonprintable characters from text |
FALSE |
|
|
Text |
CODE |
Returns a numeric code for the first character
in a text string |
FALSE |
|
|
Text |
CONCATENATE |
Joins several text items into one text item |
FALSE |
|
|
Text |
DOLLAR |
Converts a number to text, using currency
format |
FALSE |
|
|
Text |
EXACT |
Checks to see whether two text values are
identical |
FALSE |
|
|
Text |
FIXED |
Formats a number as text with a fixed number
of decimals |
FALSE |
|
|
Text |
LEFT |
Returns the leftmost characters from a text
value |
FALSE |
|
|
Text |
LEN |
Returns the number of characters in a text
string |
FALSE |
|
|
Text |
LOWER |
Converts text to lowercase |
FALSE |
|
|
Text |
MID |
Returns a specific number of characters from a
text string, starting at the position you specify |
FALSE |
|
|
Text |
PROPER |
Capitalizes the first letter in each word of a
text value |
FALSE |
|
|
Text |
REPLACE |
Replaces characters within text |
FALSE |
|
|
Text |
REPT |
Repeats text a given number of times |
FALSE |
|
|
Text |
RIGHT |
Returns the rightmost characters from a text
value |
FALSE |
|
|
Text |
SEARCH |
Finds one text value within another (not case
sensitive) |
FALSE |
|
|
Text |
SUBSTITUTE |
Substitutes new text for old text in a text
string |
FALSE |
|
|
Text |
T |
Returns the text referred to by value |
FALSE |
|
|
Text |
TEXT |
Formats a number and converts it to text |
FALSE |
|
|
Text |
TRIM |
Removes excess spaces from text |
FALSE |
|
|
Text |
UPPER |
Converts text to uppercase |
FALSE |
|
|
Text |
VALUE |
Converts a text argument to a number |
FALSE |
|
|
Text |
FIND |
Finds one text value within another (case
sensitive) |
FALSE |
