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..

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

# 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 harmonic mean of a dataset.
HARMEAN(value1, value2)
Converts a signed hexadecimal number to signed binary format.
HEX2BIN(signed_hexadecimal_number, [significant_digits])
Converts a signed hexadecimal number to decimal format.
HEX2DEC(signed_hexadecimal_number)
Converts a signed hexadecimal number to signed octal format.
HEX2OCT(signed_hexadecimal_number, significant_digits)
Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found.
HLOOKUP(search_key, range, index, [is_sorted])
Returns the hour component of a specific time, in numeric format.
HOUR(time)
Creates a hyperlink inside a cell.
HYPERLINK(url, [link_label])
See HYPGEOMDIST
HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)
Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws.
HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)
Returns one value if a logical expression is TRUE and another if it is FALSE.
IF(logical_expression, value_if_true, value_if_false)
Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.
IFERROR(value, [value_if_error])
Evaluates a value. If the value is an #N/A error, returns the specified value..
IFNA(value, value_if_na)
Evaluates multiple conditions and returns a value that corresponds to the first true condition..
IFS(condition1, value1, [condition2, value2], …)
Returns absolute value of a complex number.
IMABS(number)
Inserts an image into a cell.
IMAGE(url, [mode], [height], [width])
Returns the imaginary coefficient of a complex number.
IMAGINARY(complex_number)
The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians..
IMARGUMENT(number)
Returns the complex conjugate of a number.
IMCONJUGATE(number)
The IMCOS function returns the cosine of the given complex number..
IMCOS(number)
Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi).".
IMCOSH(number)
Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi).".
IMCOT(number)
Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi).".
IMCOTH(number)
Returns the cosecant of the given complex number..
IMCSC(number)
Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi).".
IMCSCH(number)
Returns one complex number divided by another.
IMDIV(dividend, divisor)
Returns Euler's number, e (~2.718) raised to a complex power..
IMEXP(exponent)
Returns the logarithm of a complex number, base e (Euler's number).
IMLN(complex_value)
Returns the logarithm of a complex number for a specified base..
IMLOG(value, base)
Returns the logarithm of a complex number with base 10..
IMLOG10(value)
Returns the logarithm of a complex number with base 2..
IMLOG2(value)
Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.
IMPORTDATA(url)
Imports a RSS or ATOM feed.
IMPORTFEED(url, [query], [headers], [num_items])
Imports data from a table or list within an HTML page.
IMPORTHTML(url, query, index)
Imports a range of cells from a specified spreadsheet.
IMPORTRANGE(spreadsheet_url, range_string)
Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.
IMPORTXML(url, xpath_query)
Returns a complex number raised to a power.
IMPOWER(complex_base, exponent)
Returns the result of multiplying a series of complex numbers together.
IMPRODUCT(factor1, [factor2, ...])
Returns the real coefficient of a complex number.
IMREAL(complex_number)
Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi).".
IMSEC(number)
Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi).".
IMSECH(number)
Returns the sine of the given complex number..
IMSIN (number)
Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi).".
IMSINH(number)
Computes the square root of a complex number.
IMSQRT(complex_number)
Returns the difference between two complex numbers.
IMSUB(first_number, second_number)
Returns the sum of a series of complex numbers.
IMSUM(value1, [value2, ...])
Returns the tangent of the given complex number..
IMTAN(number)
Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi).".
IMTANH(number)
Returns the content of a cell, specified by row and column offset.
INDEX(reference, [row], [column])

Displaying items 193-240 of 504 in total