List of 500+ Google Sheet Formulas and How to Use Them

Your ultimate destination for mastering Google Sheet formulas! Ready to transform your spreadsheets into powerful tools for analysis, reporting, and data management?


Our curated list of 500+ Google Sheet formulas provides in-depth insights and step-by-step guides on utilizing the most popular formulas like VLOOKUP, SUMIF, COUNTIF, IF, FILTER, and INDEX. Whether you're a beginner or an advanced user, Better Sheets offers resources tailored to your expertise level.


  • Unlock the potential of VLOOKUP, a dynamic formula perfect for creating summaries and managing inventory.
  • Discover the versatility of SUMIF, ideal for filtering data and calculating specific criteria.
  • Learn the intricacies of IF, a powerful tool for conditional logic in your spreadsheets.
  • Dive into advanced formulas like INDEX and FILTER, gaining expertise in data manipulation and analysis.

At Better Sheets, we not only demystify complex formulas but also offer insights into commonly misused ones. Our goal is to help you become a Google Sheets expert, so you can create powerful spreadsheets that save you time and effort. Examples and step-by-step guides are included to help you master each formula and apply it to your own spreadsheets.

Explore a New Sheet Formula

Discover new formulas you may never have heard of.

Generate New Sheet Formulas

Create sheet formulas based on simply stating your problem.

Most Used Formulas

VLOOKUP

Use VLOOKUP() when you want a specific value in a column of data. Use VLOOKUP() when you want to retrieve information from a different column based on that value. Great for creating amazing summaries, dynamic reports, or managing inventory

SUMIF

When you need to calculate the sum of values in a range of cells that meet specific criteria, use SUMIF(). Great to use when you need to filter data. For instance, you can use it to sum all the revenue generated from a particular region, all the orders placed by a specific customer, or all the products with a certain attribute.

COUNTIF

Use COUNTIF() when you're trying to figure out frequency. Learn how to use COUNTIF in Google Sheets. Also check out it's possible alternative: SUMIF. Depending on what you're trying to do, COUNTIF could be your solution or not.

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.

INDEX

A seemingly innocent and useless formula can be so powerful. INDEX pairs nicely with MATCH to replace VLOOKUP. And it's uses are almost endless. Learn more about the INDEX() formula in Google Sheets.

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.

515Google Sheets Formulas

Directory of every Google Sheets formula, From ABS to ZTEST, including Vlookup and, my favorite, IF()

Returns Euler's number, e (~2.718) raised to a power.Common Questions about the EXP Formula:1. Wh...
EXP(exponent)
Returns the factorial of a number.Common questions about the FACT Formula include:What is the FAC...
FACT(value)
Converts a provided number to a dollar value.Common Questions about the TO_DOLLARS Formula: • Wha...
TO_DOLLARS(value)
Bitwise boolean OR of 2 numbers.Common Questions about the BITOR Formula: 1. What does the BITOR ...
BITOR(value1, value2)
Shifts the bits of the input a certain number of places to the right.Common questions about the B...
BITRSHIFT(value, shift_amount)
Bitwise XOR (exclusive OR) of 2 numbers.Common Questions about the BITXOR Formula:1. What is the ...
BITXOR(value1, value2)
Returns the sine of the given complex number.Common questions about the IMSIN formula include:• W...
IMSIN (number)
Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+y...
IMSINH(number)
Creates a complex number given real and imaginary coefficients.Common questions about the COMPLEX...
COMPLEX(real_part, imaginary_part, [suffix])
Returns the difference between two complex numbers.Common Questions About the IMSUB Formula• What...
IMSUB(first_number, second_number)
Returns the sum of a series of complex numbers.Common questions about the IMSUM formula include:1...
IMSUM(value1, [value2, ...])
Returns the "double factorial" of a number.Common questions about the FACTDOUBLE formula include:...
FACTDOUBLE(value)
Converts a decimal number to signed octal format.Common questions about the DEC2OCT formula inclu...
DEC2OCT(decimal_number, [significant_digits])
Returns the hyperbolic tangent of the given complex number. For example, a given complex number "...
IMTANH(number)
Rounds a number down to the nearest integer multiple of specified significance. Common questions ...
FLOOR(value, [factor])
Compare two numeric values, returning 1 if they're equal.Common Questions about the DELTA formula...
DELTA(number1, [number2])
Returns the depreciation for an accounting period, or the prorated depreciation if the asset was ...
AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])
Rounds a number down to the nearest integer multiple of specified significance, with negative num...
FLOOR.MATH(number, [significance], [mode])
The ERF function returns the integral of the Gauss error function over an interval of values.Comm...
ERF(lower_bound, [upper_bound])
See NORMDISTCommon questions about the NORM.DIST formula include: -What does the NORM.DIST formul...
NORM.DIST(x, mean, standard_deviation, cumulative)
Returns the the logarithm of a specified Gamma function, base e (Euler's number).Common questions...
GAMMALN(value)
See GAMMALNCommon questions about the GAMMALN.PRECISE formula include:1. What does GAMMALN.PRECIS...
GAMMALN.PRECISE(value)
Returns the logarithm of a complex number, base e (Euler's number).Common Questions About the IML...
IMLN(complex_value)
See ERFCommon questions about the ERF.PRECISE formula include:-What is the ERF.PRECISE formula?-W...
ERF.PRECISE(lower_bound, [upper_bound])
Calculates the probability of drawing a certain number of failures before a certain number of suc...
NEGBINOMDIST(num_failures, num_successes, prob_success)
See NEGBINOMDISTCommon questions about the NEGBINOM.DIST Formula:1. What is the syntax of the for...
NEGBINOM.DIST(num_failures, num_successes, prob_success)
Returns the most commonly occurring value in a dataset.Common questions about the MODE formula:1....
MODE(value1, [value2, ...])
Returns the logical value `FALSE`.Common questions about the false formula include: What is the f...
FALSE()
Calculates the inverse of the left-tailed chi-squared distribution.Common Questions about the CHI...
CHISQ.INV(probability, degrees_freedom)
Calculates the number of days from the first coupon, or interest payment, until settlement.Common...
COUPDAYBS(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days in the coupon, or interest payment, period that contains the specif...
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 the number of coupons, or interest payments, between the settlement date and the matur...
COUPNUM(settlement, maturity, frequency, [day_count_convention])
Returns a complex number raised to a power.Common questions about the IMPOWER formula:1. What is ...
IMPOWER(complex_base, exponent)
Truncates a number to a certain number of significant digits by omitting less significant digits....
TRUNC(value, [places])
Rounds a number down to the nearest integer that is less than or equal to it.Common questions abo...
INT(value)
See CEILING.PRECISE Common Questions about the ISO.CEILING Formula:1. What is the purpose of the ...
ISO.CEILING(number, [significance])
Returns the least common multiple of one or more integers.Common questions about the LCM formula ...
LCM(value1, value2)
Returns the the logarithm of a number, base e (Euler's number).Common Questions About the LN Form...
LN(value)
Returns the the logarithm of a number given a base.Common Questions1. What is the LOG formula in ...
LOG(value, base)
Returns the the logarithm of a number, base 10.Common Questions about the LOG10 Formula1. What do...
LOG10(value)
Returns the result of the modulo operator, the remainder after a division operation.Common questi...
MOD(dividend, divisor)
Returns the factorial of the sum of values divided by the product of the values' factorials.Commo...
MULTINOMIAL(value1, value2)
Returns a unit matrix of size dimension x dimension.Common questions about the MUNIT formula: • W...
MUNIT(dimension)
See LOGNORMDISTCommon Questions About the LOGNORM.DIST Formula:• What is LOGNORM.DIST and how is ...
LOGNORM.DIST(x, mean, standard_deviation)
Rounds a number up to the nearest odd integer.Common questions about the ODD formula include:What...
ODD(value)
Returns the value of Pi to 14 decimal places.Common questions about the PI formula: 1. What does ...
PI()
Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. ...
GT(value1, value2)

Displaying items 337-384 of 515 in total