518 Sheety Formulas

Every function from AI() to ZTEST(), with syntax, examples, and video tutorials.

COVARIANCE.P COVARIANCE.S Calculates the covariance of a dataset, where the dataset... CRITBINOM

What do you want a formula to do?

Start here

One formula, one trick

IF makes a cell decide.
VLOOKUP fetches a match.
SUMIF adds only what counts.
COUNTIF tallies the matches.
FILTER hides the rest.

Two formulas, one trick

IF / ISBLANK fills the blanks.
FILTER / UNIQUE no duplicates.
INDEX / MATCH beats VLOOKUP.
UNIQUE / TRANSPOSE headers that move.

Rather watch? 600+ tutorials come with membership.

Formulas people ask about most

VLOOKUP Most Used

Look up a value in one column, return a match from another.

CONCATENATE #ERROR!

The most misspelled formula in Sheets.

Branch spreadsheet logic with true/false conditions.

Show only the rows that match your criteria.

SUMIF Most Used

Sum values that meet one condition.

VLOOKUP #ERROR!

Easy to reach for, hard to maintain later.

VLOOKUP INDEX/MATCH

Runs out of room at the second criterion.

Return a value from any position in a range.

COUNTIF Most Used

Count how often something appears in a range.

ABS Returns the absolute value of a number. ABS(value) ACCRINT Calculates the accrued interest of a security that has periodic payments. ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention]) ACCRINTM Calculates the accrued interest of a security that pays interest at maturity. ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention]) ACOS Returns the inverse cosine of a value, in radians. ACOS(value) ACOSH Returns the inverse hyperbolic cosine of a number. ACOSH(value) ACOT Returns the inverse cotangent of a value, in radians.. ACOT(value) ACOTH Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, in... ACOTH(value) ADD Returns the sum of two numbers. Equivalent to the `+` operator. ADD(value1, value2) ADDRESS Returns a cell reference as a string. ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet]) AI Generates text, summarizes information, categorizes information, and accesses real-time informati... AI(prompt, [range]) AMORLINC 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]) AND Returns true if all of the provided arguments are logically true, and false if any of the provide... AND(logical_expression1, [logical_expression2, ...]) ARABIC Computes the value of a Roman numeral. ARABIC(roman_numeral) ARRAYFORMULA Enables the display of values returned from an array formula into multiple rows and/or columns an... ARRAYFORMULA(array_formula) ARRAY_CONSTRAIN Constrains an array result to a specified size. ARRAY_CONSTRAIN(input_range, num_rows, num_cols) ASC Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-... ASC(text) ASIN Returns the inverse sine of a value, in radians. ASIN(value) ASINH Returns the inverse hyperbolic sine of a number. ASINH(value) ATAN Returns the inverse tangent of a value, in radians. ATAN(value) ATAN2 Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordi... ATAN2(x, y) ATANH Returns the inverse hyperbolic tangent of a number. ATANH(value) AVEDEV Calculates the average of the magnitudes of deviations of data from a dataset's mean. AVEDEV(value1, [value2, ...]) AVERAGE Returns the numerical average value in a dataset, ignoring text. AVERAGE(value1, [value2, ...]) AVERAGE.WEIGHTED Finds the weighted average of a set of values, given the values and the corresponding weights.. AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights]) AVERAGEA Returns the numerical average value in a dataset. AVERAGEA(value1, [value2, ...]) AVERAGEIF Returns the average of a range depending on criteria. AVERAGEIF(criteria_range, criterion, [average_range]) AVERAGEIFS Returns the average of a range depending on multiple criteria. AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) BAHTTEXT Converts a number to Thai text with the suffix Baht for integer values and Satang for decimal val... BAHTTEXT(number) BASE Converts a number into a text representation in another base, for example, base 2 for binary.. BASE(value, base, [min_length]) BETA.DIST Returns the probability of a given value as defined by the beta distribution function.. BETA.DIST(value, alpha, beta, cumulative, lower_bound, upper_bound) BETA.INV Returns the value of the inverse beta distribution function for a given probability.. BETA.INV(probability, alpha, beta, lower_bound, upper_bound) BETADIST See BETA.DIST. BETADIST(value, alpha, beta, lower_bound, upper_bound) BETAINV See BETA.INV BETAINV(probability, alpha, beta, lower_bound, upper_bound) BIN2DEC Converts a signed binary number to decimal format. BIN2DEC(signed_binary_number) BIN2HEX Converts a signed binary number to signed hexadecimal format. BIN2HEX(signed_binary_number, [significant_digits]) BIN2OCT Converts a signed binary number to signed octal format. BIN2OCT(signed_binary_number, [significant_digits]) BINOM.DIST See BINOMDIST BINOM.DIST(num_successes, num_trials, prob_success, cumulative) BINOM.INV See CRITBINOM BINOM.INV(num_trials, prob_success, target_prob) BINOMDIST Calculates the probability of drawing a certain number of successes (or a maximum number of succe... BINOMDIST(num_successes, num_trials, prob_success, cumulative) BITAND Bitwise boolean AND of two numbers.. BITAND(value1, value2) BITLSHIFT Shifts the bits of the input a certain number of places to the left.. BITLSHIFT(value, shift_amount) BITOR Bitwise boolean OR of 2 numbers.. BITOR(value1, value2) BITRSHIFT Shifts the bits of the input a certain number of places to the right.. BITRSHIFT(value, shift_amount) BITXOR Bitwise XOR (exclusive OR) of 2 numbers.. BITXOR(value1, value2) BYCOL Groups an array by columns by application of a LAMBDA function to each column. BYCOL(array_or_range, LAMBDA) BYROW Groups an array by rows by application of a LAMBDA function to each row. BYROW(array_or_range, LAMBDA) CEILING Rounds a number up to the nearest integer multiple of specified significance. CEILING(value, [factor]) CEILING.MATH Rounds a number up to the nearest integer multiple of specified significance, with negative numbe... CEILING.MATH(number, [significance], [mode])