| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Which Program are they in? | All the functions in these three programs | |||||||||||||||||||||||
2 | Select Function 👉 | FLATTEN | |||||||||||||||||||||||
3 | In Canva | In Sheets | In Excel | ||||||||||||||||||||||
4 | ❌ | ✅ | ❌ | Canva Function | Canva Description | Google Sheets Functions | Google Description | Excel Functions | Type and description | Full List | In Canva but not the others | In Sheets but not Excel | In Excel but not Sheets | ||||||||||||
5 | ABS | Absolute value. Removes minus signs from negative numbers. | ABS | Returns the absolute value of a number. Learn more | ABS | Math and trigonometry: Returns the absolute value of a number | ABS | none | ADD | AGGREGATE | |||||||||||||||
6 | AND | Returns TRUE if all arguments are TRUE. | ACCRINT | Calculates the accrued interest of a security that has periodic payments. Learn more | ACCRINT | Financial: Returns the accrued interest for a security that pays periodic interest | ACCRINT | ARRAY_CONSTRAIN | AMORDEGRC | ||||||||||||||||
7 | AVERAGE | Finds the average of a set of numbers. | ACCRINTM | Calculates the accrued interest of a security that pays interest at maturity. Learn more | ACCRINTM | Financial: Returns the accrued interest for a security that pays interest at maturity | ACCRINTM | ARRAYFORMULA | AREAS | ||||||||||||||||
8 | AVERAGE | Finds the average of a set of numbers. | ACOS | Returns the inverse cosine of a value, in radians. Learn more | ACOS | Math and trigonometry: Returns the arccosine of a number | ACOS | AVERAGE.WEIGHTED | ARRAYTOTEXT | ||||||||||||||||
9 | AVERAGEIF | Calculates the average of cells that meet a specified condition. | ACOSH | Returns the inverse hyperbolic cosine of a number. Learn more | ACOSH | Math and trigonometry: Returns the inverse hyperbolic cosine of a number | ACOSH | BETA.INV | BAHTTEXT | ||||||||||||||||
10 | AVERAGEIFS | Calculates the average of cells that meet multiple specified conditions. | ACOT | Returns the inverse cotangent of a value, in radians. Learn more. | ACOT | Math and trigonometry: Returns the arccotangent of a number | ACOT | DIVIDE | BESSELI | ||||||||||||||||
11 | CONCAT | Combines text from different cells. | ACOTH | Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive. Learn more. | ACOTH | Math and trigonometry: Returns the hyperbolic arccotangent of a number | ACOTH | EPOCHTODATE | BESSELJ | ||||||||||||||||
12 | CORREL | Calculates the correlation coefficient of two ranges. | ADD | Returns the sum of two numbers. Equivalent to the `+` operator. Learn more | ADDRESS | Lookup and reference: Returns a reference as text to a single cell in a worksheet | ADD | EQ | BESSELK | ||||||||||||||||
13 | COUNT | Counts the cells with numbers. | ADDRESS | Returns a cell reference as a string. Learn more | AGGREGATE | Math and trigonometry: Returns an aggregate in a list or database | ADDRESS | FIND | BESSELY | ||||||||||||||||
14 | COUNT | Counts the cells with numbers. | AMORLINC | Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period. Learn more. | AMORDEGRC | Financial: Returns the depreciation for each accounting period by using a depreciation coefficient | AMORLINC | FINDB | BETA.INVn | ||||||||||||||||
15 | COUNTA | Counts the cells with any data. | AND | Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. Learn more | AMORLINC | Financial: Returns the depreciation for each accounting period | AND | FLATTEN | BINOM.DIST.RANGE | ||||||||||||||||
16 | COUNTBLANK | Counts the number of empty cells in a specified range. | ARABIC | Computes the value of a Roman numeral. Learn more | AND | Logical: Returns TRUE if all of its arguments are TRUE | ARABIC | GOOGLEFINANCE | CALL | ||||||||||||||||
17 | COUNTIF | Counts the number of cells that meet a specified condition. | ARRAY_CONSTRAIN | Constrains an array result to a specified size. Learn more | ARABIC | Math and trigonometry: Converts a Roman number to Arabic, as a number | ARRAY_CONSTRAIN | GOOGLETRANSLATE | CUBEKPIMEMBER | ||||||||||||||||
18 | COUNTIFS | Counts the number of cells that meet multiple specified conditions. | ARRAYFORMULA | Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays. Learn more | AREAS | Lookup and reference: Returns the number of areas in a reference | ARRAYFORMULA | GT | CUBEMEMBER | ||||||||||||||||
19 | COUNTUNIQUE | Counts the number of unique values in a specified range. | ASC | Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged. Learn more. | ARRAYTOTEXT | Text: Returns an array of text values from any specified range | ASC | GTE | CUBEMEMBERPROPERTY | ||||||||||||||||
20 | DATE | Converts a year, month, and day into a date. | ASIN | Returns the inverse sine of a value, in radians. Learn more | ASC | Text: Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters | ASIN | IMCOTH | CUBERANKEDMEMBER | ||||||||||||||||
21 | DAY | Gives the day of a date. | ASINH | Returns the inverse hyperbolic sine of a number. Learn more | ASIN | Math and trigonometry: Returns the arcsine of a number | ASINH | IMLOG | CUBESET | ||||||||||||||||
22 | DAYS | Gives the number of days between two dates. | ATAN | Returns the inverse tangent of a value, in radians. Learn more | ASINH | Math and trigonometry: Returns the inverse hyperbolic sine of a number | ATAN | IMPORTDATA | CUBESETCOUNT | ||||||||||||||||
23 | EXP | Returns e raised to the power of a number. | ATAN2 | Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians. Learn more | ATAN | Math and trigonometry: Returns the arctangent of a number | ATAN2 | IMPORTFEED | CUBEVALUE | ||||||||||||||||
24 | FV | Finds the future value of an investment or loan | ATANH | Returns the inverse hyperbolic tangent of a number. Learn more | ATAN2 | Math and trigonometry: Returns the arctangent from x- and y-coordinates | ATANH | IMPORTHTML | DBCS | ||||||||||||||||
25 | HLOOKUP | Horizontal lookup. Searches a table and returns values from a specified row. | AVEDEV | Calculates the average of the magnitudes of deviations of data from a dataset's mean. Learn more | ATANH | Math and trigonometry: Returns the inverse hyperbolic tangent of a number | AVEDEV | IMPORTRANGE | DROP | ||||||||||||||||
26 | IF | Checks whether a criteria is met. Gives one value if true and another if false. | AVERAGE | Returns the numerical average value in a dataset, ignoring text. Learn more | AVEDEV | Statistical: Returns the average of the absolute deviations of data points from their mean | AVERAGE | IMPORTXML | EUROCONVERT | ||||||||||||||||
27 | IFERROR | Checks formulas for errors. Can replace errors with a custom value. | AVERAGE.WEIGHTED | Finds the weighted average of a set of values, given the values and the corresponding weights. Learn more. | AVERAGE | Statistical: Returns the average of its arguments | AVERAGE.WEIGHTED | IMTANH | EXPAND | ||||||||||||||||
28 | IFS | Checks multiple criteria. Gives value based on the first true criteria. | AVERAGEA | Returns the numerical average value in a dataset. Learn more | AVERAGEA | Statistical: Returns the average of its arguments, including numbers, text, and logical values | AVERAGEA | ISBETWEEN | FILTERXML | ||||||||||||||||
29 | INDEX | Gives the content of a cell, based on the row and column provided. | AVERAGEIF | Returns the average of a range depending on criteria. Learn more | AVERAGEIF | Statistical: Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria | AVERAGEIF | ISDATE | FIND, FINDB | ||||||||||||||||
30 | ISBLANK | Check if the value is empty. | AVERAGEIFS | Returns the average of a range depending on multiple criteria. Learn more | AVERAGEIFS | Statistical: Returns the average (arithmetic mean) of all cells that meet multiple criteria. | AVERAGEIFS | ISEMAIL | FORECAST.ETS | ||||||||||||||||
31 | ISERROR | Determines if there’s an error. | BASE | Converts a number into a text representation in another base, for example, base 2 for binary. Learn more. | BAHTTEXT | Text: Converts a number to text, using the ß (baht) currency format | BASE | ISURL | FORECAST.ETS.CONFINT | ||||||||||||||||
32 | LEFT | Returns the first characters. | BETA.DIST | Returns the probability of a given value as defined by the beta distribution function. Learn more. | BASE | Math and trigonometry: Converts a number into a text representation with the given radix (base) | BETA.DIST | JOIN | FORECAST.ETS.SEASONALITY | ||||||||||||||||
33 | LEN | Returns the number of characters. | BETA.INV | Returns the value of the inverse beta distribution function for a given probability. Learn more. | BESSELI | Engineering: Returns the modified Bessel function In(x) | BETA.INV | LEFTB | FORECAST.ETS.STAT | ||||||||||||||||
34 | LN | Calculates the natural logarithm of a number. | BETADIST | See BETA.DIST. | BESSELJ | Engineering: Returns the Bessel function Jn(x) | BETADIST | LENB | GROUPBY | ||||||||||||||||
35 | LOG | Calculates the logarithm of a number to the specified base. | BETAINV | See BETA.INV | BESSELK | Engineering: Returns the modified Bessel function Kn(x) | BETAINV | LT | INFO | ||||||||||||||||
36 | LOG10 | Calculates the base-10 logarithm of a number. | BIN2DEC | Converts a signed binary number to decimal format. Learn more | BESSELY | Engineering: Returns the Bessel function Yn(x) | BIN2DEC | LTE | ISOMITTED | ||||||||||||||||
37 | LOWER | Converts all uppercase letters to lowercase. | BIN2HEX | Converts a signed binary number to signed hexadecimal format. Learn more | BETA.DIST | Statistical: Returns the beta cumulative distribution function | BIN2HEX | MARGINOFERROR | JIS | ||||||||||||||||
38 | MATCH | Gives the relative position of an item in a range that matches a specified value. | BIN2OCT | Converts a signed binary number to signed octal format. Learn more | BETA.INVn | Statistical: Returns the inverse of the cumulative distribution function for a specified beta distribution | BIN2OCT | MID | LEFT, LEFTB | ||||||||||||||||
39 | MAX | Finds the largest value. | BINOM.DIST | See BINOMDIST | BETADIST | Compatibility: Returns the beta cumulative distribution function | BINOM.DIST | MIDB | LEN, LENB | ||||||||||||||||
40 | MAX | Finds the largest value. | BINOM.INV | See CRITBINOM | BETAINV | Compatibility: Returns the inverse of the cumulative distribution function for a specified beta distribution | BINOM.INV | MINUS | MID, MIDB | ||||||||||||||||
41 | MEDIAN | Finds the number in the middle of a set of numbers. | BINOMDIST | Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws. Learn more | BIN2DEC | Engineering: Converts a binary number to decimal | BINOMDIST | MULTIPLY | NUMBERVALUE | ||||||||||||||||
42 | MIN | Finds the smallest value. | BITAND | Bitwise boolean AND of two numbers. Learn more. | BIN2HEX | Engineering: Converts a binary number to hexadecimal | BITAND | NE | ODDFPRICE | ||||||||||||||||
43 | MIN | Finds the smallest value. | BITLSHIFT | Shifts the bits of the input a certain number of places to the left. Learn more. | BIN2OCT | Engineering: Converts a binary number to octal | BITLSHIFT | POW | ODDFYIELD | ||||||||||||||||
44 | MODE | Finds the most frequently occurring value in a range of numbers. | BITOR | Bitwise boolean OR of 2 numbers. Learn more. | BINOM.DIST | Statistical: Returns the individual term binomial distribution probability | BITOR | QUERY | ODDLPRICE | ||||||||||||||||
45 | MONTH | Gives the month of a date. | BITRSHIFT | Shifts the bits of the input a certain number of places to the right. Learn more. | BINOM.DIST.RANGE | Statistical: Returns the probability of a trial result using a binomial distribution | BITRSHIFT | REGEXMATCH | ODDLYIELD | ||||||||||||||||
46 | NOT | Reverses the logic of its argument. | BITXOR | Bitwise XOR (exclusive OR) of 2 numbers. Learn more. | BINOM.INV | Statistical: Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value | BITXOR | REPLACE | PERCENTOF | ||||||||||||||||
47 | NPER | Finds the periods needed to pay off a loan or reach a goal | BYCOL | Groups an array by columns by application of a LAMBDA function to each column. Learn more | BINOMDIST | Compatibility: Returns the individual term binomial distribution probability | BYCOL | REPLACEB | PHONETIC | ||||||||||||||||
48 | OR | Returns TRUE if any argument is TRUE. | BYROW | Groups an array by rows by application of a LAMBDA function to each row. Learn more | BITAND | Engineering: Returns a 'Bitwise And' of two numbers | BYROW | RIGHTB | PIVOTBY | ||||||||||||||||
49 | PI | Returns the value of the mathematical constant π (pi). | CEILING | Rounds a number up to the nearest integer multiple of specified significance. Learn more | BITLSHIFT | Engineering: Returns a value number shifted left by shift_amount bits | CEILING | SEARCH | REGEXTEST | ||||||||||||||||
50 | PMT | Finds monthly payments based on interest rate, number of payments, and loan amount | CEILING.MATH | Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more. | BITOR | Engineering: Returns a bitwise OR of 2 numbers | CEILING.MATH | SEARCHB | REGISTER.ID | ||||||||||||||||
51 | POWER | Raises a number to a power. | CEILING.PRECISE | Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up. Learn more. | BITRSHIFT | Engineering: Returns a value number shifted right by shift_amount bits | CEILING.PRECISE | SORTN | REPLACE, REPLACEB | ||||||||||||||||
52 | PRODUCT | Multiplies the numbers in the selected cells. | CELL | Returns the requested information about the specified cell. Learn more | BITXOR | Engineering: Returns a bitwise 'Exclusive Or' of two numbers | CELL | SPARKLINE | RIGHT, RIGHTB | ||||||||||||||||
53 | PV | Finds the present value of an investment or loan | CHAR | Convert a number into a character according to the current Unicode table. Learn more | BYCOL | Logical: Applies a LAMBDA to each column and returns an array of the results | CHAR | SPLIT | RTD | ||||||||||||||||
54 | RATE | Calculates the interest rate per period | CHIDIST | Calculates the right-tailed chi-squared distribution, often used in hypothesis testing. Learn more | BYROW | Logical: Applies a LAMBDA to each row and returns an array of the results | CHIDIST | TO_DATE | SEARCH, SEARCHB | ||||||||||||||||
55 | RIGHT | Returns the last characters. | CHIINV | Calculates the inverse of the right-tailed chi-squared distribution. Learn more | CALL | Add-in and Automation: Calls a procedure in a dynamic link library or code resource | CHIINV | TO_DOLLARS | SHEET | ||||||||||||||||
56 | ROUND | Rounds the number to the specified number of decimal places. | CHISQ.DIST | Calculates the left-tailed chi-squared distribution, often used in hypothesis testing. Learn more | CEILING | Compatibility: Rounds a number to the nearest integer or to the nearest multiple of significance | CHISQ.DIST | TO_PERCENT | SHEETS | ||||||||||||||||
57 | ROUNDDOWN | Rounds a number down, towards zero. | CHISQ.DIST.RT | Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing. Learn more | CEILING.MATH | Math and trigonometry: Rounds a number up, to the nearest integer or to the nearest multiple of significance | CHISQ.DIST.RT | TO_PURE_NUMBER | SORTBY | ||||||||||||||||
58 | ROUNDUP | Rounds a number up, away from zero. | CHISQ.INV | Calculates the inverse of the left-tailed chi-squared distribution. Learn more | CEILING.PRECISE | Math and trigonometry: Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. | CHISQ.INV | TO_TEXT | STOCKHISTORY | ||||||||||||||||
59 | SQRT | Gives the positive square root. | CHISQ.INV.RT | Calculates the inverse of the right-tailed chi-squared distribution. Learn more | CELL | Information: Returns information about the formatting, location, or contents of a cell This function is not available in Excel for the web. | CHISQ.INV.RT | UMINUS | STOCKHISTORY | ||||||||||||||||
60 | STDEV | Estimates standard deviation based on a sample. | CHISQ.TEST | See CHITEST | CHAR | Text: Returns the character specified by the code number | CHISQ.TEST | UNARY_PERCENT | TAKE | ||||||||||||||||
61 | SUM | Adds selected numbers. | CHITEST | Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution. Learn more | CHIDIST | Compatibility: Returns the one-tailed probability of the chi-squared distribution | CHITEST | UPLUS | TEXTAFTER | ||||||||||||||||
62 | Excel Full List | Google Sheets Full List | SUM | Adds selected numbers. | CHOOSE | Returns an element from a list of choices based on index. Learn more | CHIINV | Compatibility: Returns the inverse of the one-tailed probability of the chi-squared distribution | CHOOSE | TEXTBEFORE | |||||||||||||||
63 | I scraped Canva's page for theirs; I couldn't find a list in their documentation yet. | SUMIF | Adds the values in a range that meet a specified condition. | CHOOSECOLS | Creates a new array from the selected columns in the existing range. Learn more | CHISQ.DIST | Statistical: Returns the cumulative beta probability density function | CHOOSECOLS | TEXTSPLIT | ||||||||||||||||
64 | SUMIFS | Adds the values in a range that meet multiple specified conditions. | CHOOSEROWS | Creates a new array from the selected rows in the existing range. Learn more | CHISQ.DIST.RT | Statistical: Returns the one-tailed probability of the chi-squared distribution | CHOOSEROWS | TRANSLATE | |||||||||||||||||
65 | SUMPRODUCT | Adds the products of two equally sized ranges. | CLEAN | Returns the text with the non-printable ASCII characters removed. Learn more | CHISQ.INV | Statistical: Returns the cumulative beta probability density function | CLEAN | TRIMRANGE | |||||||||||||||||
66 | UPPER | Converts all lowercase letters to uppercase. | CODE | Returns the numeric Unicode map value of the first character in the string provided. Learn more | CHISQ.INV.RT | Statistical: Returns the inverse of the one-tailed probability of the chi-squared distribution | CODE | VALUETOTEXT | |||||||||||||||||
67 | VALUE | Converts text to numbers. | COLUMN | Returns the column number of a specified cell, with `A=1`. Learn more | CHISQ.TEST | Statistical: Returns the test for independence | COLUMN | WEBSERVICE | |||||||||||||||||
68 | VAR | Estimates variance based on a sample. | COLUMNS | Returns the number of columns in a specified array or range. Learn more | CHITEST | Compatibility: Returns the test for independence | COLUMNS | XMATCH | |||||||||||||||||
69 | VLOOKUP | Vertical lookup. Searches a table and returns values from a specified column. | COMBIN | Returns the number of ways to choose some number of objects from a pool of a given size of objects. Learn more | CHOOSE | Lookup and reference: Chooses a value from a list of values | COMBIN | ||||||||||||||||||
70 | XLOOKUP | Searches a table and returns matching values. If no match exists, it can return the closest match. | COMBINA | Returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways that choose the same object multiple times. Learn more. | CHOOSECOLS | Lookup and reference: Returns the specified columns from an array | COMBINA | ||||||||||||||||||
71 | YEAR | Gives the year of a date. | COMPLEX | Creates a complex number given real and imaginary coefficients. Learn more | CHOOSEROWS | Lookup and reference: Returns the specified rows from an array | COMPLEX | ||||||||||||||||||
72 | CONCAT | Returns the concatenation of two values. Equivalent to the `&` operator. Learn more | CLEAN | Text: Removes all nonprintable characters from text | CONCAT | ||||||||||||||||||||
73 | CONCATENATE | Appends strings to one another. Learn more | CODE | Text: Returns a numeric code for the first character in a text string | CONCATENATE | ||||||||||||||||||||
74 | CONFIDENCE | See CONFIDENCE.NORM | COLUMN | Lookup and reference: Returns the column number of a reference | CONFIDENCE | ||||||||||||||||||||
75 | CONFIDENCE.NORM | Calculates the width of half the confidence interval for a normal distribution. Learn more. | COLUMNS | Lookup and reference: Returns the number of columns in a reference | CONFIDENCE.NORM | ||||||||||||||||||||
76 | CONFIDENCE.T | Calculates the width of half the confidence interval for a Student’s t-distribution. Learn more. | COMBIN | Math and trigonometry: Returns the number of combinations for a given number of objects | CONFIDENCE.T | ||||||||||||||||||||
77 | CONVERT | Converts a numeric value to a different unit of measure. Learn more | COMBINA | Math and trigonometry: Returns the number of combinations with repetitions for a given number of items | CONVERT | ||||||||||||||||||||
78 | CORREL | Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more | COMPLEX | Engineering: Converts real and imaginary coefficients into a complex number | CORREL | ||||||||||||||||||||
79 | COS | Returns the cosine of an angle provided in radians. Learn more | CONCAT | Text: Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. | COS | ||||||||||||||||||||
80 | COSH | Returns the hyperbolic cosine of any real number. Learn more | CONCATENATE | Text: Joins several text items into one text item | COSH | ||||||||||||||||||||
81 | COT | Cotangent of an angle provided in radians. Learn more. | CONFIDENCE | Compatibility: Returns the confidence interval for a population mean | COT | ||||||||||||||||||||
82 | COTH | Returns the hyperbolic cotangent of any real number. Learn more. | CONFIDENCE.NORM | Statistical: Returns the confidence interval for a population mean | COTH | ||||||||||||||||||||
83 | COUNT | Returns a count of the number of numeric values in a dataset. Learn more | CONFIDENCE.T | Statistical: Returns the confidence interval for a population mean, using a Student's t distribution | COUNT | ||||||||||||||||||||
84 | COUNTA | Returns a count of the number of values in a dataset. Learn more | CONVERT | Engineering: Converts a number from one measurement system to another | COUNTA | ||||||||||||||||||||
85 | COUNTBLANK | Returns the number of empty cells in a given range. Learn more | CORREL | Statistical: Returns the correlation coefficient between two data sets | COUNTBLANK | ||||||||||||||||||||
86 | COUNTIF | Returns a conditional count across a range. Learn more | COS | Math and trigonometry: Returns the cosine of a number | COUNTIF | ||||||||||||||||||||
87 | COUNTIFS | Returns the count of a range depending on multiple criteria. Learn more | COSH | Math and trigonometry: Returns the hyperbolic cosine of a number | COUNTIFS | ||||||||||||||||||||
88 | COUNTUNIQUE | Counts the number of unique values in a list of specified values and ranges. Learn more | COT | Math and trigonometry: Returns the hyperbolic cosine of a number | COUNTUNIQUE | ||||||||||||||||||||
89 | COUPDAYBS | Calculates the number of days from the first coupon, or interest payment, until settlement. Learn more | COTH | Math and trigonometry: Returns the cotangent of an angle | COUPDAYBS | ||||||||||||||||||||
90 | COUPDAYS | Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. Learn more | COUNT | Statistical: Counts how many numbers are in the list of arguments | COUPDAYS | ||||||||||||||||||||
91 | COUPDAYSNC | Calculates the number of days from the settlement date until the next coupon, or interest payment. Learn more | COUNTA | Statistical: Counts how many values are in the list of arguments | COUPDAYSNC | ||||||||||||||||||||
92 | COUPNCD | Calculates next coupon, or interest payment, date after the settlement date. Learn more | COUNTBLANK | Statistical: Counts the number of blank cells within a range | COUPNCD | ||||||||||||||||||||
93 | COUPNUM | Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment. Learn more | COUNTIF | Statistical: Counts the number of cells within a range that meet the given criteria | COUPNUM | ||||||||||||||||||||
94 | COUPPCD | Calculates last coupon, or interest payment, date before the settlement date. Learn more | COUNTIFS | Statistical: Counts the number of cells within a range that meet multiple criteria | COUPPCD | ||||||||||||||||||||
95 | COVAR | Calculates the covariance of a dataset. Learn more | COUPDAYBS | Financial: Returns the number of days from the beginning of the coupon period to the settlement date | COVAR | ||||||||||||||||||||
96 | COVARIANCE.P | See COVAR | COUPDAYS | Financial: Returns the number of days in the coupon period that contains the settlement date | COVARIANCE.P | ||||||||||||||||||||
97 | COVARIANCE.S | Calculates the covariance of a dataset, where the dataset is a sample of the total population. Learn more. | COUPDAYSNC | Financial: Returns the number of days from the settlement date to the next coupon date | COVARIANCE.S | ||||||||||||||||||||
98 | CRITBINOM | Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria. Learn more | COUPNCD | Financial: Returns the next coupon date after the settlement date | CRITBINOM | ||||||||||||||||||||
99 | CSC | Returns the cosecant of an angle provided in radians. Learn more. | COUPNUM | Financial: Returns the number of coupons payable between the settlement date and maturity date | CSC | ||||||||||||||||||||
100 | CSCH | The CSCH function returns the hyperbolic cosecant of any real number. Learn more. | COUPPCD | Financial: Returns the previous coupon date before the settlement date | CSCH | ||||||||||||||||||||