Calculates the probability of drawing a certain number of successes in a certain number of tries ...

HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)

See HYPGEOMDIST

HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)

Converts a signed hexadecimal number to signed octal format.

HEX2OCT(signed_hexadecimal_number, significant_digits)

Converts a signed hexadecimal number to decimal format.

HEX2DEC(signed_hexadecimal_number)

Converts a signed hexadecimal number to signed binary format.

HEX2BIN(signed_hexadecimal_number, [significant_digits])

Calculates the harmonic mean of a dataset.

HARMEAN(value1, value2)

Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwis...

GTE(value1, value2)

Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. ...

GT(value1, value2)

Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/...

GROWTH(known_data_y, [known_data_x], [new_data_x], [b])

Extracts an aggregated value from a pivot table that corresponds to the specified row and column ...

GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]

Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise...

GESTEP(value, [step])

Calculates the geometric mean of a dataset.

GEOMEAN(value1, value2)

Returns the greatest common divisor of one or more integers.

GCD(value1, value2)

The GAUSS function returns the probability that a random variable, drawn from a normal distributi...

GAUSS(z)

See GAMMALN

GAMMALN.PRECISE(value)

Returns the the logarithm of a specified Gamma function, base e (Euler's number).

GAMMALN(value)

See GAMMA.INV.

GAMMAINV(probability, alpha, beta)

See GAMMA.DIST

GAMMADIST(x, alpha, beta, cumulative)

The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function fo...

GAMMA.INV(probability, alpha, beta)

Calculates the gamma distribution, a two-parameter continuous probability distribution.

GAMMA.DIST(x, alpha, beta, cumulative)

Returns the Gamma function evaluated at the specified value..

GAMMA(number)

Calculates the future value of some principal based on a specified series of potentially varying ...

FVSCHEDULE(principal, rate_schedule)

Returns the probability associated with an F-test for equality of variances. Determines whether t...

FTEST(range1, range2)

Calculates the frequency distribution of a one-column array into specified classes.

FREQUENCY(data, classes)