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

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.

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

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.

504Formulas

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

The CSCH function returns the hyperbolic cosecant of any real number..
CSCH(value)
Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.
CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.
CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
Converts a provided year, month, and day into a date.
DATE(year, month, day)
Calculates the number of days, months, or years between two dates.
DATEDIF(start_date, end_date, unit)
Converts a provided date string in a known format to a date value.
DATEVALUE(date_string)
Returns the average of a set of values selected from a database table-like array or range using a SQL-like query.
DAVERAGE(database, field, criteria)
Returns the day of the month that a specific date falls on, in numeric format.
DAY(date)
Returns the number of days between two dates..
DAYS(end_date, start_date)
Returns the difference between two days based on the 360 day year used in some financial interest calculations.
DAYS360(start_date, end_date, [method])
Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
DB(cost, salvage, life, period, [month])
Counts numeric values selected from a database table-like array or range using a SQL-like query.
DCOUNT(database, field, criteria)
Counts values, including text, selected from a database table-like array or range using a SQL-like query.
DCOUNTA(database, field, criteria)
Calculates the depreciation of an asset for a specified period using the double-declining balance method.
DDB(cost, salvage, life, period, [factor])
Converts a decimal number to signed binary format.
DEC2BIN(decimal_number, [significant_digits])
Converts a decimal number to signed hexadecimal format.
DEC2HEX(decimal_number, [significant_digits])
Converts a decimal number to signed octal format.
DEC2OCT(decimal_number, [significant_digits])
The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal)..
DECIMAL(value, base)
Converts an angle value in radians to degrees.
DEGREES(angle)
Compare two numeric values, returning 1 if they're equal.
DELTA(number1, [number2])
Identifies the language used in text within the specified range.
DETECTLANGUAGE(text_or_range)
Calculates the sum of squares of deviations based on a sample.
DEVSQ(value1, value2)
Returns a single value from a database table-like array or range using a SQL-like query.
DGET(database, field, criteria)
Calculates the discount rate of a security based on price.
DISC(settlement, maturity, price, redemption, [day_count_convention])
Returns one number divided by another. Equivalent to the `/` operator.
DIVIDE(dividend, divisor)
Returns the maximum value selected from a database table-like array or range using a SQL-like query.
DMAX(database, field, criteria)
Returns the minimum value selected from a database table-like array or range using a SQL-like query.
DMIN(database, field, criteria)
Formats a number into the locale-specific currency format.
DOLLAR(number, [number_of_places])
Converts a price quotation given as a decimal fraction into a decimal value.
DOLLARDE(fractional_price, unit)
Converts a price quotation given as a decimal value into a decimal fraction.
DOLLARFR(decimal_price, unit)
Returns the product of values selected from a database table-like array or range using a SQL-like query.
DPRODUCT(database, field, criteria)
Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.
DSTDEV(database, field, criteria)
Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.
DSTDEVP(database, field, criteria)
Returns the sum of values selected from a database table-like array or range using a SQL-like query.
DSUM(database, field, criteria)
Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value.
DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .
Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.
DVAR(database, field, criteria)
Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.
DVARP(database, field, criteria)
Returns a date a specified number of months before or after another date.
EDATE(start_date, months)
Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.
EFFECT(nominal_rate, periods_per_year)
Encodes a string of text for the purpose of using in a URL query..
ENCODEURL(text)
Returns a date representing the last day of a month which falls a specified number of months before or after another date.
EOMONTH(start_date, months)
Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator.
EQ(value1, value2)
The ERF function returns the integral of the Gauss error function over an interval of values..
ERF(lower_bound, [upper_bound])
Returns the complementary Gauss error function of a value.
ERFC(z)
See ERFC
ERFC.PRECISE(z)
See ERF
ERF.PRECISE(lower_bound, [upper_bound])
Returns a number corresponding to the error value in a different cell.
ERROR.TYPE(reference)
Rounds a number up to the nearest even integer.
EVEN(value)

Displaying items 97-144 of 504 in total