# 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. |

CELL | The text string indicating information about a cell. |

CHAR | The 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.DIST | The probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed). |

CHISQ.DIST.RT | The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |

CHISQ.INV | The inverse of the probability distribution function for a chi-squared distribution (left tailed). |

CHISQ.INV.RT | The inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |

CHISQ.TEST | The probability value from a chi-squared distribution. |

CHITEST | (CHISQ.TEST) The probability value from a chi-squared distribution. |

CHOOSE | The 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. |

CLEAN | The text string with all the non-printable characters removed. |

CODE | The ANSI/ASCII number for the first character in a text string. |

COLUMN | The column number of a cell reference. |

COLUMNS | The number of columns in a cell range or reference. |

COMBIN | The 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). |

COMPLEX | The 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.NORM | The confidence interval for a population mean. |

CONFIDENCE.T | The confidence interval for a population mean using a t distribution. |

CONVERT | The number in one measurement system converted to another. |

CORREL | The correlation coefficient between two data sets. |

COS | The cosine of a number. |

COSH | The hyperbolic cosine of a number. |

COT | (2013) The cotangent of a number. |

COTH | (2013) The hyperbolic cotangent of a number. |

COUNT | The number of values in a list, range or array. |

COUNTA | The number of values in a list, range or array (including logical values and text). |

COUNTBLANK | The number of blank cells in a list, table or range. |

COUNTIF | (COUNTIFS) The number of numerical values in a range that satisfies one condition. |

COUNTIFS | The number of numerical values in a range that satisfies multiple conditions. |

COUPDAYBS | The number of days between the previous coupon date and the settlement date. |

COUPDAYS | The number of days between the coupon dates on either side of the settlement date. |

COUPDAYSNC | The number of days between the settlement date and the next coupon date. |

COUPNCD | The next coupon date after the settlement date. |

COUPNUM | The number of coupons between the settlement date and the maturity date. |

COUPPCD | The previous coupon date before the settlement date. |

COVAR | (COVARIANCE.P) The average of the products of deviations for each data point pair. |

COVARIANCE.P | The covariance based on an entire population. |

COVARIANCE.S | The 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. |

CUBEKPIMEMBER | The name of a key performance indicator. |

CUBEMEMBER | The member or tuple from a cube. |

CUBESET | The calculated members returned from a cube. |

CUBESETCOUNT | The number of items in a set. |

CUBEVALUE | The aggregated value from a cube. |

CUMIPMT | The cumulative interest paid on a loan between two dates. |

CUMPRINC | The cumulative principal paid on a loan between two dates. |

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 values in a list, range or array. |

COUNTAThe number of values in a list, range or array (including logical values and text). |

COUNTBLANKThe number of blank cells in a list, table or range. |

COUNTIF(COUNTIFS) The number of numerical values in a range that satisfies one condition. |

COUNTIFSThe number of numerical values in a 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 average of the products of deviations for each data point pair. |

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 paid on a loan between two dates. |

CUMPRINCThe cumulative principal paid on a loan between two dates. |

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top