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) |