Discover 500+
Google Sheet Formulas ...and how to wield'em like a sheet wizard.

Copy-able Examples • Walkthroughs • Hidden Combos

See each formula on it's own

  • IF: Automate logic in your cells.
  • VLOOKUP: Find and match data
  • SUMIF: Add up only what matters
  • FILTER: Find only the data you need

Learn powerful formula combinations

Explore

Discover a new formula randomly!
Be Brave. Give it a go 👇

→ Random Formula

Generate

Write out your problem.
AI writes you a formula.

→ Generate Formula

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

Learn more

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.

Learn more

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.

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

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

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.

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

Depending on what you're trying to do, SUMIF could be your solution or not. Sometimes I find SUMIFS' syntax to be easier to use. Also check out an alternative: COUNTIF.

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

515 Google Sheets Formulas

Directory of every Google Sheets formula.

From ABS to ZTEST. ...and my favorite formula: IF()

RATE()
RATE()
Calculates the interest rate of an annuity investment based on constant-amount periodic payments ... 
RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])
 NPER()
NPER()
Calculates the number of payment periods for an investment based on constant-amount periodic paym... 
NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])
 PDURATION()
PDURATION()
Returns the number of periods for an investment to reach a specific value at a given rate.Common ... 
PDURATION(rate, present_value, future_value)
 PRICE()
PRICE()
Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on... 
PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])
 RECEIVED()
RECEIVED()
Calculates the amount received at maturity for an investment in fixed-income securities purchased... 
RECEIVED(settlement, maturity, investment, discount, [day_count_convention])
 TBILLPRICE()
TBILLPRICE()
Calculates the price of a US Treasury Bill based on discount rate.Common Questions About the TBIL... 
TBILLPRICE(settlement, maturity, discount)
 MAKEARRAY()
MAKEARRAY()
Returns an array of specified dimensions with values calculated by application of a LAMBDA functi... 
MAKEARRAY(rows, columns, LAMBDA)
 MDETERM()
MDETERM()
Returns the matrix determinant of a square matrix specified as an array or range.Common questions... 
MDETERM(square_matrix)
 MMULT()
MMULT()
Calculates the matrix product of two matrices specified as arrays or ranges.Common questions abou... 
MMULT(matrix1, matrix2)
 MINUTE()
MINUTE()
Returns the minute component of a specific time, in numeric format.Common Questions about the MIN... 
MINUTE(time)
 ISBETWEEN()
ISBETWEEN()
Checks whether a provided number is between two other numbers either inclusively or exclusively.C... 
ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)
 LOGEST()
LOGEST()
Given partial data about an exponential growth curve, calculates various parameters about the bes... 
LOGEST(known_data_y, [known_data_x], [b], [verbose])
 SUMPRODUCT()
SUMPRODUCT()
Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.C... 
SUMPRODUCT(array1, [array2, ...])
 SECOND()
SECOND()
Returns the second component of a specific time, in numeric format. 
SECOND(time)
 CONFIDENCE()
CONFIDENCE()
See CONFIDENCE.NORMCommon questions about the CONFIDENCE formula: 1. What is the CONFIDENCE formu... 
CONFIDENCE(alpha, standard_deviation, pop_size)
 PMT()
PMT()
Calculates the periodic payment for an annuity investment based on constant-amount periodic payme... 
PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])
 PPMT()
PPMT()
Calculates the payment on the principal of an investment based on constant-amount periodic paymen... 
PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
 PRICEDISC()
PRICEDISC()
Calculates the price of a discount (non-interest-bearing) security, based on expected yield.Commo... 
PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])
 PRICEMAT()
PRICEMAT()
Calculates the price of a security paying interest at maturity, based on expected yield.Common qu... 
PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])
 SINH()
SINH()
Returns the hyperbolic sine of any real number.Common questions about the SINH Formula include:1.... 
SINH(value)
 HEX2OCT()
HEX2OCT()
Converts a signed hexadecimal number to signed octal format.Common questions about the HEX2OCT fo... 
HEX2OCT(signed_hexadecimal_number, significant_digits)
 BIN2OCT()
BIN2OCT()
Converts a signed binary number to signed octal format.Common questions about the BIN2OCT formula... 
BIN2OCT(signed_binary_number, [significant_digits])
 GESTEP()
GESTEP()
Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise... 
GESTEP(value, [step])
 HEX2BIN()
HEX2BIN()
Converts a signed hexadecimal number to signed binary format.Common questions about the HEX2BIN f... 
HEX2BIN(signed_hexadecimal_number, [significant_digits])
 YIELDDISC()
YIELDDISC()
Calculates the annual yield of a discount (non-interest-bearing) security, based on price.Common ... 
YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])
 BITAND()
BITAND()
Bitwise boolean AND of two numbers.. 
BITAND(value1, value2)
 PV()
PV()
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])
 CORREL()
CORREL()
Calculates r, the Pearson product-moment correlation coefficient of a dataset.Common questions ab... 
CORREL(data_y, data_x)
 OCT2BIN()
OCT2BIN()
Converts a signed octal number to signed binary format.Common questions about the OCT2BIN formula... 
OCT2BIN(signed_octal_number, [significant_digits])
 OCT2DEC()
OCT2DEC()
Converts a signed octal number to decimal format.Common Questions about the OCT2DEC Formula:What ... 
OCT2DEC(signed_octal_number)
 OCT2HEX()
OCT2HEX()
Converts a signed octal number to signed hexadecimal format.Common Questions about the OCT2HEX fo... 
OCT2HEX(signed_octal_number, [significant_digits])
 RRI()
RRI()
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)
 MIDB()
MIDB()
Returns a section of a string starting at a given character and up to a specified number of bytes... 
MIDB(string)
 LEFTB()
LEFTB()
Returns the left portion of a string up to a certain number of bytes.Common questions about the L... 
LEFTB(string, num_of_bytes)
 ISDATE()
ISDATE()
Returns whether a value is a date.Common questions about the ISDATE formula:• What does ISDATE do... 
ISDATE(value)

Displaying items 481-515 of 515 in total

Get Instant Access

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons