Calculates an estimate of variance based on a sample, setting text to the value `0`.
79% OFF online library of tutorials for mastering Google Sheets
Hey there! Register a new account to access the full suite of features, tutorials, and more..
Most Popular Formulas
IF
Powerful and mysterious. Use IF() to make your spreadsheets gateways. Learn how to use IF in Google Sheets. Also check out it's oft-partner ISBLANK()
FILTER
the FILTER() formula in Google Sheets allows you to filter data based on a set of criteria. Learn how to use FILTER in Google Sheets. Also check out it's possible combination alternative: INDEX/SORT.
COUNTIF
Count the number of cells that meet a certain criteria. Learn how to use COUNTIF in Google Sheets. Also check out it's possible parter: UNIQUE()
Most Misused Formulas
VLOOKUP
Powerful vlookup and easy to use. Learn how to use VLOOKUP in Google Sheets. Also check out it's possible alternative: INDEX/MATCH.
SUMIF
Don't know the syntax, or how to use SUMIF? Learn how to use SUMIF in Google Sheets. Also check out it's possible alternative: COUNTIF. Depending on what you're trying to do, SUMIF could be your solution or not.
CONCATENATE
Probably the most easily misspelled formula in all of Google Sheets. Learn how to use CONCATENATE in Google Sheets. Also check out it's possible alternative: JOIN.
504Formulas
Every Formula in Google Sheets, From ABS to ZTEST, including Vlookup and, my favorite, IF()
Calculates the variance based on an entire population, setting text to the value `0`.
VARPA(value1, value2,...)
Returns the depreciation of an asset for a particular period (or partial period)..
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.
VLOOKUP(search_key, range, index, [is_sorted])
Returns a number representing the day of the week of the date provided.
WEEKDAY(date, [type])
Returns a number representing the week of the year where the provided date falls.
WEEKNUM(date, [type])
Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.
WEIBULL(x, shape, scale, cumulative)
Calculates the end date after a specified number of working days.
WORKDAY(start_date, num_days, [holidays])
Calculates the date after a specified number of workdays excluding specified weekend days and holidays.
WORKDAY.INTL(start_date, num_days, [weekend], [holidays])
XIRR(cashflow_amounts, cashflow_dates, [rate_guess])
XLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode])
Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate.
XNPV(discount, cashflow_amounts, cashflow_dates)
The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise..
XOR(logical_expression1, [logical_expression2, ...])
Returns the number of years, including fractional years, between two dates using a specified day count convention.
YEARFRAC(start_date, end_date, [day_count_convention])
Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price.
YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])
Calculates the annual yield of a discount (non-interest-bearing) security, based on price.
YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])
Calculates the annual yield of a security paying interest at maturity, based on price.
YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])
Returns the one-tailed P-value of a Z-test with standard distribution..
Z.TEST(data, value, [standard_deviation])
Displaying items 481-504 of 504 in total