# Alphabetical - C

 CEILING(CEILING.MATH) The number rounded up to the nearest integer or significant figure. CEILING.MATH(2013) The number rounded up to the nearest integer or significant figure (including negative). CEILING.PRECISE(CEILING.MATH) The number rounded up to the nearest integer or significant figure. CELLThe text string indicating information about a cell. CHARThe character with the corresponding ANSI/ASCII number. CHIDIST(CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). CHIINV(CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed). CHISQ.DISTThe probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed). CHISQ.DIST.RTThe probability distribution function for a chi-squared distribution (right tailed) (no cumulative). CHISQ.INVThe inverse of the probability distribution function for a chi-squared distribution (left tailed). CHISQ.INV.RTThe inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative). CHISQ.TESTThe probability value from a chi-squared distribution. CHITEST(CHISQ.TEST) The probability value from a chi-squared distribution. CHOOSEThe value in a row (or column) based on an index number. CHOOSECOLS(Microsoft 365) The array with just a specific number of columns. CHOOSEROWS(Microsoft 365) The array with just a specifiic number of rows. CLEANThe text string with all the non-printable characters removed. CODEThe ANSI/ASCII number for the first character in a text string. COLUMNThe column number of a cell reference. COLUMNSThe number of columns in a cell range or reference. COMBINThe number of combinations for a given number of items (without repetition). COMBINA(2013) The number of combinations for a given number of items (with repetition). COMPLEXThe complex number given real and imaginary coefficients. CONCAT(2019) The text string that is a concatenation of cell ranges and strings. CONCATENATE(CONCAT) The text string that is a concatenation of several strings. CONFIDENCE(CONFIDENCE.NORM) The confidence interval for a population mean. CONFIDENCE.NORMThe confidence interval for a population mean. CONFIDENCE.TThe confidence interval for a population mean using a t distribution. CONVERTThe number in one measurement system converted to another. CORRELThe correlation coefficient between two data sets. COSThe cosine of a number. COSHThe hyperbolic cosine of a number. COT(2013) The cotangent of a number. COTH(2013) The hyperbolic cotangent of a number. COUNTThe number of numerical values in a list, table or cell range. COUNTAThe number of numerical values in a list, table or cell range (including logical values and text). COUNTBLANKThe number of empty cells. COUNTIF(COUNTIFS) The number of numerical values in a list, table or cell range that satisfies one condition. COUNTIFSThe number of numerical values in a list, table or cell range that satisfies multiple conditions. COUPDAYBSThe number of days between the previous coupon date and the settlement date. COUPDAYSThe number of days between the coupon dates on either side of the settlement date. COUPDAYSNCThe number of days between the settlement date and the next coupon date. COUPNCDThe next coupon date after the settlement date. COUPNUMThe number of coupons between the settlement date and the maturity date. COUPPCDThe previous coupon date before the settlement date. COVAR(COVARIANCE.P) The covariance based on an entire population. COVARIANCE.PThe covariance based on an entire population. COVARIANCE.SThe covariance based on a sample. CRITBINOM(BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed). CSC(2013) The cosecant of a number. CSCH(2013) The hyperbolic cosecant of a number. CUBEKPIMEMBERThe name of a key performance indicator. CUBEMEMBERThe member or tuple from a cube. CUBESETThe calculated members returned from a cube. CUBESETCOUNTThe number of items in a set. CUBEVALUEThe aggregated value from a cube. CUMIPMTThe cumulative interest payment on a loan between two dates. CUMPRINCThe cumulative principal paid on a loan between two dates.

© 2024 Better Solutions Limited