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

Learn more

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.

Learn more

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

Learn more

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.

Learn more

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.

Learn more

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.

Learn more

504Formulas

Every Formula in Google Sheets, From ABS to ZTEST, including Vlookup and, my favorite, IF()

HARMEAN()

Calculates the harmonic mean of a dataset.

HARMEAN(value1, value2)

HEX2BIN()

Converts a signed hexadecimal number to signed binary format.

HEX2BIN(signed_hexadecimal_number, [significant_digits])

HEX2DEC()

Converts a signed hexadecimal number to decimal format.

HEX2DEC(signed_hexadecimal_number)

HEX2OCT()

Converts a signed hexadecimal number to signed octal format.

HEX2OCT(signed_hexadecimal_number, significant_digits)

HLOOKUP()

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

HOUR()

Returns the hour component of a specific time, in numeric format.

HOUR(time)

HYPERLINK()

Creates a hyperlink inside a cell.

HYPERLINK(url, [link_label])

HYPGEOM.DIST()

See HYPGEOMDIST

HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)

HYPGEOMDIST()

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)

IF()

Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.

IF(logical_expression, value_if_true, value_if_false)

IFERROR()

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

IFNA()

Evaluates a value. If the value is an #N/A error, returns the specified value..

IFNA(value, value_if_na)

IFS()

Evaluates multiple conditions and returns a value that corresponds to the first true condition..

IFS(condition1, value1, [condition2, value2], …)

IMABS()

Returns absolute value of a complex number.

IMABS(number)

IMAGE()

Inserts an image into a cell.

IMAGE(url, [mode], [height], [width])

IMAGINARY()

Returns the imaginary coefficient of a complex number.

IMAGINARY(complex_number)

IMARGUMENT()

The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians..

IMARGUMENT(number)

IMCONJUGATE()

Returns the complex conjugate of a number.

IMCONJUGATE(number)

IMCOS()

The IMCOS function returns the cosine of the given complex number..

IMCOS(number)

IMCOSH()

Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi).".

IMCOSH(number)

IMCOT()

Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi).".

IMCOT(number)

IMCOTH()

Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi).".

IMCOTH(number)

IMCSC()

Returns the cosecant of the given complex number..

IMCSC(number)

IMCSCH()

Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi).".

IMCSCH(number)

IMDIV()

Returns one complex number divided by another.

IMDIV(dividend, divisor)

IMEXP()

Returns Euler's number, e (~2.718) raised to a complex power..

IMEXP(exponent)

IMLN()

Returns the logarithm of a complex number, base e (Euler's number).

IMLN(complex_value)

IMLOG()

Returns the logarithm of a complex number for a specified base..

IMLOG(value, base)

IMLOG10()

Returns the logarithm of a complex number with base 10..

IMLOG10(value)

IMLOG2()

Returns the logarithm of a complex number with base 2..

IMLOG2(value)

IMPORTDATA()

Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

IMPORTDATA(url)

IMPORTFEED()

Imports a RSS or ATOM feed.

IMPORTFEED(url, [query], [headers], [num_items])

IMPORTHTML()

Imports data from a table or list within an HTML page.

IMPORTHTML(url, query, index)

IMPORTRANGE()

Imports a range of cells from a specified spreadsheet.

IMPORTRANGE(spreadsheet_url, range_string)

IMPORTXML()

Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

IMPORTXML(url, xpath_query)

IMPOWER()

Returns a complex number raised to a power.

IMPOWER(complex_base, exponent)

IMPRODUCT()

Returns the result of multiplying a series of complex numbers together.

IMPRODUCT(factor1, [factor2, ...])

IMREAL()

Returns the real coefficient of a complex number.

IMREAL(complex_number)

IMSEC()

Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi).".

IMSEC(number)

IMSECH()

Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi).".

IMSECH(number)

IMSIN()

Returns the sine of the given complex number..

IMSIN (number)

IMSINH()

Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi).".

IMSINH(number)

IMSQRT()

Computes the square root of a complex number.

IMSQRT(complex_number)

IMSUB()

Returns the difference between two complex numbers.

IMSUB(first_number, second_number)

IMSUM()

Returns the sum of a series of complex numbers.

IMSUM(value1, [value2, ...])

IMTAN()

Returns the tangent of the given complex number..

IMTAN(number)

IMTANH()

Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi).".

IMTANH(number)

INDEX()

Returns the content of a cell, specified by row and column offset.

INDEX(reference, [row], [column])

Displaying items 193-240 of 504 in total

Most Popular Formulas

IF

FILTER

COUNTIF

Most Misused Formulas

VLOOKUP

SUMIF

CONCATENATE

504Formulas