Hey there! Register a new account to access the full suite of features, tutorials, and more..

504Formulas

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

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

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

AMORLINC()

Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period..

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 provided arguments are logically false.

AND(logical_expression1, [logical_expression2, ...])

ARABIC()

Computes the value of a Roman numeral.

ARABIC(roman_numeral)

ARRAY_CONSTRAIN()

Constrains an array result to a specified size.

ARRAY_CONSTRAIN(input_range, num_rows, num_cols)

ARRAYFORMULA()

Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.

ARRAYFORMULA(array_formula)

ASC()

Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged..

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 coordinate pair (`x`,`y`), in radians.

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, ...])

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, ...])

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

BAHTTEXT()

Converts a number to Thai text with the suffix Baht for integer values and Satang for decimal values.

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)

BETADIST()

See BETA.DIST.

BETADIST(value, alpha, beta, 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)

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)

BINOMDIST()

Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.

BINOMDIST(num_successes, num_trials, prob_success, cumulative)

BINOM.DIST.RANGE()

Returns the probability of drawing a specific number of successes or range of successes given a probability and number of tries.

BINOM.DIST.RANGE(num_trials, prob_success, num_successes, max_num_successes)

BINOM.INV()

See CRITBINOM

BINOM.INV(num_trials, prob_success, target_prob)

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 numbers rounding toward or away from 0 depending on the mode..

CEILING.MATH(number, [significance], [mode])

Displaying items 1-48 of 504 in total