Page 2 of 11
CEILING.PRECISE
Rounds a number up to the nearest integer multiple of specified significance. If the number is po...
CEILING.PRECISE(number, [significance])
CELL
Returns the requested information about the specified cell.
CELL(info_type, reference)
CHAR
Convert a number into a character according to the current Unicode table.
CHAR(table_number)
CHIDIST
Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.
CHIDIST(x, degrees_freedom)
CHIINV
Calculates the inverse of the right-tailed chi-squared distribution.
CHIINV(probability, degrees_freedom)
CHISQ.DIST
Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.
CHISQ.DIST(x, degrees_freedom, cumulative)
CHISQ.DIST.RT
Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing.
CHISQ.DIST.RT(x, degrees_freedom)
CHISQ.INV
Calculates the inverse of the left-tailed chi-squared distribution.
CHISQ.INV(probability, degrees_freedom)
CHISQ.INV.RT
Calculates the inverse of the right-tailed chi-squared distribution.
CHISQ.INV.RT(probability, degrees_freedom)
CHISQ.TEST
See CHITEST
CHISQ.TEST(observed_range, expected_range)
CHITEST
Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. D...
CHITEST(observed_range, expected_range)
CHOOSE
Returns an element from a list of choices based on index.
CHOOSE(index, choice1, [choice2, ...])
CHOOSECOLS
Creates a new array from the selected columns in the existing range.
CHOOSECOLS(array, col_num1, [col_num2, ...])
CHOOSEROWS
Creates a new array from the selected rows in the existing range.
CHOOSEROWS(array, row_num1, [row_num2, ...])
CLEAN
Returns the text with the non-printable ASCII characters removed.
CLEAN(text)
CODE
Returns the numeric Unicode map value of the first character in the string provided.
CODE(string)
COLUMN
Returns the column number of a specified cell, with `A=1`.
COLUMN([cell_reference])
COLUMNS
Returns the number of columns in a specified array or range.
COLUMNS(range)
COMBIN
Returns the number of ways to choose some number of objects from a pool of a given size of objects.
COMBIN(n, k)
COMBINA
Returns the number of ways to choose some number of objects from a pool of a given size of object...
COMBINA(n, k)
COMPLEX
Creates a complex number given real and imaginary coefficients.
COMPLEX(real_part, imaginary_part, [suffix])
CONCAT
Returns the concatenation of two values. Equivalent to the `&` operator.
CONCAT(value1, value2)
CONCATENATE
Appends strings to one another.
CONCATENATE(string1, [string2, ...])
CONFIDENCE
See CONFIDENCE.NORM
CONFIDENCE(alpha, standard_deviation, pop_size)
CONFIDENCE.NORM
Calculates the width of half the confidence interval for a normal distribution..
CONFIDENCE.NORM(alpha, standard_deviation, pop_size)
CONFIDENCE.T
Calculates the width of half the confidence interval for a Student’s t-distribution..
CONFIDENCE.T(alpha, standard_deviation, size)
CONVERT
Converts a numeric value to a different unit of measure.
CONVERT(value, start_unit, end_unit)
CORREL
Calculates r, the Pearson product-moment correlation coefficient of a dataset.
CORREL(data_y, data_x)
COS
Returns the cosine of an angle provided in radians.
COS(angle)
COSH
Returns the hyperbolic cosine of any real number.
COSH(value)
COT
Cotangent of an angle provided in radians..
COT(angle)
COTH
Returns the hyperbolic cotangent of any real number..
COTH(value)
COUNT
Returns a count of the number of numeric values in a dataset.
COUNT(value1, [value2, ...])
COUNTA
Returns a count of the number of values in a dataset.
COUNTA(value1, [value2, ...])
COUNTBLANK
Returns the number of empty cells in a given range.
COUNTBLANK(range)
COUNTIF
Returns a conditional count across a range.
COUNTIF(range, criterion)
COUNTIFS
Returns the count of a range depending on multiple criteria.
COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
COUNTUNIQUE
Counts the number of unique values in a list of specified values and ranges.
COUNTUNIQUE(value1, [value2, ...])
COUNTUNIQUEIFS
Returns the unique count of a range depending on multiple criteria.
COUNTUNIQUEIFS(count_unique_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
COUPDAYBS
Calculates the number of days from the first coupon, or interest payment, until settlement.
COUPDAYBS(settlement, maturity, frequency, [day_count_convention])
COUPDAYS
Calculates the number of days in the coupon, or interest payment, period that contains the specif...
COUPDAYS(settlement, maturity, frequency, [day_count_convention])
COUPDAYSNC
Calculates the number of days from the settlement date until the next coupon, or interest payment.
COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])
COUPNCD
Calculates next coupon, or interest payment, date after the settlement date.
COUPNCD(settlement, maturity, frequency, [day_count_convention])
COUPNUM
Calculates the number of coupons, or interest payments, between the settlement date and the matur...
COUPNUM(settlement, maturity, frequency, [day_count_convention])
COUPPCD
Calculates last coupon, or interest payment, date before the settlement date.
COUPPCD(settlement, maturity, frequency, [day_count_convention])
COVAR
Calculates the covariance of a dataset.
COVAR(data_y, data_x)
COVARIANCE.P
See COVAR
COVARIANCE.P(data_y, data_x)
COVARIANCE.S
Calculates the covariance of a dataset, where the dataset is a sample of the total population..
COVARIANCE.S(data_y, data_x)