Returns the requested information about the specified cell.

CELL(info_type, reference)

Convert a number into a character according to the current Unicode table.

CHAR(table_number)

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

CHIDIST(x, degrees_freedom)

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

CHIINV(probability, degrees_freedom)

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

CHISQ.DIST(x, degrees_freedom, cumulative)

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

CHISQ.DIST.RT(x, degrees_freedom)

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

CHISQ.INV(probability, degrees_freedom)

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

CHISQ.INV.RT(probability, degrees_freedom)

See CHITEST

CHISQ.TEST(observed_range, expected_range)

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

CHITEST(observed_range, expected_range)

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

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

Creates a new array from the selected columns in the existing range.

CHOOSECOLS(array, col_num1, [col_num2, ...])

Creates a new array from the selected rows in the existing range.

CHOOSEROWS(array, row_num1, [row_num2, ...])

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

CLEAN(text)

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

CODE(string)

Returns the column number of a specified cell, with `A=1`.

COLUMN([cell_reference])

Returns the number of columns in a specified array or range.

COLUMNS(range)

Returns the number of ways to choose some number of objects from a pool of a given size of objects.

COMBIN(n, k)

Returns the number of ways to choose some number of objects from a pool of a given size of object...

COMBINA(n, k)

Creates a complex number given real and imaginary coefficients.

COMPLEX(real_part, imaginary_part, [suffix])

Returns the concatenation of two values. Equivalent to the `&` operator.

CONCAT(value1, value2)

Appends strings to one another.

CONCATENATE(string1, [string2, ...])

See CONFIDENCE.NORM

CONFIDENCE(alpha, standard_deviation, pop_size)

Calculates the width of half the confidence interval for a normal distribution..

CONFIDENCE.NORM(alpha, standard_deviation, pop_size)

Calculates the width of half the confidence interval for a Student’s t-distribution..

CONFIDENCE.T(alpha, standard_deviation, size)

Converts a numeric value to a different unit of measure.

CONVERT(value, start_unit, end_unit)

Calculates r, the Pearson product-moment correlation coefficient of a dataset.

CORREL(data_y, data_x)

Returns the cosine of an angle provided in radians.

COS(angle)

Returns the hyperbolic cosine of any real number.

COSH(value)

Cotangent of an angle provided in radians..

COT(angle)

Returns the hyperbolic cotangent of any real number..

COTH(value)

Returns a count of the number of numeric values in a dataset.

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

Returns a count of the number of values in a dataset.

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

Returns the number of empty cells in a given range.

COUNTBLANK(range)

Returns a conditional count across a range.

COUNTIF(range, criterion)

Returns the count of a range depending on multiple criteria.

COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Counts the number of unique values in a list of specified values and ranges.

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

Returns the unique count of a range depending on multiple criteria.

COUNTUNIQUEIFS(count_unique_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Calculates the number of days from the first coupon, or interest payment, until settlement.

COUPDAYBS(settlement, maturity, frequency, [day_count_convention])

Calculates the number of days in the coupon, or interest payment, period that contains the specif...

COUPDAYS(settlement, maturity, frequency, [day_count_convention])

Calculates the number of days from the settlement date until the next coupon, or interest payment.

COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])

Calculates next coupon, or interest payment, date after the settlement date.

COUPNCD(settlement, maturity, frequency, [day_count_convention])

Calculates the number of coupons, or interest payments, between the settlement date and the matur...

COUPNUM(settlement, maturity, frequency, [day_count_convention])

Calculates last coupon, or interest payment, date before the settlement date.

COUPPCD(settlement, maturity, frequency, [day_count_convention])

Calculates the covariance of a dataset.

COVAR(data_y, data_x)

See COVAR

COVARIANCE.P(data_y, data_x)

Calculates the covariance of a dataset, where the dataset is a sample of the total population..

COVARIANCE.S(data_y, data_x)

Calculates the smallest value for which the cumulative binomial distribution is greater than or e...

CRITBINOM(num_trials, prob_success, target_prob)