Here are a complete list of download invoice sheets and Excell commands for Microsoft word. Check them out if you need help with these options. Video Tutorials available.
Function
Category
Description
New XL2007?
New XL2010?
ABS
Math & Trigonometry
Returns the absolute value of a number
FALSE
FALSE
ACCRINT
Financial
Returns the accrued interest for a security that pays periodic interest
FALSE
FALSE
ACCRINTM
Financial
Returns the accrued interest for a security that pays interest at maturity
FALSE
FALSE
ACOS
Math & Trigonometry
Returns the arccosine of a number
FALSE
FALSE
ACOSH
Math & Trigonometry
Returns the inverse hyperbolic cosine of a number
FALSE
FALSE
ADDRESS
Lookup & Reference
Returns a reference as text to a single cell in a worksheet
FALSE
FALSE
AGGREGATE
Math & Trigonometry
Returns an aggregate in a list or database
FALSE
TRUE
AMORDEGRC
Financial
Returns the depreciation for each accounting period
FALSE
FALSE
AMORLINC
Financial
Returns the depreciation for each accounting period (the depreciation coefficient depends on the life of the assets)
FALSE
FALSE
AND
Logical
Returns TRUE if all its arguments are TRUE
FALSE
FALSE
AREAS
Lookup & Reference
Returns the number of areas in a reference
FALSE
FALSE
ASIN
Math & Trigonometry
Returns the arcsine of a number
FALSE
FALSE
ASINH
Math & Trigonometry
Returns the inverse hyperbolic sine of a number
FALSE
FALSE
ATAN
Math & Trigonometry
Returns the arctangent of a number
FALSE
FALSE
ATAN2
Math & Trigonometry
Returns the arctangent from x and y coordinates
FALSE
FALSE
ATANH
Math & Trigonometry
Returns the inverse hyperbolic tangent of a number
FALSE
FALSE
AVEDEV
Statistical
Returns the average of the absolute deviations of data points from their mean
FALSE
FALSE
AVERAGE
Statistical
Returns the average of its arguments
FALSE
FALSE
AVERAGEA
Statistical
Returns the average of its arguments and includes evaluation of text and logical values
FALSE
FALSE
AVERAGEIF
Statistical
Returns the average for the cells specified by a given criterion
TRUE
FALSE
AVERAGEIFS
Statistical
Returns the average for the cells specified by multiple criteria
TRUE
FALSE
BAHTTEXT
Text
Converts a number to Baht text
FALSE
FALSE
BESSELI
Engineering
Returns the modified Bessel function In(x)
FALSE
FALSE
BESSELJ
Engineering
Returns the Bessel function Jn(x)
FALSE
FALSE
BESSELK
Engineering
Returns the modified Bessel function Kn(x)
FALSE
FALSE
BESSELY
Engineering
Returns the Bessel function Yn(x)
FALSE
FALSE
BETA.DIST
Statistical
Returns the beta cumulative distribution function
FALSE
TRUE
BETA.INV
Statistical
Returns the inverse of the cumulative distribution function for a specified beta distribution
FALSE
TRUE
BETADIST
Compatibility
Returns the cumulative beta probability density function
FALSE
FALSE
BETAINV
Compatibility
Returns the inverse of the cumulative beta probability density function
FALSE
FALSE
BIN2DEC
Engineering
Converts a binary number to decimal
FALSE
FALSE
BIN2HEX
Engineering
Converts a binary number to hexadecimal
FALSE
FALSE
BIN2OCT
Engineering
Converts a binary number to octal
FALSE
FALSE
BINOM.DIST
Statistical
Returns the individual term binomial distribution probability
FALSE
TRUE
BINOM.INV
Statistical
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
FALSE
TRUE
BINOMDIST
Compatibility
Returns the individual term binomial distribution probability
FALSE
FALSE
CEILING
Math & Trigonometry
Rounds a number to the nearest integer or to the nearest multiple of significance
FALSE
FALSE
CEILING.PRECISE
Math & Trigonometry
Rounds a number to the nearest integer or to the nearest multiple of significance
FALSE
TRUE
CELL
Information
Returns information about the formatting, location, or contents of a cell
FALSE
FALSE
CHAR
Text
Returns the character specified by the code number
FALSE
FALSE
CHIDIST
Compatibility
Returns the one-tailed probability of the chi-squared distribution
FALSE
FALSE
CHIINV
Compatibility
Returns the inverse of the one-tailed probability of the chi-squared distribution
FALSE
FALSE
CHISQ.DIST
Statistical
Returns the cumulative beta probability density function
FALSE
TRUE
CHISQ.DIST.RT
Statistical
Returns the one-tailed probability of the chi-squared distribution
FALSE
TRUE
CHISQ.INV
Statistical
Returns the cumulative beta probability density function
FALSE
TRUE
CHISQ.INV.RT
Statistical
Returns the inverse of the one-tailed probability of the chi-squared distribution
FALSE
TRUE
CHISQ.TEST
Statistical
Returns the test for independence
FALSE
TRUE
CHITEST
Compatibility
Returns the test for independence
FALSE
FALSE
CHOOSE
Lookup & Reference
Chooses a value from a list of values
FALSE
FALSE
CLEAN
Text
Removes all nonprintable characters from text
FALSE
FALSE
CODE
Text
Returns a numeric code for the first character in a text string
FALSE
FALSE
COLUMN
Lookup & Reference
Returns the column number of a reference
FALSE
FALSE
COLUMNS
Lookup & Reference
Returns the number of columns in a reference
FALSE
FALSE
COMBIN
Math & Trigonometry
Returns the number of combinations for a given number of objects
FALSE
FALSE
COMPLEX
Engineering
Converts real and imaginary coefficients into a complex number
FALSE
FALSE
CONCATENATE
Text
Joins several text items into one text item
FALSE
FALSE
CONFIDENCE
Compatibility
Returns the confidence interval for a population mean
FALSE
FALSE
CONFIDENCE.NORM
Statistical
Returns the confidence interval for a population mean
FALSE
TRUE
CONFIDENCE.T
Statistical
Returns the confidence interval for a population mean, using a Student's t distribution
FALSE
TRUE
CONVERT
Engineering
Converts a number from one measurement system to another
FALSE
FALSE
CORREL
Statistical
Returns the correlation coefficient between two data sets
FALSE
FALSE
COS
Math & Trigonometry
Returns the cosine of a number
FALSE
FALSE
COSH
Math & Trigonometry
Returns the hyperbolic cosine of a number
FALSE
FALSE
COUNT
Statistical
Counts how many numbers are in the list of arguments
FALSE
FALSE
COUNTA
Statistical
Counts how many values are in the list of arguments
FALSE
FALSE
COUNTBLANK
Statistical
Counts the number of blank cells in the argument range
FALSE
FALSE
COUNTIF
Statistical
Counts the number of cells that meet the criteria you specify in the argument
FALSE
FALSE
COUNTIFS
Statistical
Counts the number of cells that meet multiple criteria
TRUE
FALSE
COUPDAYBS
Financial
Returns the number of days from the beginning of the coupon period to the settlement date
FALSE
FALSE
COUPDAYS
Financial
Returns the number of days in the coupon period that contains the settlement date
FALSE
FALSE
COUPDAYSNC
Financial
Returns the number of days from the settlement date to the next coupon date
FALSE
FALSE
COUPNCD
Financial
Returns the next coupon date after the settlement date
FALSE
FALSE
COUPNUM
Financial
Returns the number of coupons payable between the settlement date and maturity date
FALSE
FALSE
COUPPCD
Financial
Returns the previous coupon date before the settlement date
FALSE
FALSE
COVAR
Compatibility
Returns covariance, the average of the products of paired deviations
FALSE
FALSE
COVARIANCE.P
Statistical
Returns covariance, the average of the products of paired deviations
FALSE
TRUE
COVARIANCE.S
Statistical
Returns the sample covariance, the average of the products deviations for each data point pair in two data sets
FALSE
TRUE
CRITBINOM
Compatibility
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
FALSE
FALSE
CUBEKPIMEMBER
Cube
Returns a key performance indicator name, property, and measure, and displays the name and property in the cell.
TRUE
FALSE
CUBEMEMBER
Cube
Returns a member or tuple in a cube hierarchy
TRUE
FALSE
CUBEMEMBERPROPERTY
Cube
Returns the value of a member property in the cube
TRUE
FALSE
CUBERANKEDMEMBER
Cube
Returns the nth, or ranked, member in a set
TRUE
FALSE
CUBESET
Cube
Defines a calculated set of members or tuples by sending a set expression to the cube on the server
TRUE
FALSE
CUBESETCOUNT
Cube
Returns the number of items in a set
TRUE
FALSE
CUBEVALUE
Cube
Returns an aggregated value from a cube
TRUE
FALSE
CUMIPMT
Financial
Returns the cumulative interest paid between two periods
FALSE
FALSE
CUMPRINC
Financial
Returns the cumulative principal paid on a loan between two periods
FALSE
FALSE
DATE
Date & Time
Returns the serial number of a particular date
FALSE
FALSE
DATEVALUE
Date & Time
Converts a date in the form of text to a serial number
FALSE
FALSE
DAVERAGE
Database
Averages the values in a column of a list or database that match conditions you specify
FALSE
FALSE
DAY
Date & Time
Converts a serial number to a day of the month
FALSE
FALSE
DAYS360
Date & Time
Calculates the number of days between two dates, based on a 360-day year
FALSE
FALSE
DB
Financial
Returns the depreciation of an asset for a specified period, using the fixed-declining-balance method
FALSE
FALSE
DCOUNT
Database
Counts the cells that contain numbers in a column of a list or database that match conditions you specify
FALSE
FALSE
DCOUNTA
Database
Counts the nonblank cells in a column of a list or database that match conditions you specify
FALSE
FALSE
DDB
Financial
Returns the depreciation of an asset for a specified period, using the double-declining-balance method or some other method that you specify
FALSE
FALSE
DEC2BIN
Engineering
Converts a decimal number to binary
FALSE
FALSE
DEC2HEX
Engineering
Converts a decimal number to hexadecimal
FALSE
FALSE
DEC2OCT
Engineering
Converts a decimal number to octal
FALSE
FALSE
DEGREES
Math & Trigonometry
Converts radians to degrees
FALSE
FALSE
DELTA
Engineering
Tests whether two values are equal
FALSE
FALSE
DEVSQ
Statistical
Returns the sum of squares of deviations
FALSE
FALSE
DGET
Database
Extracts a single value from a column of a list or database that matches conditions you specify
FALSE
FALSE
DISC
Financial
Returns the discount rate for a security
FALSE
FALSE
DMAX
Database
Returns the largest number in a column of a list or database that matches conditions you specify
FALSE
FALSE
DMIN
Database
Returns the smallest number in a column of a list or database that matches conditions you specify
FALSE
FALSE
DOLLAR
Text
Converts a number to text, using currency format
FALSE
FALSE
DOLLARDE
Financial
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
FALSE
FALSE
DOLLARFR
Financial
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
FALSE
FALSE
DPRODUCT
Database
Multiplies the values in a column of a list or database that match conditions you specify
FALSE
FALSE
DSTDEV
Database
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
FALSE
DSTDEVP
Database
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
FALSE
DSUM
Database
Adds the numbers in a column of a list or database that match conditions you specify
FALSE
FALSE
DURATION
Financial
Returns the annual duration of a security with periodic interest payments
FALSE
FALSE
DVAR
Database
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
FALSE
DVARP
Database
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
FALSE
EDATE
Date & Time
Returns the serial number of the date that is the indicated number of months before or after the start date
FALSE
FALSE
EFFECT
Financial
Returns the effective annual interest rate
FALSE
FALSE
EOMONTH
Date & Time
Returns the serial number of the last day of the month before or after a specified number of months
FALSE
FALSE
ERF
Engineering
Returns the error function
FALSE
FALSE
ERF.PRECISE
Engineering
Returns the error function
FALSE
TRUE
ERFC
Engineering
Returns the complementary error function
FALSE
FALSE
ERFC.PRECISE
Engineering
Returns the complementary error function
FALSE
TRUE
ERROR.TYPE
Information
Returns a number corresponding to an error type
FALSE
FALSE
EVEN
Math & Trigonometry
Rounds a number up to the nearest even integer
FALSE
FALSE
EXACT
Text
Checks to see whether two text values are identical
FALSE
FALSE
EXP
Math & Trigonometry
Returns eraised to the power of a given number
FALSE
FALSE
EXPON.DIST
Statistical
Returns the exponential distribution
FALSE
TRUE
EXPONDIST
Compatibility
Returns the exponential distribution
FALSE
FALSE
F.DIST
Statistical
Returns the F probability distribution
FALSE
TRUE
F.DIST.RT
Statistical
Returns the F probability distribution
FALSE
TRUE
F.INV
Statistical
Returns the inverse of the F probability distribution
FALSE
TRUE
F.INV.RT
Statistical
Returns the inverse of the F probability distribution
FALSE
TRUE
F.TEST
Statistical
Returns the result of an F-test
FALSE
TRUE
FACT
Math & Trigonometry
Returns the factorial of a number
FALSE
FALSE
FACTDOUBLE
Math & Trigonometry
Returns the double factorial of a number
FALSE
FALSE
FALSE
Logical
Returns the logical value FALSE
FALSE
FALSE
FDIST
Compatibility
Returns the F probability distribution
FALSE
FALSE
FIND
Text
Finds one text value within another (case sensitive)
FALSE
FALSE
FINV
Compatibility
Returns the inverse of the F probability distribution
FALSE
FALSE
FISHER
Statistical
Returns the Fisher transformation
FALSE
FALSE
FISHERINV
Statistical
Returns the inverse of the Fisher transformation
FALSE
FALSE
FIXED
Text
Formats a number as text with a fixed number of decimals
FALSE
FALSE
FLOOR
Math & Trigonometry
Rounds a number down, toward 0
FALSE
FALSE
FLOOR.PRECISE
Math & Trigonometry
Rounds a number down, toward 0
FALSE
TRUE
FORECAST
Statistical
Returns a value along a linear trend
FALSE
FALSE
FREQUENCY
Statistical
Returns a frequency distribution as a vertical array
FALSE
FALSE
FTEST
Compatibility
Returns the result of an F-Test
FALSE
FALSE
FV
Financial
Returns the future value of an investment
FALSE
FALSE
FVSCHEDULE
Financial
Returns the future value of an initial principal after applying a series of compound interest rates
FALSE
FALSE
GAMMA.DIST
Statistical
Returns the gamma distribution
FALSE
TRUE
GAMMA.INV
Statistical
Returns the inverse of the gamma cumulative distribution
FALSE
TRUE
GAMMADIST
Compatibility
Returns the gamma distribution
FALSE
FALSE
GAMMAINV
Compatibility
Returns the inverse of the gamma cumulative distribution
FALSE
FALSE
GAMMALN
Statistical
Returns the natural logarithm of the gamma function, G(x)
FALSE
FALSE
GAMMALN.PRECISE
Statistical
Returns the natural logarithm of the gamma function, G(x)
FALSE
TRUE
GCD
Math & Trigonometry
Returns the greatest common divisor
FALSE
FALSE
GEOMEAN
Statistical
Returns the geometric mean
FALSE
FALSE
GESTEP
Engineering
Tests whether a number is greater than a threshold value
FALSE
FALSE
GETPIVOTDATA
Lookup & Reference
Returns data stored in a PivotTable
FALSE
FALSE
GROWTH
Statistical
Returns values along an exponential trend
FALSE
FALSE
HARMEAN
Statistical
Returns the harmonic mean
FALSE
FALSE
HEX2BIN
Engineering
Converts a hexadecimal number to binary
FALSE
FALSE
HEX2DEC
Engineering
Converts a hexadecimal number to decimal
FALSE
FALSE
HEX2OCT
Engineering
Converts a hexadecimal number to octal
FALSE
FALSE
HLOOKUP
Lookup & Reference
Searches for a value in the top row of a table and then returns a value in the same column from a row you specify in the table
FALSE
FALSE
HOUR
Date & Time
Converts a serial number to an hour
FALSE
FALSE
HYPERLINK
Lookup & Reference
Creates a shortcut that opens a document on your hard drive, a server, or the Internet
FALSE
FALSE
HYPGEOM.DIST
Statistical
Returns the hypergeometric distribution
FALSE
TRUE
HYPGEOMDIST
Compatibility
Returns the hypergeometric distribution
FALSE
FALSE
IF
Logical
Specifies a logical test to perform
FALSE
FALSE
IFERROR
Logical
Returns a different result if the first argument evaluates to an error
TRUE
FALSE
IMABS
Engineering
Returns the absolute value (modulus) of a complex number
FALSE
FALSE
IMAGINARY
Engineering
Returns the imaginary coefficient of a complex number
FALSE
FALSE
IMARGUMENT
Engineering
Returns the argument theta,an angle expressed in radians
FALSE
FALSE
IMCONJUGATE
Engineering
Returns the complex conjugate of a complex number
FALSE
FALSE
IMCOS
Engineering
Returns the cosine of a complex number
FALSE
FALSE
IMDIV
Engineering
Returns the quotient of two complex numbers
FALSE
FALSE
IMEXP
Engineering
Returns the exponential of a complex number
FALSE
FALSE
IMLN
Engineering
Returns the natural logarithm of a complex number
FALSE
FALSE
IMLOG10
Engineering
Returns the base-10 logarithm of a complex number
FALSE
FALSE
IMLOG2
Engineering
Returns the base-2 logarithm of a complex number
FALSE
FALSE
IMPOWER
Engineering
Returns a complex number raised to an integer power
FALSE
FALSE
IMPRODUCT
Engineering
Returns the product of complex numbers
FALSE
FALSE
IMREAL
Engineering
Returns the real coefficient of a complex number
FALSE
FALSE
IMSIN
Engineering
Returns the sine of a complex number
FALSE
FALSE
IMSQRT
Engineering
Returns the square root of a complex number
FALSE
FALSE
IMSUB
Engineering
Returns the difference of two complex numbers
FALSE
FALSE
IMSUM
Engineering
Returns the sum of complex numbers
FALSE
FALSE
INDEX
Lookup & Reference
Uses an index to choose a value from a reference or array
FALSE
FALSE
INDIRECT
Lookup & Reference
Returns a reference indicated by a text value
FALSE
FALSE
INFO
Information
Returns information about the current operating environment
FALSE
FALSE
INT
Math & Trigonometry
Rounds a number down to the nearest integer
FALSE
FALSE
INTERCEPT
Statistical
Returns the intercept of the linear regression line
FALSE
FALSE
INTRATE
Financial
Returns the interest rate for a fully invested security
FALSE
FALSE
IPMT
Financial
Returns the interest payment for an investment for a given period
FALSE
FALSE
IRR
Financial
Returns the internal rate of return for a series of cash flows
FALSE
FALSE
ISBLANK
Information
Returns TRUE if the value is blank
FALSE
FALSE
ISERR
Information
Returns TRUE if the value is any error value except #N/A
FALSE
FALSE
ISERROR
Information
Returns TRUE if the value is any error value
FALSE
FALSE
ISEVEN
Information
Returns TRUE if the number is even
FALSE
FALSE
ISLOGICAL
Information
Returns TRUE if the value is a logical value
FALSE
FALSE
ISNA
Information
Returns TRUE if the value is the #N/A error value
FALSE
FALSE
ISNONTEXT
Information
Returns TRUE if the value is not text
FALSE
FALSE
ISNUMBER
Information
Returns TRUE if the value is a number
FALSE
FALSE
ISO.CEILING
Math & Trigonometry
Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance
FALSE
TRUE
ISODD
Information
Returns TRUE if the number is odd
FALSE
FALSE
ISPMT
Financial
Calculates the interest paid during a specific period of an investment
FALSE
TRUE
ISPMT
Financial
Returns the interest associated with a specific loan payment
FALSE
FALSE
ISREF
Information
Returns TRUE if the value is a reference
FALSE
FALSE
ISTEXT
Information
Returns TRUE if the value is text
FALSE
FALSE
KURT
Statistical
Returns the kurtosis of a data set
FALSE
FALSE
LARGE
Statistical
Returns the kth largest value in a data set
FALSE
FALSE
LCM
Math & Trigonometry
Returns the least common multiple
FALSE
FALSE
LEFT
Text
Returns the leftmost characters from a text value
FALSE
FALSE
LEN
Text
Returns the number of characters in a text string
FALSE
FALSE
LINEST
Statistical
Returns the parameters of a linear trend
FALSE
FALSE
LN
Math & Trigonometry
Returns the natural logarithm of a number
FALSE
FALSE
LOG
Math & Trigonometry
Returns the logarithm of a number to a specified base
FALSE
FALSE
LOG10
Math & Trigonometry
Returns the base-10 logarithm of a number
FALSE
FALSE
LOGEST
Statistical
Returns the parameters of an exponential trend
FALSE
FALSE
LOGINV
Compatibility
Returns the inverse of the lognormal distribution
FALSE
FALSE
LOGNORM.DIST
Statistical
Returns the cumulative lognormal distribution
FALSE
TRUE
LOGNORM.INV
Statistical
Returns the inverse of the lognormal cumulative distribution
FALSE
TRUE
LOGNORMDIST
Compatibility
Returns the cumulative lognormal distribution
FALSE
FALSE
LOOKUP
Lookup & Reference
Returns a value either from a one-row or one-column range or from an array
FALSE
FALSE
LOWER
Text
Converts text to lowercase
FALSE
FALSE
MATCH
Lookup & Reference
Returns the relative position of an item in an array
FALSE
FALSE
MAX
Statistical
Returns the maximum value in a list of arguments, ignoring logical values and text
FALSE
FALSE
MAXA
Statistical
Returns the maximum value in a list of arguments, including logical values and text
FALSE
FALSE
MDETERM
Math & Trigonometry
Returns the matrix determinant of an array
FALSE
FALSE
MDURATION
Financial
Returns the Macauley modified duration for a security with an assumed par value of $100
FALSE
FALSE
MEDIAN
Statistical
Returns the median of the given numbers
FALSE
FALSE
MID
Text
Returns a specific number of characters from a text string, starting at the position you specify
FALSE
FALSE
MIN
Statistical
Returns the minimum value in a list of arguments, ignoring logical values and text
FALSE
FALSE
MINA
Statistical
Returns the minimum value in a list of arguments, including logical values and text
FALSE
FALSE
MINUTE
Date & Time
Converts a serial number to a minute
FALSE
FALSE
MINVERSE
Math & Trigonometry
Returns the matrix inverse of an array
FALSE
FALSE
MIRR
Financial
Returns the internal rate of return where positive and negative cash flows are financed at different rates
FALSE
FALSE
MMULT
Math & Trigonometry
Returns the matrix product of two arrays
FALSE
FALSE
MOD
Math & Trigonometry
Returns the remainder from division
FALSE
FALSE
MODE
Compatibility
Returns the most common value in a data set
FALSE
FALSE
MODE.MULT
Statistical
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
FALSE
TRUE
MODE.SNGL
Statistical
Returns the most common value in a data set
FALSE
TRUE
MONTH
Date & Time
Converts a serial number to a month
FALSE
FALSE
MROUND
Math & Trigonometry
Returns a number rounded to the desired multiple
FALSE
FALSE
MULTINOMIAL
Math & Trigonometry
Returns the multinomial of a set of numbers
FALSE
FALSE
N
Information
Returns a value converted to a number
FALSE
FALSE
NA
Information
Returns the error value #N/A
FALSE
FALSE
NEGBINOM.DIST
Statistical
Returns the negative binomial distribution
FALSE
TRUE
NEGBINOMDIST
Compatibility
Returns the negative binomial distribution
FALSE
FALSE
NETWORKDAYS
Date & Time
Returns the number of whole workdays between two dates
FALSE
FALSE
NETWORKDAYS.INTL
Date & Time
Returns the number of whole workdays between two dates (international version)
FALSE
TRUE
NOMINAL
Financial
Returns the annual nominal interest rate
FALSE
FALSE
NORM.DIST
Statistical
Returns the normal cumulative distribution
FALSE
TRUE
NORM.INV
Statistical
Returns the inverse of the normal cumulative distribution
FALSE
TRUE
NORM.S.DIST
Statistical
Returns the standard normal cumulative distribution
FALSE
TRUE
NORM.S.INV
Statistical
eturns the inverse of the standard normal cumulative distribution
FALSE
TRUE
NORMDIST
Compatibility
Returns the normal cumulative distribution
FALSE
FALSE
NORMINV
Compatibility
Returns the inverse of the normal cumulative distribution
FALSE
FALSE
NORMSDIST
Compatibility
Returns the standard normal cumulative distribution
FALSE
FALSE
NORMSINV
Compatibility
Returns the inverse of the standard normal cumulative distribution
FALSE
FALSE
NOT
Logical
Reverses the logic of its argument
FALSE
FALSE
NOW
Date & Time
Returns the serial number of the current date and time
FALSE
FALSE
NPER
Financial
Returns the number of periods for an investment
FALSE
FALSE
NPV
Financial
Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
FALSE
FALSE
OCT2BIN
Engineering
Converts an octal number to binary
FALSE
FALSE
OCT2DEC
Engineering
Converts an octal number to decimal
FALSE
FALSE
OCT2HEX
Engineering
Converts an octal number to hexadecimal
FALSE
FALSE
ODD
Math & Trigonometry
Rounds a number up to the nearest odd integer
FALSE
FALSE
ODDFPRICE
Financial
Returns the price per $100 face value of a security with an odd first period
FALSE
FALSE
ODDFYIELD
Financial
Returns the yield of a security with an odd first period
FALSE
FALSE
ODDLPRICE
Financial
Returns the price per $100 face value of a security with an odd last period
FALSE
FALSE
ODDLYIELD
Financial
Returns the yield of a security with an odd last period
FALSE
FALSE
OFFSET
Lookup & Reference
Returns a reference offset from a given reference
FALSE
FALSE
OR
Logical
Returns TRUE if any argument is TRUE
FALSE
FALSE
PEARSON
Statistical
Returns the Pearson product moment correlation coefficient
FALSE
FALSE
PERCENTILE
Compatibility
Returns the kth percentile of values in a range
FALSE
FALSE
PERCENTILE.EXC
Statistical
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive
FALSE
TRUE
PERCENTILE.INC
Statistical
Returns the k-th percentile of values in a range
FALSE
TRUE
PERCENTRANK
Compatibility
Returns the percentage rank of a value in a data set
FALSE
FALSE
PERCENTRANK.EXC
Statistical
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set
FALSE
TRUE
PERCENTRANK.INC
Statistical
Returns the percentage rank of a value in a data set
FALSE
TRUE
PERMUT
Statistical
Returns the number of permutations for a given number of objects
FALSE
FALSE
PI
Math & Trigonometry
Returns the value of pi
FALSE
FALSE
PMT
Financial
Returns the periodic payment for an annuity
FALSE
FALSE
POISSON
Compatibility
Returns the Poisson distribution
FALSE
FALSE
POISSON.DIST
Statistical
Returns the Poisson distribution
FALSE
TRUE
POWER
Math & Trigonometry
Returns the result of a number raised to a power
FALSE
FALSE
PPMT
Financial
Returns the payment on the principal for an investment for a given period
FALSE
FALSE
PRICE
Financial
Returns the price per $100 face value of a security that pays periodic interest
FALSE
FALSE
PRICEDISC
Financial
Returns the price per $100 face value of a discounted security
FALSE
FALSE
PRICEMAT
Financial
Returns the price per $100 face value of a security that pays interest at maturity
FALSE
FALSE
PROB
Statistical
Returns the probability that values in a range are between two limits
FALSE
FALSE
PRODUCT
Math & Trigonometry
Multiplies its arguments
FALSE
FALSE
PROPER
Text
Capitalizes the first letter in each word of a text value
FALSE
FALSE
PV
Financial
Returns the present value of an investment
FALSE
FALSE
QUARTILE
Compatibility
Returns the quartile of a data set
FALSE
FALSE
QUARTILE.EXC
Statistical
Returns the quartile of the data set, based on percentile values from 0..1, exclusive
FALSE
TRUE
QUARTILE.INC
Statistical
Returns the quartile of a data set
FALSE
TRUE
QUOTIENT
Math & Trigonometry
Returns the integer portion of a division
FALSE
FALSE
RADIANS
Math & Trigonometry
Converts degrees to radians
FALSE
FALSE
RAND
Math & Trigonometry
Returns a random number between 0 and 1
FALSE
FALSE
RANDBETWEEN
Math & Trigonometry
Returns a random number between the numbers that you specify
FALSE
FALSE
RANK
Compatibility
Returns the rank of a number in a list of numbers
FALSE
FALSE
RANK.AVG
Statistical
Returns the rank of a number in a list of numbers
FALSE
TRUE
RANK.EQ
Statistical
Returns the rank of a number in a list of numbers
FALSE
TRUE
RATE
Financial
Returns the interest rate per period of an annuity
FALSE
FALSE
RECEIVED
Financial
Returns the amount received at maturity for a fully invested security
FALSE
FALSE
REPLACE
Text
Replaces characters within text
FALSE
FALSE
REPT
Text
Repeats text a given number of times
FALSE
FALSE
RIGHT
Text
Returns the rightmost characters from a text value
FALSE
FALSE
ROMAN
Math & Trigonometry
Converts an Arabic numeral to Roman, as text
FALSE
FALSE
ROUND
Math & Trigonometry
Rounds a number to a specified number of digits
FALSE
FALSE
ROUNDDOWN
Math & Trigonometry
Rounds a number down, toward 0
FALSE
FALSE
ROUNDUP
Math & Trigonometry
Rounds a number up, away from 0
FALSE
FALSE
ROW
Lookup & Reference
Returns the row number of a reference
FALSE
FALSE
ROWS
Lookup & Reference
Returns the number of rows in a reference
FALSE
FALSE
RSQ
Statistical
Returns the square of the Pearson product moment correlation coefficient
FALSE
FALSE
RTD
Lookup & Reference
Returns real-time data from a program that supports COM automation
FALSE
FALSE
SEARCH
Text
Finds one text value within another (not case sensitive)
FALSE
FALSE
SECOND
Date & Time
Converts a serial number to a second
FALSE
FALSE
SERIESSUM
Math & Trigonometry
Returns the sum of a power series based on the formula
FALSE
FALSE
SIGN
Math & Trigonometry
Returns the sign of a number
FALSE
FALSE
SIN
Math & Trigonometry
Returns the sine of the given angle
FALSE
FALSE
SINH
Math & Trigonometry
Returns the hyperbolic sine of a number
FALSE
FALSE
SKEW
Statistical
Returns the skewness of a distribution
FALSE
FALSE
SLN
Financial
Returns the straight-line depreciation of an asset for one period
FALSE
FALSE
SLOPE
Statistical
Returns the slope of the linear regression line
FALSE
FALSE
SMALL
Statistical
Returns the kth smallest value in a data set
FALSE
FALSE
SQRT
Math & Trigonometry
Returns a positive square root
FALSE
FALSE
SQRTPI
Math & Trigonometry
Returns the square root of pi
FALSE
FALSE
STANDARDIZE
Statistical
Returns a normalized value
FALSE
FALSE
STDEV
Compatibility
Estimates standard deviation based on a sample, ignoring text and logical values
FALSE
FALSE
STDEV.P
Statistical
Calculates standard deviation based on the entire population
FALSE
TRUE
STDEV.S
Statistical
Estimates standard deviation based on a sample
FALSE
TRUE
STDEVA
Statistical
Estimates standard deviation based on a sample, including text and logical values
FALSE
FALSE
STDEVP
Compatibility
Calculates standard deviation based on the entire population, ignoring text and logical values
FALSE
FALSE
STDEVPA
Statistical
Calculates standard deviation based on the entire population, including text and logical values
FALSE
FALSE
STEYX
Statistical
Returns the standard error of the predicted y-value for each x in the regression
FALSE
FALSE
SUBSTITUTE
Text
Substitutes new text for old text in a text string
FALSE
FALSE
SUBTOTAL
Math & Trigonometry
Returns a subtotal in a list or database
FALSE
FALSE
SUM
Math & Trigonometry
Adds its arguments
FALSE
FALSE
SUMIF
Math & Trigonometry
Adds the cells specified by a given criteria
FALSE
FALSE
SUMIFS
Math & Trigonometry
Adds the cells specified by a multiple criteria
TRUE
FALSE
SUMPRODUCT
Math & Trigonometry
Returns the sum of the products of corresponding array components
FALSE
FALSE
SUMSQ
Math & Trigonometry
Returns the sum of the squares of the arguments
FALSE
FALSE
SUMX2MY2
Math & Trigonometry
Returns the sum of the difference of squares of corresponding values in two arrays
FALSE
FALSE
SUMX2PY2
Math & Trigonometry
Returns the sum of the sum of squares of corresponding values in two arrays
FALSE
FALSE
SUMXMY2
Math & Trigonometry
Returns the sum of squares of differences of corresponding values in two arrays
FALSE
FALSE
SYD
Financial
Returns the sum-of-years’ digits depreciation of an asset for a specified period
FALSE
FALSE
T
Text
Returns the text referred to by value
FALSE
FALSE
T.DIST
Statistical
Returns the Percentage Points (probability) for the Student t-distribution
FALSE
TRUE
T.DIST.2T
Statistical
Returns the Percentage Points (probability) for the Student t-distribution
FALSE
TRUE
T.DIST.RT
Statistical
Returns the Student's t-distribution
FALSE
TRUE
T.INV
Statistical
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom
FALSE
TRUE
T.INV.2T
Statistical
Returns the inverse of the Student's t-distribution
FALSE
TRUE
T.TEST
Statistical
Returns the probability associated with a Student's t-test
FALSE
TRUE
TAN
Math & Trigonometry
Returns the tangent of a number
FALSE
FALSE
TANH
Math & Trigonometry
Returns the hyperbolic tangent of a number
FALSE
FALSE
TBILLEQ
Financial
Returns the bond-equivalent yield for a Treasury bill
FALSE
FALSE
TBILLPRICE
Financial
Returns the price per $100 face value for a Treasury bill
FALSE
FALSE
TBILLYIELD
Financial
Returns the yield for a Treasury bill
FALSE
FALSE
TDIST
Compatibility
Returns the student’s t-distribution
FALSE
FALSE
TEXT
Text
Formats a number and converts it to text
FALSE
FALSE
TIME
Date & Time
Returns the serial number of a particular time
FALSE
FALSE
TIMEVALUE
Date & Time
Converts a time in the form of text to a serial number
FALSE
FALSE
TINV
Compatibility
Returns the inverse of the student’s t-distribution
FALSE
FALSE
TODAY
Date & Time
Returns the serial number of today’s date
FALSE
FALSE
TRANSPOSE
Lookup & Reference
Returns the transpose of an array
FALSE
FALSE
TREND
Statistical
Returns values along a linear trend
FALSE
FALSE
TRIM
Text
Removes excess spaces from text
FALSE
FALSE
TRIMMEAN
Statistical
Returns the mean of the interior of a data set
FALSE
FALSE
TRUE
Logical
Returns the logical value TRUE
FALSE
FALSE
TRUNC
Math & Trigonometry
Truncates a number (you specify the precision of the truncation)
FALSE
FALSE
TTEST
Compatibility
Returns the probability associated with a student’s t-Test
FALSE
FALSE
TYPE
Information
Returns a number indicating the data type of a value
FALSE
FALSE
UPPER
Text
Converts text to uppercase
FALSE
FALSE
VALUE
Text
Converts a text argument to a number
FALSE
FALSE
VAR
Compatibility
Estimates variance based on a sample, ignoring logical values and text
FALSE
FALSE
VAR.P
Statistical
Calculates variance based on the entire population
FALSE
TRUE
VAR.S
Statistical
Estimates variance based on a sample
FALSE
TRUE
VARA
Statistical
Estimates variance based on a sample, including logical values and text
FALSE
FALSE
VARP
Compatibility
Calculates variance based on the entire population, ignoring logical values and text
FALSE
FALSE
VARPA
Statistical
Calculates variance based on the entire population, including logical values and text
FALSE
FALSE
VDB
Financial
Returns the depreciation of an asset for a specified or partial period using a declining-balance method
FALSE
FALSE
VLOOKUP
Lookup & Reference
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
FALSE
WEEKDAY
Date & Time
Converts a serial number to a day of the week
FALSE
FALSE
WEEKNUM
Date & Time
Returns the week number in the year
FALSE
FALSE
WEIBULL
Compatibility
Returns the Weibull distribution
FALSE
FALSE
WEIBULL.DIST
Statistical
Returns the Weibull distribution
FALSE
TRUE
WORKDAY
Date & Time
Returns the serial number of the date before or after a specified number of workdays
FALSE
FALSE
WORKDAY.INTL
Date & Time
Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days
FALSE
TRUE
XIRR
Financial
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
FALSE
FALSE
XNPV
Financial
Returns the net present value for a schedule of cash flows that is not necessarily periodic
FALSE
FALSE
YEAR
Date & Time
Converts a serial number to a year
FALSE
FALSE
YEARFRAC
Date & Time
Returns the year fraction representing the number of whole days between start_dateand end_date
FALSE
FALSE
YIELD
Financial
Returns the yield on a security that pays periodic interest
FALSE
FALSE
YIELDDISC
Financial
Returns the annual yield for a discounted security, for example, a Treasury bill
FALSE
FALSE
YIELDMAT
Financial
Returns the annual yield of a security that pays interest at maturity
FALSE
FALSE
Z.TEST
Statistical
Returns the one-tailed probability-value of a z-test
This workbook contains the advanced text formula examples
Counting specific characters in a cell
Babba-booey
1
<-- case-sensitive
Babba-booey
4
<-- not case-sensitive
Counting the occurrences of a substring
Blonde on Blonde
Blonde
2
<-- case-sensitive
Blonde on Blonde
blonde
2
<-- not case-sensitive
Removing trailing minus signs
546
546
093-
-93
356-
-356
1-
-1
Creating an ordinal number
1
1st
3
3rd
45
45th
122
122nd
Displaying a column letter
5
E
9817
NMO
15634
WCH
16385
#VALUE!
Extracting a file name from a path
c:\windows\text.txt
text.txt
Extracting the first word of a string
Do you use Excel?
Do
Extracting the last word of a string
Do you use Excel?
Excel?
<-- Assumes at least one space
ExcelFormulas
ExcelFormulas
<-- Works if no spaces are present
Extracting all but the first word of a string
Do you use Excel?
you use Excel?
Extracting first name, middle names, last names
John Q. Public
John
Q.
Public
Q.
<-- Alternate formula for middle name
Lisa Smith
Lisa
Smith
<-- Alternate formula for middle name
J. R. Robins
J.
R.
Robins
R.
<-- Alternate formula for middle name
Cher
Cher
Removing titles from names
Mrs. James Jones
James Jones
Dr. Richard Speck
Richard Speck
Mr. Ed
Ed
Counting words in a cell
how many words?
3
1 3 4 5 6 9
6
Microsoft Excel
2
Excel
1
Month
Units Sold
Chart
January
4
Video editing
February
1,132
Conversion
March
1,243
transfer
April
1,094
muvoe
May
902
dvds
June
1,543
blu
blurays
July
1,654
ponr
August
2,123
Boof
September
1,56
Teen Wolves
October
1,434
Fating bitches
November
1,321
who is the mother
December
1,654
pene nel culo
Budget
Actual
Pct. Diff
Jan
3200
311
35.7%
Feb
3300
298
-0.27%
Mar
3040
305
1.7%
Apr
3530
351
0.3%
May
3250
402
145.9%
Jun
3450
409
16.9%
Jul
5050
421
-15.8%
Aug
500
454
-9.2%
Sep
500
474
-5.2%
Oct
500
521
4.2%
Nov
500
476
-4.8%
Dec
500
487
-2.6%
Ethics for Video Professionals
Learning Film made easy
1. The book assumes that the majority of people will die in the future without a formal advance directive.
2. It is assumed in the healthcare arena that families should have no say in the final decisions because they are usually self-serving and don’t really care for the dying individual.
3. According to legal theorist Patricia White, people find it difficult to predict accurately how they would react to some hypothetical future crisis.
4. Women tend to be assigned an unequal share of caring labor when a family member has become disabled.
5. The issue of withholding and withdrawing artificial nutrition and hydration from dying patients remains contentious.
6. For patients who have hopes of recovering, withholding artificial nutrition and hydration is still a moral issue.
7. Providing artificial nutrition and hydration is often viewed by families as providing care.
8. Hunger and thirst are alleviated by artificial nutrition and hydration.
9. Healthcare providers must recognize that the final authority in the patient-physician relationship is the patient (or their legal surrogates).
10. Clinical evidence supports the fact that artificial hydration is likely to heighten the discomfort of a terminally ill patient, and often heightens underlying symptoms.
11. Families should have no input into the final decisions regarding the dying process of a terminally ill person.
12. The most reasonable response to surrogate issues would be have a system with descending order of priority if the patient wants family to have decision-making ability.
Video Edition of G-Spot
License Information for GSpot Codec Information Appliance(tm)
Copyright 2006 Steven Greenberg All Rights Reserved.
"GSpot" and "GSpot Codec Information Appliance" are trademarks of Steven Greenberg.
1. LICENSE GRANT. Steven Greenberg ("the AUTHOR") grants you a non-exclusive and non-transferable license to reproduce and use the SOFTWARE for personal or internal business purposes. “The SOFTWARE” refers to the GSpot executable file itself as well as all related data, text and other files contained in the GSpot distribution package. This license does not entitle you to receive from AUTHOR hard-copy documentation, technical support, telephone assistance, or enhancements or updates to the SOFTWARE.
2. OWNERSHIP. The SOFTWARE is owned and copyrighted by the AUTHOR. Your license confers no title or ownership in the SOFTWARE and should not be construed as a sale of any right in the SOFTWARE.
3. COPYRIGHT. The SOFTWARE is protected by United States copyright law and international treaty provisions. You acknowledge that no title to the intellectual property in the SOFTWARE is transferred to you. You agree that any copies of the SOFTWARE you create will contain the same proprietary notices which appear on and in the SOFTWARE.
4. DISTRIBUTION.
a) You may distribute an unlimited number of exact, unmodified, individual copies of the SOFTWARE to anyone you wish, in accordance with this agreement, by making such copies available for download (e.g., via the Internet, on-line services, bulletin boards, etc.).
b) Distribution (other than single copy) via removable storage or other physical media (e.g., floppy disks, CD-ROMs, etc.) requires the express permission of the AUTHOR. This includes, but is not limited to, shareware and freeware collection disks, disks distributed with published magazines, etc.
c) Regardless of the method of distribution, you are specifically prohibited from charging or requesting donations for any such copies, and from distributing the SOFTWARE bundled with other hardware or software products, commercial or otherwise, without first obtaining written permission from the AUTHOR.
5. REVERSE ENGINEERING. You may not decompile, reverse engineer, or disassemble the SOFTWARE. You may not modify, rent or resell for profit the SOFTWARE. You may not remove any copyright notices from the SOFTWARE. You may not create derivative works based upon the SOFTWARE, including but not limited to modification of the SOFTWARE's text to other languages, without the permission of the AUTHOR.
6. SEVERABILITY. In the event of invalidity of any provision of this license, the parties agree that such invalidity shall not affect the validity of the remaining portions of this license.
7. EXCLUSION OF OTHER WARRANTIES. EXCEPT AS PROVIDED ABOVE, THE SOFTWARE IS PROVIDED "AS IS" WITHOUT ANY EXPRESS OR IMPLIED WARRANTY OF ANY KIND INCLUDING WARRANTIES OF MERCHANTABILITY, NONINFRINGEMENT, OR FITNESS FOR A PARTICULAR PURPOSE.
8. LIMITATION OF LIABILITY. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DAMAGES WHATSOEVER (INCLUDING, WITHOUT LIMITATION, LOST PROFITS, BUSINESS INTERRUPTION, OR LOST INFORMATION) ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE, EVEN IF THE AUTHOR HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
9. ENTIRE AGREEMENT. This is the entire agreement between you and the AUTHOR which supersedes any prior agreement or understanding, whether written or oral, relating to the subject matter of this license.
10. RESERVED RIGHTS. All rights not expressly granted here are reserved to the AUTHOR.