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

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.

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.

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.

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.

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

Calculates next coupon, or interest payment, date after the settlement date.Common Questions Abou...
COUPNCD(settlement, maturity, frequency, [day_count_convention])
Returns the difference between two days based on the 360 day year used in some financial interest...
DAYS360(start_date, end_date, [method])
Calculates the effective interest rate generated when an investment is purchased at one price and...
Returns the standard deviation of a population sample selected from a database table-like array o...
DSTDEV(database, field, criteria)
Returns the interest rate needed for an investment to reach a specific value within a given numbe...
RRI(number_of_periods, present_value, future_value)
Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, b...
YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])
Replaces part of a text string, based on a number of bytes, with a different text string.Common Q...
REPLACEB(text, position, num_bytes, new_text)
Returns string arguments as text.Common questions about the T formula include: What is the purpos...
T(value)
Extracts matching substrings according to a regular expression.Common questions about the REGEXEX...
REGEXEXTRACT(text, regular_expression)
Returns a section of a string starting at a given character and up to a specified number of bytes...
MIDB(string)
Returns the left portion of a string up to a certain number of bytes.Common questions about the L...
LEFTB(string, num_of_bytes)
Returns whether a value is a date.Common questions about the ISDATE formula:• What does ISDATE do...
ISDATE(value)
Checks whether a value is an error.Common questions about the ISERROR formula in Google Sheets:Wh...
ISERROR(value)
Returns a substring from the beginning of a specified string.Common Questions about the LEFT() fo...
LEFT(string, [number_of_characters])
Calculates the depreciation of an asset for one period using the straight-line method.Common ques...
SLN(cost, salvage, life)
Calculates the depreciation of an asset for a specified period using the sum of years digits meth...
SYD(cost, salvage, life, period)
Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate....
TBILLEQ(settlement, maturity, discount)
Returns the inverse sine of a value, in radians.Common questions about the ASIN formula include:1...
ASIN(value)
Returns the formula as a string.What are the common questions about the FORMULATEXT formula?The c...
FORMULATEXT(cell)
Converts a signed octal number to signed hexadecimal format.Common Questions about the OCT2HEX fo...
OCT2HEX(signed_octal_number, [significant_digits])
Formats a number with a fixed number of decimal places.Common questions about the FIXED formula i...
FIXED(number, [number_of_places], [suppress_separator])
Calculates the yield of a US Treasury Bill based on price.Common questions about the TBILLYIELD F...
TBILLYIELD(settlement, maturity, price)
Calculates the gamma distribution, a two-parameter continuous probability distribution.Common que...
GAMMA.DIST(x, alpha, beta, cumulative)
Checks whether a value is `TRUE` or `FALSE`.Common Questions about the ISLOGICAL Formula:1. What ...
ISLOGICAL(value)
Checks whether a value is a number.Common Questions about the ISNUMBER Formula:• What is the synt...
ISNUMBER(value)
Returns the "value not available" error, `#N/A`.Common questions about the NA formula in Google S...
NA()
Rounds a number up to the nearest integer multiple of specified significance. If the number is po...
CEILING.PRECISE(number, [significance])
Returns the inverse hyperbolic tangent of a number.Common questions about the ATANH formula:What ...
ATANH(value)
Rounds a number up to the nearest integer multiple of specified significance.Common questions abo...
CEILING(value, [factor])
Computes the square root of a complex number.Common questions about the IMSQRT formula include:Wh...
IMSQRT(complex_number)
Converts a signed octal number to decimal format.Common Questions about the OCT2DEC Formula:What ...
OCT2DEC(signed_octal_number)
Returns the tangent of the given complex number.Common questions about the IMTAN formula include:...
IMTAN(number)
Converts a signed octal number to signed binary format.Common questions about the OCT2BIN formula...
OCT2BIN(signed_octal_number, [significant_digits])
Calculates r, the Pearson product-moment correlation coefficient of a dataset.Common questions ab...
CORREL(data_y, data_x)
Returns the result of multiplying a series of complex numbers together.Q: What are the common que...
IMPRODUCT(factor1, [factor2, ...])
Calculates the future value of an annuity investment based on constant-amount periodic payments a...
FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])
Calculates the present value of an annuity investment based on constant-amount periodic payments ...
PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])
Bitwise boolean AND of two numbers..
BITAND(value1, value2)
Returns the average of a set of values selected from a database table-like array or range using a...
DAVERAGE(database, field, criteria)
Returns the year specified by a given date.Common questions about the YEAR formula:What is the sy...
YEAR(date)
Calculates the annual yield of a discount (non-interest-bearing) security, based on price.Common ...
YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])
Returns the real coefficient of a complex number.Common questions about the IMREAL formula includ...
IMREAL(complex_number)
Calculates the annual effective interest rate given the nominal rate and number of compounding pe...
EFFECT(nominal_rate, periods_per_year)
Calculates the frequency distribution of a one-column array into specified classes.Common questio...
FREQUENCY(data, classes)
Groups an array by columns by application of a LAMBDA function to each column.Common questions ab...
BYCOL(array_or_range, LAMBDA)
Converts a signed hexadecimal number to signed binary format.Common questions about the HEX2BIN f...
Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise...
GESTEP(value, [step])
Returns the logarithm of a complex number with base 10.Common Questions about the IMLOG10 Formula...
IMLOG10(value)

Displaying items 97-144 of 515 in total

Better Sheets