79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

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 an estimate of variance based on a sample, setting text to the value `0`.
VARA(value1, value2)
See VARP
VAR.P(value1, [value2, ...])
Calculates the variance based on an entire population.
VARP(value1, value2)
Calculates the variance based on an entire population, setting text to the value `0`.
VARPA(value1, value2,...)
See VAR
VAR.S(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)
See WEIBULL
WEIBULL.DIST(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])
Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows.
XIRR(cashflow_amounts, cashflow_dates, [rate_guess])
Returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match.
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 year specified by a given date.
YEAR(date)
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])
See Z.TEST.
ZTEST(data, value, [standard_deviation])

Displaying items 481-504 of 504 in total