Page 11 of 11
TYPE
Returns a number associated with the type of data passed into the function.
TYPE(value)
UMINUS
Returns a number with the sign reversed.
UMINUS(value)
UNARY_PERCENT
Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.
UNARY_PERCENT(percentage)
UNICHAR
Returns the Unicode character for a number..
UNICHAR(number)
UNICODE
Returns the decimal Unicode value of the first character of the text..
UNICODE(text)
UNIQUE
Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the...
UNIQUE(range)
UNIQUE
Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the...
UNIQUE(range, by_column, exactly_once)
UPLUS
Returns a specified number, unchanged.
UPLUS(value)
UPPER
Converts a specified string to uppercase.
UPPER(text)
VALUE
Converts a string in any of the date, time or number formats that Google Sheets understands into ...
VALUE(text)
VAR
Calculates the variance based on a sample.
VAR(value1, [value2, ...])
VAR.P
See VARP
VAR.P(value1, [value2, ...])
VAR.S
See VAR
VAR.S(value1, [value2, ...])
VARA
Calculates an estimate of variance based on a sample, setting text to the value `0`.
VARA(value1, value2)
VARP
Calculates the variance based on an entire population.
VARP(value1, value2)
VARPA
Calculates the variance based on an entire population, setting text to the value `0`.
VARPA(value1, value2,...)
VDB
Returns the depreciation of an asset for a particular period (or partial period)..
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
VLOOKUP
Vertical lookup. Searches down the first column of a range for a key and returns the value of a s...
VLOOKUP(search_key, range, index, [is_sorted])
VSTACK
Appends ranges vertically and in sequence to return a larger array.
VSTACK(range1, [range2, ...])
WEEKDAY
Returns a number representing the day of the week of the date provided.
WEEKDAY(date, [type])
WEEKNUM
Returns a number representing the week of the year where the provided date falls.
WEEKNUM(date, [type])
WEIBULL
Returns the value of the Weibull distribution function (or Weibull cumulative distribution functi...
WEIBULL(x, shape, scale, cumulative)
WEIBULL.DIST
See WEIBULL
WEIBULL.DIST(x, shape, scale, cumulative)
WORKDAY
Calculates the end date after a specified number of working days.
WORKDAY(start_date, num_days, [holidays])
WORKDAY.INTL
Calculates the date after a specified number of workdays excluding specified weekend days and hol...
WORKDAY.INTL(start_date, num_days, [weekend], [holidays])
WRAPCOLS
Wraps a row or column of cells into a new array by filling down each column after a specified num...
WRAPCOLS(range, wrap_count, [pad_with])
WRAPROWS
Wraps a row or column of cells into a new array by filling across each row after a specified numb...
WRAPROWS(range, wrap_count, [pad_with])
XIRR
Calculates the internal rate of return of an investment based on a specified series of potentiall...
XIRR(cashflow_amounts, cashflow_dates, [rate_guess])
XLOOKUP
Returns the values in the result range based on the position where a match was found in the looku...
XLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode])
XNPV
Calculates the net present value of an investment based on a specified series of potentially irre...
XNPV(discount, cashflow_amounts, cashflow_dates)
XOR
The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are differ...
XOR(logical_expression1, [logical_expression2, ...])
YEAR
Returns the year specified by a given date.
YEAR(date)
YEARFRAC
Returns the number of years, including fractional years, between two dates using a specified day ...
YEARFRAC(start_date, end_date, [day_count_convention])
YIELD
Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, b...
YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])
YIELDDISC
Calculates the annual yield of a discount (non-interest-bearing) security, based on price.
YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])
YIELDMAT
Calculates the annual yield of a security paying interest at maturity, based on price.
YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])
Z.TEST
Returns the one-tailed P-value of a Z-test with standard distribution..
Z.TEST(data, value, [standard_deviation])
ZTEST
See Z.TEST.
ZTEST(data, value, [standard_deviation])