Other Google Spreadsheets Functions


Google Spreadsheets includes more than 200 individual functions. These functions are identical to the ones built in to Microsoft Excel, so if you're an Excel user, you'll be right at home. If you're not an Excel user, or if you want a handy reference to all the available functions, see Table 10.

Table 10. Google Spreadsheet Functions

Function

Type

Description

Use (Arguments)

ABS

Math

Calculates the absolute value of a number

ABS(number)

ACCRINT

Financial

Returns the accrued interest for a security that pays periodic interest

ACCRINT(issue,first_interest,settlement,rate,par,frequency,basis)

ACCRINTM

Financial

Returns the accrued interest for a security that pays interest at maturity

ACCRINTM(issue,settlement,rate,par,basis)

ACOS

Math

Returns the arccosine (inverse cosine) of a number

ACOS(number)

ACOSH

Math

Returns the inverse hyperbolic cosine of a number

ACOSH(number)

ADDRESS

Lookup

Creates a cell address as text, given specified row and column numbers

ADDRESS(row,column,type_of_reference,reference_style, external_sheet_name)

AND

Logical

Returns TRUE if all arguments are true; returns FALSE if any argument is false

AND(condition1,condition2,condition3...)

ASIN

Math

Returns the arcsine (inverse sine) of a number

ASIN(number)

ASINH

Math

Returns the inverse hyperbolic sine of a number

ASINH(number)

ATAN

Math

Returns the arctangent (inverse tangent) of a number

ATAN(number)

ATAN2

Math

Returns the arctangent (inverse tangent) of the specified x and y coordinates

ATAN2(x,y)

ATANH

Math

Returns the inverse hyperbolic tangent of a number

ATANH(number)

AVEDEV

Statistical

Calculates the average of the absolute deviations of data points from their mean

AVEDEV(range)

AVERAGE

Statistical

Calculates the average (arithmetic mean) of a group of numbers

AVERAGE(range)

AVERAGEA

Statistical

Calculates the average (arithmetic mean) of a group of numbers, text, or logical values

AVERAGEA(range)

BINOMDIST

Statistical

Calculates the individual term binomial distribution probability

BINOMDIST(number_s,trials, probability_s,cumulative)

CEILING

Math

Rounds up a number to the nearest multiple of significance

CEILING(number,significance)

CHAR

Text

Returns the character specified by a numer

CHAR(number)

CHOOSE

Lookup

Selects a number from a list based on an index number

CHOOSE(index_number,value1, value2,value3...)

CODE

Text

Returns a numeric code for the first value in a text string

CODE(text)

COLUMNS

Lookup

Returns the number of columns in a range

COLUMNS(range)

COMBIN

Math

Returns the number of combinations for a given number of items

COMBIN(number_of_items,number_of_items_in_each_combination)

CONCATENATE

Text

Joins several text strings into a single text string

CONCATENATE(text1,text2,text3...)

CONFIDENCE

Statistical

Returns a value that can be used to construct a confidence interval for a population mean

CONFIDENCE(alpha,standard_deviation, size)

CORREL

Statistical

Returns the correlation coefficient of two cell ranges

CORREL(range1,range2)

COS

Math

Returns the cosine of a number

COS(number)

COSH

Math

Returns the hyperbolic cosine of a number

COSH(number)

COUNT

Math

Counts the number of cells in a range that contain numeric values

COUNT(range)

COUNTA

Math

Counts the number of non-blank cells in a range

COUNTA(range)

COUNTBLANK

Math

Counts the number of empty cells in a range

COUNTBLANK(range)

COUNTIF

Math

Counts the number of cells in a range that meet a specified criteria

COUNTIF(range,criteria)

COUPDAYBS

Financial

Returns the number of days from the beginning of the coupon period to the settlement date

COUPDAYBS(settlement, maturity, frequency,basis)

COUPDAYS

Financial

Returns the number of days in the coupon period that contains the settlement date

COUPDAYS(settlement,maturity, frequency,basis)

COUPDAYSNC

Financial

Returns the number of days from the settlement date to the next coupon date

COUPDAYSNC(settlement,maturity, frequency,basis)

COUPNCD

Financial

Returns a number that represents the next coupon date after the settlement date

COUPNCD(settlement, maturity, frequency, basis)

COUPNUM

Financial

Returns the number of coupons payable between the settlement date and maturity date

COUPNUM(settlement,maturity,frequency,basis)

COUPPCD

Financial

Returns a number that represents the previous coupon date before the settlement date

COUPPCD(settlement,maturity,frequency,basis)

COVAR

Statistical

Returns covariance (the average of the products of deviations for each data point pair)

COVAR(range1,range2)

CRITBINOM

Statistical

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to the criterion value

CRITBINOM(trials,probability_s,alpha)

CUMIPMT

Financial

Returns the relative interest paid between the start and the end of a loan

CUMIPMT(rate,nper,present_value,start_period,end_period,type)

CUMPRINC

Financial

Returns the cumulative principal paid on a loan between two dates

CUMPRINC(rate,nper,present_value,start_period,end_period,type)

DATE

Date

Converts a date into a sequential serial number that represents that date

DATE(year,month,day)

DATEVALUE

Date

Converts a properly formatted text string (such as "1/20/2006") into a valid date

DATEVALUE(date_text)

DAY

Date

Returns the day of the week that corresponds to a specified date

DAY(date)

DAYS360

Date

Returns the number of days in between two dates, based on a 360 day year; use TRUE to use U.S. method of calculation, or FALSE to use the European method

DAYS360(start_date,end_date,method)

DB

Financial

Calculates depreciation using the fixed-declining balance method

DB(cost,salvaged,life,period,month)

DDB

Financial

Calculates depreciation using the double declining balance method

DDB(cost,salvage,life,period,factor)

DEGREES

Math

Converts radians into degrees

DEGREES(angle)

DEVSQ

Statistical

Returns the sum of squares of deviations of data points from their sample mean

DEVSQ(number1,number2,number3...)

DISC

Financial

Returns the discount rate for a security

DISC(settlement,maturity,pr,redemption,basis)

DOLLAR

Text

Converts a number to text format and applies a currency symbol

DOLLAR(number,decimals)

DOLLARDE

Financial

Converts a dollar price expressed as a fraction into a price expressed as a decimal number

DOLLARDE(fractional_dollar,fraction_denominator)

DOLLARFR

Financial

Converts a dollar price expressed as a decimal number into a price

DOLLARFR(decimal_dollar,expressed as a fraction fraction_denominator)

DURATION

Financial

Returns the Macauley duration for an assumed par value of $100

DURATION(settlement,maturity,coupon,yield,frequency,basis)

EDATE

Date

Returns the serial number that represents the date that is the indicated number of months before or after a specified date

EDATE(start_date,months)

EFFECT

Financial

Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year

EFFECT(nominal_rate,periods_per_year)

EOMONTH

Date

Returns the serial number for the last day of the month that is the indicated number of months before the start date

EOMONTH(start_date,months)

ERRORTYPE

Info

Returns a number corresponding to a specified error value

ERRORTYPE(error_value)

EVEN

Math

Rounds up the number to the next even integer

EVEN(number)

EXACT

Text

Compares two text strings; returns TRUE if they are exactly the same, or FALSE if not

EXACT(text1,text2)

EXP

Math

Returns the value of e raised to the power of a number

EXP(number)

EXPONDIST

Statistical

Calculates the exponential distribution

EXPONDIST(x,lambda,cumulative)

FACT

Math

Returns the factorial of a number

FACT(number)

FACTDOUBLE

Math

Returns the double factorial of a number

FACTDOUBLE(number)

FIND

Text

Locates one text string within a second text string, and returns the starting position of the interior string

FIND(find_text,within_text,start_num)

FISHER

Statistical

Returns the Fisher transformation at x

FISHER(x)

FISHERINV

Statistical

Returns the inverse of the Fisher transformation

FISHERINV(y)

FIXED

Text

Rounds a number to the specified number of decimals, formats the number with a period and commas, and returns the result as text

FIXED(number,decimals,no_commas)

FLOOR

Math

Rounds down the number, to the nearest multiple of significance

FLOOR(number,significance)

FORECAST

Statistical

Calculates a future value by using existing values

FORECAST(x,known_y's,known_x's)

FREQUENCY

Statistical

Calculates how often values occur within a range of values, then returns a vertical array of numbers

FREQUENCY(data_array,bins_array)

FV

Financial

Calculates the future value of an investment, based on periodic, constant payments and a constant interest rate

FV(rate,periods,payment,present_value,type)

FVSCHEDULE

Financial

Calculates the future value of an initial principal after applying a series of compound interest rates

FVSCHEDULE(principal,schedule)

GCD

Math

Returns the greatest common divisor of two or more numbers

GCD(number1,number2,number3...)

GEOMEAN

Statistical

Returns the geometric mean of a range of positive data

GEOMEAN(number1,number2,number3...)

GROWTH

Statistical

Calculates predicted exponential growth by using existing data

GROWTH(known_y's,known_x's,new_x's,constant)

HARMEAN

Statistical

Returns the harmonic mean of a data set

HARMEAN(number1,number2,number3...)

HLOOKUP

Lookup

Searches for a value in the top row of a range, and then returns a value in the same column from another specified row

LOOKUP(lookup_value,range,row_index_number,range_lookup)

HYPGEOMDIST

Statistical

Returns the hypergeometric distribution (the probability of sample successes)

HYPGEOMDIST(sample_s,number_sample,population_s,number_population)

IF

Logical

Tests whether a condition is true or false

IF(condition,value_if_true,value_if_false)

INDIRECT

Lookup

Returns the reference specified by a text string

INDIRECT(cell,type_of_reference)

INT

Math

Rounds a number down to the nearest integer

INT(value)

INTERCEPT

Statistical

Calculates the point at which a line will intersect the x-axis by using existing x and y values

INTERCEPT(known_y's,known_x's)

IPMT

Financial

Calculates the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate

IPMT(rate,period,number_of_periods,present_value,future_value,type)

IRR

Financial

Calculates the internal rate of return for a series of cash flows

IRR(values,guess)

ISBLANK

Info

Tests whether a cell is blank

ISBLANK(cell)

ISERR

Info

Tests whether a cell contains an error value (except for #N/A)

ISERR(cell)

ISERROR

Info

Tests whether a cell contains any error value

ISERROR(cell)

ISEVEN

Info

Tests whether a number is even

ISEVEN(number)

ISLOGICAL

Info

Tests whether a cell contains a logical value

ISLOGICAL(cell)

ISNA

Info

Tests whether a cell contains the #N/A error value

ISNA(cell)

ISNONTEXT

Info

Tests whether a cell contains an item that is not text

ISNONTEXT(cell)

ISNUMBER

Info

Tests whether a cell contains a number

ISNUMBER(cell)

ISODD

Info

Tests whether a number is odd

ISODD(number)

ISREF

Info

Tests whether a cell contains a reference

ISREF(cell)

ISTEXT

Info

Tests whether a cell contains text

ISTEXT(cell)

KURT

Statistical

Returns the kurtosis of a data set

KURT(number1,number2,number3...)

LARGE

Statistical

Returns the k-th largest value in a range of cells

LARGE(range,k)

LCM

Math

Returns the least common multiple of integers

LCM(number1,number2,number3...)

LEFT

Text

Returns the first character(s) in a text string, based on the number of characters you specify

LEFT(text,number_of_characters)

LEN

Text

Returns the number of characters in a text string

LEN(text)

LINEST

Statistical

Calculates a straight line that best fits given data using the "least squares" method, returning an array that describes the line

LINEST(known_y's,known_x's,constant,stats)

LN

Math

Returns the natural logarithm of a number

LN(number)

LOG

Math

Returns the logarithm of a number to the base you specify

LOG(number,base)

LOG10

Math

Returns the base-10 logarithm of a number

LOG10(number)

LOGEST

Statistical

In regression analysis, calculates an exponential curve that fits the given data, then returns an array that describes the curve

LOGEST(known_y's,known_x's,constant,stats)

LOGINV

Statistical

Returns the inverse of the lognormal cumulative distribution function of x

LOGINV(probability,mean,standard_deviation)

LOGNORMDIST

Statistical

Returns the cumulative lognormal distribution of x

LOGNORMDIST(x,mean,standard_deviation)

LOWER

Text

Converts all characters in a text string to lowercase

LOWER(text)

MAX

Statistical

Returns the largest numeric value in a range of cells

MAX(range)

MAXA

Statistical

Returns the largest value in a range of cells; can include numbers, text, or logical values

MAXA(range)

MATCH

Text

Returns the relative position of an item in a range that matches a specified value in a specified order

MATCH(lookup_value,lookup_range,match_type)

MDETERM

Math

Returns the matrix determinant of an array

MDETERM(array)

MDURATION

Financial

Returns the modified Macauley duration for a security with an assumed par value of $100

MDURATION(settlement,maturity,coupon,yield,frequency,basis)

MEDIAN

Statistical

Returns the median of a range of numbers or cells

MEDIAN(range) or MEDIAN(number1,number2,number3...)

MID

Text

Returns a specific number of characters from a text string, starting at a specified position

MID(text,start_number,number_of_characters)

MIN

Statistical

Returns the minimum numeric value in a range of cells

MIN(range)

MINA

Statistical

Returns the minimum value in a range of cells; can include numbers, text, or logical values

MINA(range)

MINVERSE

Math

Returns the inverse matrix for the matrix stored in an array

MINVERSE(array)

MIRR

Financial

Calculates the modified internal rate of return for a series of periodic cash flows

MIRR(values,finance_rate,reinvest_rate)

MMULT

Math

Returns the matrix product of two arrays

MMULT(array1,array2)

MOD

Math

Returns the modulus of a divisor and a dividendthat is, the remainder after a number is divided by the divisor

MOD(number,divisor)

MODE

Statistical

Returns the most frequently occurring value in a range of data

MODE(range) or MODE(number1,number2,number3...)

MONTH

Date

Returns the month of a date represented by a given serial number

MONTH(serial_number)

MROUND

Math

Returns a number rounded to the desired multiple

MROUND(number,multiple)

MULTINOMIAL

Math

Returns the ratio of the factorial of a sum of values to the product of the factorials

MULTINOMIAL(number1,number2,number3...)

N

Info

Returns a value converted into a number

N(value)

NA

Info

Returns the error value #N/A (which means "no value is available")

NA()

NEGBINOMDIST

Statistical

Calculates the negative binomial distribution

NEGBINOMDIST(number_f,number_s,probability_s)

NETWORKDAYS

Date

Returns the number of whole working days between a start and an end date (working days exclude weekends and holidays)

NETWORKDAYS(start_date,end_date,holidays)

NOMINAL

Financial

Calculates the nominal annual interest rate, given the effective rate and the number of compounding periods per year

NOMINAL(effective_rate,periods_per_year)

NORMDIST

Statistical

Returns the normal distribution for the specified mean and standard deviation

NORMDIST(x,mean,standard_deviation,cumulative)

NORMINV

Statistical

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation

NORMINV(probability,mean,standard_deviation)

NORMSDIST

Statistical

Returns the standard normal cumulative distribution

NORMSDIST(z)

NORMSINV

Statistical

Returns the inverse of the standard normal cumulative distribution

NORMSINV(probability)

NOT

Logical

Reverses the value of its argument

NOT(value)

NOW

Time

Returns the serial number of the current date and time, using your PC's built-in clock

NOW()

NPER

Financial

Calculates the number of payments required to pay off a loan at a given interest rate

NPER(rate,payment,present_value,future_value,type)

NPV

Financial

Calculates the net present value of an investment, using a discount rate and a series of future payments (negative values) and income (positive values)

NPV(rate,value1,value2...)

ODD

Math

Returns the number rounded up to the nearest odd integer

ODD(number)

OFFSET

Lookup

Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells

OFFSET(reference,rows,columns,height,width)

OR

Logical

Returns TRUE if any argument is true; returns FALSE if all arguments are false

OR(condition1,condition2,condition3...)

PEARSON

Statistical

Returns the Pearson product moment correlation coefficient

PEARSON(range1,range2)

PERCENTILE

Statistical

Returns the k-th percentile of values in a range

PERCENTILE(range,k)

PERCENTRANK

Statistical

Returns the rank of a value in a data set as a percentage of the data set

PERCENTRANK(range,x,significance)

PERMUT

Statistical

Calculates the number of permutations for a given number of objects that can be selected from number objects

PERMUT(number,number_chosen)

PI

Math

Used in the place of the value pi

PI()

PMT

Financial

Calculates the payment amount required for an investment to bepaid off given a specific term and interest rate

PMT(rate,number_of_periods,present_value,future_value,type)

POISSON

Statistical

Returns the Poisson distribution (to predict the number of events over a specific time)

POISSON(x,mean,cumulative)

POWER

Math

Returns the result of a number raised to a given poser

POWER(number,power)

PPMT

Financial

Calculates the amount of principal being paid during any payment period

PPMT(rate,period,number_of_periods,present_value,future_value,type)

PRICE

Financial

Returns the price per $100 face value of a security that pays periodic interest

PRICE(settlement,maturity,rate,yield,redemption,frequency,basis)

PRICEDISC

Financial

Returns the price per $100 face value of a discounted security

PRICEDISC(settlement,maturity,discount,redemption,basis)

PRICEMAT

Financial

Returns the price per $100 face value of a security that pays interest at maturity

PRICEMAT(settlement,maturity,issue,rate,yield,basis)

PROB

Statistical

Returns the probability that values within a range are between two limits

PROB(x_range,prob_range,lower_limit,upper_limit)

PRODUCT

Math

Multiplies all the numbers in a given range or argument

PRODUCT(number1,number2,number3...) or PRODUCT(range)

PROPER

Text

Capitalizes the first letter in a text string (and any other letters that follow a character other than a letter); converts all other letters to lowercase

PROPER(text)

PV

Financial

Calculates the present value of an investment

PV(rate,number_of_payments,payment,future_value,type)

QUARTILE

Statistical

Calculates the quartile of a data set

QUARTILE(range,quart)

QUOTIENT

Math

Returns the integer portion of a division, discarding the remainder

QUOTIENT(numerator,denominator)

RADIANS

Math

Converts degrees to radians

RADIANS(angle)

RAND

Math

Returns an evenly distributed random real numbergreater than or equal to zero and less than 1

RAND()

RANDBETWEEN

Math

Returns a random integer number between two numbers you specify

RANDBETWEEN(lower_number,higher_number)

RANK

Statistical

Returns the rank of a number in a range or list of numbers

RANK(number,ref,order)

RATE

Financial

Calculates the interest rate per period of an annuity

RATE(number_of_periods,payment,present_value,future_value,type,guess)

RECEIVED

Financial

Calculates the amount received at maturity for a fully invested security

RECEIVED(settlement,maturity,investment,discount,basis)

REPLACE

Text

Replaces part of a text string with another text string

REPLACE(old_text,start_number,number_of_characters,new_text)

REPT

Text

Repeats text a given number of times

REPT(text,number_of_times)

RIGHT

Text

Returns the last character(s) in a string

RIGHT(text,number_of_characters)

ROUND

Math

Rounds a number to a specified number of digits

ROUND(number,number_of_digits)

ROUNDDOWN

Math

Rounds down a number to a specified number of digits

ROUNDDOWN(number,number_of_digits)

ROUNDUP

Math

Rounds up a number to a specified number of digits

ROUNDUP(number,number_of_digits)

ROW

Lookup

Returns the row number of a cell or range of cells

ROW(cell)

ROWS

Lookup

Returns the number of rows in a range

ROW(range)

RSQ

Statistical

Returns the square of the Pearson product moment correlation coefficient

RSQ(known_y's,known_x's)

SEARCH

Text

Locates one text string within a second text string, and returns the starting point of the inside text string

SEARCH(find_text,within_text,start_number)

SERIESSUM

Math

Returns the sum of a power series

SERIESSUM(x,n,m,coefficients)

SIGN

Math

Determines the sign (positive or negative) of a number

SIGN(number)

SIN

Math

Returns the sine of a given number or angle

SINE(number)

SINH

Math

Returns the hyperbolic sine of a number or angle

SINH(number)

SKEW

Statistical

Returns the skewness of a distribution

SKEW(number1,number2,number3...)

SLN

Financial

Calculates depreciation using the straight line method

SLN(cost,salvage,life)

SLOPE

Statistical

Returns the slope of the linear regression line through known x and y data points

SLOPE(known_y's,known_x's)

SMALL

Statistical

Returns the k-th smallest value in a data set

SMALL(range,k)

SQRT

Math

Returns a positive square root

SQRT(number)

SQRTPI

Math

Returns the square root of (number * pi)

SQRTPI(number)

STANDARDIZE

Statistical

Returns a normalized value from a distribution characterized by mean and standard deviation

STANDARDIZE(x,mean,standard_deviation)

STDEV

Statistical

Estimates standard deviation based on a numerical sample

STDEV(range)

STDEVA

Statistical

Estimates standard deviation; can include numbers, text, or logical values

STDEVA(range)

STDEVP

Statistical

Calculates standard deviation based on the entire population given as arguments

STDEVP(range)

STDEVPA

Statistical

Calculates standard deviation based on the entire population given as arguments, including text and logical values

STDEVPA(range)

STEYX

Statistical

Returns the standard error of the predicted y value for each x in the regression

STEYX(known_y's,known_x's)

SUBSTITUTE

Text

Substitutes new text for old text in a text string

SUBSTITUTE(text,old_text,new_text,instance_number)

SUM

Math

Calculates the total of a group of cells

SUM(range)

SUMIF

Math

Calculates the total of a group of cells defined by a given criteria

SUMIF(range,criteria,sum_range)

SUMPRODUCT

Math

Multiplies corresponding components in the given arrays, and returns the sum of those products

SUMPRODUCT(array1,array2,array3...)

SUMSQ

Math

Returns the sum of the squares of a series of numbers

SUMSQ(number1,number2,number3...)

SUMX2MY2

Math

Returns the sum of the difference of squares of corresponding values in two arrays

SUMX2MY2(array_x,array_y)

SUMX2PY2

Math

Returns the sum of the squares of corresponding values in two arrays

SUMX2PY2(array_x,array_y)

SUMXMY2

Math

Returns the sum of squares of differences of corresponding values in two arrays

SUMXMY2(array_x,array_y)

SYD

Financial

Calculates depreciation using the sum of the years' digits method

SYD(cost,salvage,life,period)

T

Text

Returns the text referred to by value

T(value)

TAN

Math

Returns the tangent of a number

TAN(number)

TANH

Math

Returns the hyperbolic tangent of a number

TANH(number)

TBILLEQ

Financial

Calculates the bond-equivalent yield for a Treasury bill

TBILLEQ(settlement,maturity,discount)

TBILLPRICE

Financial

Calculates the price per $100 face value for a Treasury bill

TBILLPRICE(settlement,maturity,discount)

TBILLYIELD

Financial

Calculates the yield for a Treasury bill

TBILLYIELD(settlement,maturity,price)

TEXT

Text

Converts a value to text in a specific number format

TEXT(value,format_text)

TODAY

Date

Returns the serial number of the current date

TODAY()

TRANSPOSE

Lookup

Flips a vertical range of cells horizontally, or vice versa

TRANSPOSE(range)

TREND

Statistical

Returns values along a linear trend

TREND(known_y's,known_x's,new_x's,constant)

TRIM

Text

Removes all spaces from a text string except for single spaces between words

TRIM(text)

TRIMMEAN

Statistical

Returns the mean of the interior of a data set, excluding a percentage of the data points from the top and bottom tails of the set

TRIMMEAN(range,percent)

TRUNC

Math

Truncates a number to an integer by removing the fractional part of the number; you can specify precision of the truncation by indicating how many digits to include

TRUNC(number,number_of_digits)

UPPER

Text

Converts text to all uppercase

UPPER(text)

VALUE

Text

Converts a text string that represents a number to that number

VALUE(text)

VAR

Statistical

Estimates variance based on a numeric sample

VAR(range)

VARA

Statistical

Estimates variance based on a sample; can include numbers, text, and logical values

VARA(range)

VARP

Statistical

Calculates variance based on the total numeric population

VARP(range)

VARPA

Statistical

Calculates variance based on the entire population, including numeric, text, and logical values

VARPA(range)

VLOOKUP

Lookup

Searches for a value in the first column of a range, and then returns a value in the same row from another specified column

VLOOKUP(lookup_value,range,column_index_number,range_lookup)

WEEKDAY

Date

Returns the day of the week that corresponds to any valid date

WEEKDAY(serial_number,return_type)

WEIBULL

Statistical

Returns the Weibull distribution

WEIBULL(x,alpha,beta,cumulative)

WORKDAY

Date

Returns a number that represents a date that is the indicated number of working days before or after a start date

WORKDAY(start_date,days,holidays)

XIRR

Financial

Calculates the internal rate of return for a schedule of cash flows that is not necessarily periodic

XIRR(values,dates,guess)

XNPV

Financial

Calculates the net present value for a schedule of cash flows that is not necessarily periodic

XNPV(rate,values,dates)

YEAR

Date

Returns the year corresponding to a specified date serial number

YEAR(serial_number)

YEARFRAC

Date

Calculates the fraction of a year represented by the number of whole days between two dates

YEARFRAC(start_date,end_date,basis)

YIELD

Financial

Calculates the yield on a security that pays back periodic interest

YIELD(settlement,maturity,rate,price,redemption,frequency,basis)

YIELDDISC

Financial

Calculates the annual yield for a discounted security

YIELDDISC(settlement,maturity,price,redemption,basis)

ZTEST

Statistical

Returns the one-tailed probability value of a z-test

ZTEST(range,value_to_test,sigma)





Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net