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

Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up..
CEILING.PRECISE(number, [significance])
Returns the requested information about the specified cell.
CELL(info_type, reference)
Convert a number into a character according to the current Unicode table.
CHAR(table_number)
Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.
CHIDIST(x, degrees_freedom)
Calculates the inverse of the right-tailed chi-squared distribution.
CHIINV(probability, degrees_freedom)
Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.
CHISQ.DIST(x, degrees_freedom, cumulative)
Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing.
CHISQ.DIST.RT(x, degrees_freedom)
Calculates the inverse of the left-tailed chi-squared distribution.
CHISQ.INV(probability, degrees_freedom)
Calculates the inverse of the right-tailed chi-squared distribution.
CHISQ.INV.RT(probability, degrees_freedom)
See CHITEST
CHISQ.TEST(observed_range, expected_range)
Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution.
CHITEST(observed_range, expected_range)
Returns an element from a list of choices based on index.
CHOOSE(index, choice1, [choice2, ...])
Returns the text with the non-printable ASCII characters removed.
CLEAN(text)
Returns the numeric Unicode map value of the first character in the string provided.
CODE(string)
Returns the column number of a specified cell, with `A=1`.
COLUMN([cell_reference])
Returns the number of columns in a specified array or range.
COLUMNS(range)
Returns the number of ways to choose some number of objects from a pool of a given size of objects.
COMBIN(n, k)
Returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways that choose the same object multiple times..
COMBINA(n, k)
Creates a complex number given real and imaginary coefficients.
COMPLEX(real_part, imaginary_part, [suffix])
Returns the concatenation of two values. Equivalent to the `&` operator.
CONCAT(value1, value2)
Appends strings to one another.
CONCATENATE(string1, [string2, ...])
See CONFIDENCE.NORM
CONFIDENCE(alpha, standard_deviation, pop_size)
Calculates the width of half the confidence interval for a normal distribution..
CONFIDENCE.NORM(alpha, standard_deviation, pop_size)
Calculates the width of half the confidence interval for a Student’s t-distribution..
CONFIDENCE.T(alpha, standard_deviation, size)
Converts a numeric value to a different unit of measure.
CONVERT(value, start_unit, end_unit)
Calculates r, the Pearson product-moment correlation coefficient of a dataset.
CORREL(data_y, data_x)
Returns the cosine of an angle provided in radians.
COS(angle)
Returns the hyperbolic cosine of any real number.
COSH(value)
Cotangent of an angle provided in radians..
COT(angle)
Returns the hyperbolic cotangent of any real number..
COTH(value)
Returns a count of the number of numeric values in a dataset.
COUNT(value1, [value2, ...])
Returns a count of the number of values in a dataset.
COUNTA(value1, [value2, ...])
Returns the number of empty cells in a given range.
COUNTBLANK(range)
Returns a conditional count across a range.
COUNTIF(range, criterion)
Returns the count of a range depending on multiple criteria.
COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Counts the number of unique values in a list of specified values and ranges.
COUNTUNIQUE(value1, [value2, ...])
Returns the unique count of a range depending on multiple criteria.
COUNTUNIQUEIFS(A2:A10, B2:B10, ">20")
COUNTUNIQUEIFS(A2:A10, B2:B10, ">20", C2:C10, "<30")
COUNTUNIQUEIFS(A2:A10, D2:D10, "Yes")
Calculates the number of days from the first coupon, or interest payment, until settlement.
COUPDAYBS(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.
COUPDAYS(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days from the settlement date until the next coupon, or interest payment.
COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])
Calculates next coupon, or interest payment, date after the settlement date.
COUPNCD(settlement, maturity, frequency, [day_count_convention])
Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.
COUPNUM(settlement, maturity, frequency, [day_count_convention])
Calculates last coupon, or interest payment, date before the settlement date.
COUPPCD(settlement, maturity, frequency, [day_count_convention])
Calculates the covariance of a dataset.
COVAR(data_y, data_x)
See COVAR
COVARIANCE.P(data_y, data_x)
Calculates the covariance of a dataset, where the dataset is a sample of the total population..
COVARIANCE.S(data_y, data_x)
Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.
CRITBINOM(num_trials, prob_success, target_prob)
Returns the cosecant of an angle provided in radians..
CSC(angle)

Displaying items 49-96 of 504 in total