| A | B | C | D | E | ||
|---|---|---|---|---|---|---|
1 | 646 | Class | Function | Format | Description | |
2 | 1 | Array | FREQUENCY | FREQUENCY(data, classes) | Calculates the frequency distribution of a one-column array into specified classes. Learn more | |
3 | 1 | Array | TRANSPOSE | TRANSPOSE(array_or_range) | Transposes the rows and columns of an array or range of cells. Learn more | |
4 | 1 | ARRAYFORMULA | ARRAYFORMULA(array_formula) | 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 | ||
5 | 1 | IMAGE | IMAGE(url, mode) | Inserts an image into a cell. Learn more | ||
6 | 1 | IMPORTDATA | IMPORTDATA(url) | Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format. Learn more | ||
7 | 1 | IMPORTRANGE | IMPORTRANGE(spreadsheet_key, range_string) | Imports a range of cells from a specified spreadsheet. Learn more | ||
8 | 1 | Logical | AND | AND(logical_expression1, logical_expression2) | Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. Learn more | |
9 | 1 | Logical | FALSE | FALSE() | Returns the logical value `FALSE`. Learn more | |
10 | 1 | Logical | IF | IF(logical_expression, value_if_true, value_if_false) | Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Learn more | |
11 | 1 | Logical | NOT | NOT(logical_expression) | Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. Learn more | |
12 | 1 | Logical | OR | OR(logical_expression1, [logical_expression2]) | Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. Learn more | |
13 | 1 | Logical | TRUE | TRUE() | Returns the logical value `TRUE`. Learn more | |
14 | 1 | Lookup | HYPERLINK | HYPERLINK(url, link_label) | Creates a hyperlink inside a cell. Learn more | |
15 | 1 | Lookup | LOOKUP | LOOKUP(search_key, search_range|search_result_array, [result_range]) | Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column. Learn more | |
16 | 1 | Math | ABS | ABS(value) | Returns the absolute value of a number. Learn more | |
17 | 1 | Math | ACOS | ACOS(value) | Returns the inverse cosine of a value, in radians. Learn more | |
18 | 1 | Math | ACOSH | ACOSH(value) | Returns the inverse hyperbolic cosine of a number. Learn more | |
19 | 1 | Math | ASIN | ASIN(value) | Returns the inverse sine of a value, in radians. Learn more | |
20 | 1 | Math | ASINH | ASINH(value) | Returns the inverse hyperbolic sine of a number. Learn more | |
21 | 1 | Math | ATAN | ATAN(value) | Returns the inverse tangent of a value, in radians. Learn more | |
22 | 1 | Math | ATANH | ATANH(value) | Returns the inverse hyperbolic tangent of a number. Learn more | |
23 | 1 | Math | COS | COS(angle) | Returns the cosine of an angle provided in radians. Learn more | |
24 | 1 | Math | COSH | COSH(value) | Returns the hyperbolic cosine of any real number. Learn more | |
25 | 1 | Math | COUNTBLANK | COUNTBLANK(range) | Returns the number of empty cells in a given range. Learn more | |
26 | 1 | Math | COUNTIF | COUNTIF(range, criterion) | Returns a conditional count across a range. Learn more | |
27 | 1 | Math | COUNTIFS | COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...]) | Returns the count of a range depending on multiple criteria. Learn more | |
28 | 1 | Math | COUNTUNIQUE | COUNTUNIQUE(value1, value2) | Counts the number of unique values in a list of specified values and ranges. Learn more | |
29 | 1 | Math | DEGREES | DEGREES(angle) | Converts an angle value in radians to degrees. Learn more | |
30 | 1 | Math | EXP | EXP(exponent) | Returns Euler's number, e (~2.718) raised to a power. Learn more | |
31 | 1 | Math | FACT | FACT(value) | Returns the factorial of a number. Learn more | |
32 | 1 | Math | INT | INT(value) | Rounds a number down to the nearest integer that is less than or equal to it. Learn more | |
33 | 1 | Math | LOG | LOG(value, base) | Returns the the logarithm of a number given a base. Learn more | |
34 | 1 | Math | LOG10 | LOG10(value) | Returns the the logarithm of a number, base 10. Learn more | |
35 | 1 | Math | PI | PI() | Returns the value of Pi to 14 decimal places. Learn more | |
36 | 1 | Math | POWER | POWER(base, exponent) | Returns a number raised to a power. Learn more | |
37 | 1 | Math | PRODUCT | PRODUCT(factor1, factor2) | Returns the result of multiplying a series of numbers together. Learn more | |
38 | 1 | Math | QUOTIENT | QUOTIENT(dividend, divisor) | Returns one number divided by another. Learn more | |
39 | 1 | Math | RADIANS | RADIANS(angle) | Converts an angle value in degrees to radians. Learn more | |
40 | 1 | Math | RAND | RAND() | Returns a random number between 0 inclusive and 1 exclusive. Learn more | |
41 | 1 | Math | RANDBETWEEN | RANDBETWEEN(low, high) | Returns a uniformly random integer between two values, inclusive. Learn more | |
42 | 1 | Math | ROUND | ROUND(value, places) | Rounds a number to a certain number of decimal places according to standard rules. Learn more | |
43 | 1 | Math | SIN | SIN(angle) | Returns the sine of an angle provided in radians. Learn more | |
44 | 1 | Math | SINH | SINH(value) | Returns the hyperbolic sine of any real number. Learn more | |
45 | 1 | Math | SQRT | SQRT(value) | Returns the positive square root of a positive number. Learn more | |
46 | 1 | Math | SUBTOTAL | SUBTOTAL(function_code, range1, range2) | Returns a subtotal for a vertical range of cells using a specified aggregation function. Learn more | |
47 | 1 | Math | SUM | SUM(value1, value2) | Returns the sum of a series of numbers and/or cells. Learn more | |
48 | 1 | Math | SUMIF | SUMIF(range, criterion, sum_range) | Returns a conditional sum across a range. Learn more | |
49 | 1 | Math | SUMIFS | SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) | Returns the sum of a range depending on multiple criteria. Learn more | |
50 | 1 | Math | TAN | TAN(angle) | Returns the tangent of an angle provided in radians. Learn more | |
51 | 1 | Math | TANH | TANH(value) | Returns the hyperbolic tangent of any real number. Learn more | |
52 | 1 | Operator | ADD | ADD(value1, value2) | Returns the sum of two numbers. Equivalent to the `+` operator. Learn more | |
53 | 1 | Operator | CONCAT | CONCAT(value1, value2) | Returns the concatenation of two values. Equivalent to the `&` operator. Learn more | |
54 | 1 | Operator | DIVIDE | DIVIDE(dividend, divisor) | Returns one number divided by another. Equivalent to the `/` operator. Learn more | |
55 | 1 | Operator | EQ | EQ(value1, value2) | Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator. Learn more | |
56 | 1 | Operator | MINUS | MINUS(value1, value2) | Returns the difference of two numbers. Equivalent to the `-` operator. Learn more | |
57 | 1 | Operator | MULTIPLY | MULTIPLY(factor1, factor2) | Returns the product of two numbers. Equivalent to the `*` operator. Learn more | |
58 | 1 | Operator | POW | POW(base, exponent) | Returns a number raised to a power. Learn more | |
59 | 1 | Statistical | COUNT | COUNT(value1, value2) | Returns the a count of the number of numeric values in a dataset. Learn more | |
60 | 1 | Statistical | COUNTA | COUNTA(value1, value2) | Returns the a count of the number of values in a dataset. Learn more | |
61 | 1 | Statistical | MAX | MAX(value1, [value2]) | Returns the maximum value in a numeric dataset. Learn more | |
62 | 1 | Statistical | MEDIAN | MEDIAN(value1, value2) | Returns the median value in a numeric dataset. Learn more | |
63 | 1 | Statistical | MIN | MIN(value1, [value2]) | Returns the minimum value in a numeric dataset. Learn more | |
64 | 1 | Statistical | MODE | MODE(value1, [value2]) | Returns the most commonly occurring value in a dataset. Learn more | |
65 | 1 | Statistical | PEARSON | PEARSON(data_y, data_x) | Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more | |
66 | 1 | Statistical | PERCENTILE | PERCENTILE(data, percentile) | Returns the value at a given percentile of a dataset. Learn more | |
67 | 1 | Statistical | PERCENTRANK | PERCENTRANK(data, value, [significant_digits]) | Returns the percentage rank (percentile) of a specified value in a dataset. Learn more | |
68 | 1 | Statistical | STDEV | STDEV(value1, value2) | Calculates the standard deviation based on a sample. Learn more | |
69 | 1 | Statistical | TTEST | TTEST(range1, range2, tails, type) | Returns the probability associated with t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean. Learn more | |
70 | 1 | Text | CONCATENATE | CONCATENATE(string1, string2) | Appends strings to one another. Learn more |