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()
VARA(value1, value2)
VARPA(value1, value2,...)
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
VLOOKUP(search_key, range, index, [is_sorted])
WEEKDAY(date, [type])
WEEKNUM(date, [type])
WEIBULL(x, shape, scale, cumulative)
WORKDAY(start_date, num_days, [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])
XNPV(discount, cashflow_amounts, cashflow_dates)
XOR(logical_expression1, [logical_expression2, ...])
YEARFRAC(start_date, end_date, [day_count_convention])
YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])
YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])
YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])
Z.TEST(data, value, [standard_deviation])
Displaying items 481-504 of 504 in total