Returns the value of the inverse beta distribution function for a given probability..

BETA.INV(probability, alpha, beta, lower_bound, upper_bound)

Returns the probability of a given value as defined by the beta distribution function..

BETA.DIST(value, alpha, beta, cumulative, lower_bound, upper_bound)

Converts a number into a text representation in another base, for example, base 2 for binary..

BASE(value, base, [min_length])

Returns the average of a range depending on multiple criteria.

AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Returns the average of a range depending on criteria.

AVERAGEIF(criteria_range, criterion, [average_range])

Returns the numerical average value in a dataset.

AVERAGEA(value1, [value2, ...])

Finds the weighted average of a set of values, given the values and the corresponding weights..

AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])

Calculates the average of the magnitudes of deviations of data from a dataset's mean.

AVEDEV(value1, [value2, ...])

Returns the inverse hyperbolic tangent of a number.

ATANH(value)

Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordi...

ATAN2(x, y)

Returns the inverse tangent of a value, in radians.

ATAN(value)

Returns the inverse hyperbolic sine of a number.

ASINH(value)

Returns the inverse sine of a value, in radians.

ASIN(value)

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

ASC(text)

Constrains an array result to a specified size.

ARRAY_CONSTRAIN(input_range, num_rows, num_cols)

Computes the value of a Roman numeral.

ARABIC(roman_numeral)

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

Returns a cell reference as a string.

ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])

Returns the sum of two numbers. Equivalent to the `+` operator.

ADD(value1, value2)

Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, in...

ACOTH(value)

Returns the inverse cotangent of a value, in radians..

ACOT(value)

Returns the inverse hyperbolic cosine of a number.

ACOSH(value)

Returns the inverse cosine of a value, in radians.

ACOS(value)

Calculates the accrued interest of a security that pays interest at maturity.

ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])

Calculates the accrued interest of a security that has periodic payments.

ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])

Returns the absolute value of a number.

ABS(value)

Returns the numeric Unicode map value of the first character in the string provided.

CODE(string)

Returns the text with the non-printable ASCII characters removed.

CLEAN(text)

Returns an element from a list of choices based on index.

CHOOSE(index, choice1, [choice2, ...])

Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. D...

CHITEST(observed_range, expected_range)

See CHITEST

CHISQ.TEST(observed_range, expected_range)

Calculates the inverse of the right-tailed chi-squared distribution.

CHISQ.INV.RT(probability, degrees_freedom)

Calculates the inverse of the left-tailed chi-squared distribution.

CHISQ.INV(probability, degrees_freedom)

Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing.

CHISQ.DIST.RT(x, degrees_freedom)

Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.

CHISQ.DIST(x, degrees_freedom, cumulative)

Calculates the inverse of the right-tailed chi-squared distribution.

CHIINV(probability, degrees_freedom)

Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.

CHIDIST(x, degrees_freedom)

Returns the requested information about the specified cell.

CELL(info_type, reference)

Rounds a number up to the nearest integer multiple of specified significance. If the number is po...

CEILING.PRECISE(number, [significance])

Rounds a number up to the nearest integer multiple of specified significance, with negative numbe...

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

Rounds a number up to the nearest integer multiple of specified significance.

CEILING(value, [factor])

Groups an array by rows by application of a LAMBDA function to each row.

BYROW(array_or_range, LAMBDA)

Groups an array by columns by application of a LAMBDA function to each column.

BYCOL(array_or_range, LAMBDA)

Bitwise XOR (exclusive OR) of 2 numbers..

BITXOR(value1, value2)

Shifts the bits of the input a certain number of places to the right..

BITRSHIFT(value, shift_amount)

Bitwise boolean OR of 2 numbers..

BITOR(value1, value2)

Shifts the bits of the input a certain number of places to the left..

BITLSHIFT(value, shift_amount)

Bitwise boolean AND of two numbers..

BITAND(value1, value2)