Array | SUMPRODUCT | `SUMPRODUCT(array1, [array2, ...])` | Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more |

Date | TIMESTAMP | `TIMESTAMP()` | Returns timestamp in seconds |

Engineering | BIN2DEC | `BIN2DEC(signed_binary_number)` | Converts a signed binary number to decimal format. Learn more |

Engineering | BIN2HEX | `BIN2HEX(signed_binary_number, [significant_digits])` | Converts a signed binary number to signed hexadecimal format. Learn more |

Engineering | BIN2OCT | `BIN2OCT(signed_binary_number, [significant_digits])` | Converts a signed binary number to signed octal format. Learn more |

Engineering | DEC2BIN | `DEC2BIN(decimal_number, [significant_digits])` | Converts a decimal number to signed binary format. Learn more |

Engineering | DEC2HEX | `DEC2HEX(decimal_number, [significant_digits])` | Converts a decimal number to signed hexadecimal format. Learn more |

Engineering | DEC2OCT | `DEC2OCT(decimal_number, [significant_digits])` | Converts a decimal number to signed octal format. Learn more |

Engineering | HEX2BIN | `HEX2BIN(signed_hexadecimal_number, [significant_digits])` | Converts a signed hexadecimal number to signed binary format. Learn more |

Engineering | HEX2DEC | `HEX2DEC(signed_hexadecimal_number)` | Converts a signed hexadecimal number to decimal format. Learn more |

Engineering | HEX2OCT | `HEX2OCT(signed_hexadecimal_number, significant_digits)` | Converts a signed hexadecimal number to signed octal format. Learn more |

Engineering | OCT2BIN | `OCT2BIN(signed_octal_number, [significant_digits])` | Converts a signed octal number to signed binary format. Learn more |

Engineering | OCT2DEC | `OCT2DEC(signed_octal_number)` | Converts a signed octal number to decimal format. Learn more |

Engineering | OCT2HEX | `OCT2HEX(signed_octal_number, [significant_digits])` | Converts a signed octal number to signed hexadecimal format. Learn more |

Financial | CUMIPMT | `CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)` | Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more |

Financial | FV | `FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])` | Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more |

Financial | IPMT | `IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])` | Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate. Learn more |

Financial | IRR | `IRR(cashflow_amounts, [rate_guess])` | Calculates the internal rate of return on an investment based on a series of periodic cash flows. Learn more |

Financial | NPER | `NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])` | Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more |

Financial | NPV | `NPV(discount, cashflow1, [cashflow2, ...])` | Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate. Learn more |

Financial | PMT | `PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])` | Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more |

Financial | PPMT | `PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])` | Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate. Learn more |

Financial | PV | `PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])` | Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more |

Financial | RATE | `RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])` | Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate. Learn more |

Financial | XIRR | `XIRR(cashflow_amounts, cashflow_dates, [rate_guess])` | Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows. Learn more |

Financial | XNPV | `XNPV(discount, cashflow_amounts, cashflow_dates)` | Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate. Learn more |

Info | ISBLANK | `ISBLANK(value)` | Checks whether the referenced cell is empty. Learn more |

Info | ISERR | `ISERR(value)` | Checks whether a value is an error other than #N/A. Learn more |

Info | ISERROR | `ISERROR(value)` | Checks whether a value is an error. Learn more |

Info | ISLOGICAL | `ISLOGICAL(value)` | Checks whether a value is TRUE or FALSE. Learn more |

Info | ISNA | `ISNA(value)` | Checks whether a value is the error #N/A. Learn more |

Info | ISNONTEXT | `ISNONTEXT(value)` | Checks whether a value is non-textual. Learn more |

Info | ISNUMBER | `ISNUMBER(value)` | Checks whether a value is a number. Learn more |

Info | ISTEXT | `ISTEXT(value)` | Checks whether a value is text. Learn more |

Info | NA | `NA()` | Returns the value not available error, #N/A. Learn more |

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 |

Logical | FALSE | `FALSE()` | Returns the logical value FALSE. Learn more |

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 |

Logical | IFERROR | `IFERROR(value, [value_if_error])` | Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent. Learn more |

Logical | IFNA | `IFNA(value, value_if_na)` | Evaluates a value. If the value is an #N/A error, returns the specified value. Learn more. |

Logical | IFS | `IFS(condition1, value1, [condition2, value2], …)` | Evaluates multiple conditions and returns a value that corresponds to the first true condition. Learn more. |

Logical | NOT | `NOT(logical_expression)` | Returns the opposite of a logical value - NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE. Learn more |

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 |

Logical | SWITCH | `SWITCH(expression, case1, value1, [default or case2, value2], …)` | Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met. Learn more |

Logical | TRUE | `TRUE()` | Returns the logical value TRUE. Learn more |

Logical | XOR | `XOR(logical_expression1, [logical_expression2, ...])` | The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise. Learn more. |

Lookup | ADDRESS | `ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])` | Returns a cell reference as a string. Learn more |

Lookup | COLUMN | `COLUMN([cell_reference])` | Returns the column number of a specified cell, with A=1. Learn more |

Lookup | HLOOKUP | `HLOOKUP(search_key, range, index, [is_sorted])` | Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found. Learn more |

Lookup | INDEX | `INDEX(reference, [row], [column])` | Returns the content of a cell, specified by row and column offset. Learn more |

Lookup | LOOKUP | `LOOKUP(search_key, search_range | search_result_array, [result_range])` |

Lookup | MATCH | `MATCH(search_key, range, [search_type])` | Returns the relative position of an item in a range that matches a specified value. Learn more |

Lookup | ROW | `ROW([cell_reference])` | Returns the row number of a specified cell. Learn more |

Lookup | VLOOKUP | `VLOOKUP(search_key, range, index, [is_sorted])` | Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found. Learn more |

Math | ABS | `ABS(value)` | Returns the absolute value of a number. Learn more |

Math | ACOS | `ACOS(value)` | Returns the inverse cosine of a value, in radians. Learn more |

Math | ACOSH | `ACOSH(value)` | Returns the inverse hyperbolic cosine of a number. Learn more |

Math | ACOT | `ACOT(value)` | Returns the inverse cotangent of a value, in radians. Learn more. |

Math | ACOTH | `ACOTH(value)` | Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive. Learn more. |

Math | ASIN | `ASIN(value)` | Returns the inverse sine of a value, in radians. Learn more |

Math | ASINH | `ASINH(value)` | Returns the inverse hyperbolic sine of a number. Learn more |

Math | ATAN | `ATAN(value)` | Returns the inverse tangent of a value, in radians. Learn more |

Math | ATAN2 | `ATAN2(x, y)` | 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 |

Math | ATANH | `ATANH(value)` | Returns the inverse hyperbolic tangent of a number. Learn more |

Math | CEILING | `CEILING(value, [factor])` | Rounds a number up to the nearest integer multiple of specified significance. Learn more |

Math | CEILING.MATH | `CEILING.MATH(number, [significance], [mode])` | 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. |

Math | CEILING.PRECISE | `CEILING.PRECISE(number, [significance])` | 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. |

Math | COS | `COS(angle)` | Returns the cosine of an angle provided in radians. Learn more |

Math | COSH | `COSH(value)` | Returns the hyperbolic cosine of any real number. Learn more |

Math | COT | `COT(angle)` | Cotangent of an angle provided in radians. Learn more. |

Math | COTH | `COTH(value)` | Returns the hyperbolic cotangent of any real number. Learn more. |

Math | COUNTBLANK | `COUNTBLANK(range)` | Returns the number of empty cells in a given range. Learn more |

Math | COUNTIF | `COUNTIF(range, criterion)` | Returns a conditional count across a range. Learn more |

Math | CSC | `CSC(angle)` | Returns the cosecant of an angle provided in radians. Learn more. |

Math | CSCH | `CSCH(value)` | The CSCH function returns the hyperbolic cosecant of any real number. Learn more. |

Math | DECIMAL | `DECIMAL(value, base)` | The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal). Learn more. |

Math | DEGREES | `DEGREES(angle)` | Converts an angle value in radians to degrees. Learn more |

Math | EVEN | `EVEN(value)` | Rounds a number up to the nearest even integer. Learn more |

Math | EXP | `EXP(exponent)` | Returns Euler's number, e (~2.718) raised to a power. Learn more |

Math | FACT | `FACT(value)` | Returns the factorial of a number. Learn more |

Math | FACTDOUBLE | `FACTDOUBLE(value)` | Returns the "double factorial" of a number. Learn more |

Math | FLOOR | `FLOOR(value, [factor])` | Rounds a number down to the nearest integer multiple of specified significance. Learn more |

Math | FLOOR.MATH | `FLOOR.MATH(number, [significance], [mode])` | Rounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more. |

Math | FLOOR.PRECISE | `FLOOR.PRECISE(number, [significance])` | The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance. Learn more. |

Math | GCD | `GCD(value1, value2)` | Returns the greatest common divisor of one or more integers. Learn more |

Math | INT | `INT(value)` | Rounds a number down to the nearest integer that is less than or equal to it. Learn more |

Math | ISEVEN | `ISEVEN(value)` | Checks whether the provided value is even. Learn more |

Math | ISO.CEILING | `ISO.CEILING(number, [significance])` | See CEILING.PRECISE |

Math | ISODD | `ISODD(value)` | Checks whether the provided value is odd. Learn more |

Math | LCM | `LCM(value1, value2)` | Returns the least common multiple of one or more integers. Learn more |

Math | LN | `LN(value)` | Returns the the logarithm of a number, base e (Euler's number). Learn more |

Math | LOG | `LOG(value, base)` | Returns the the logarithm of a number given a base. Learn more |

Math | LOG10 | `LOG10(value)` | Returns the the logarithm of a number, base 10. Learn more |

Math | MOD | `MOD(dividend, divisor)` | Returns the result of the modulo operator, the remainder after a division operation. Learn more |

Math | MROUND | `MROUND(value, factor)` | Rounds one number to the nearest integer multiple of another. Learn more |

Math | ODD | `ODD(value)` | Rounds a number up to the nearest odd integer. Learn more |

Math | PI | `PI()` | Returns the value of Pi to 14 decimal places. Learn more |

Math | POWER | `POWER(base, exponent)` | Returns a number raised to a power. Learn more |

Math | PRODUCT | `PRODUCT(factor1, [factor2, ...])` | Returns the result of multiplying a series of numbers together. Learn more |

Math | RADIANS | `RADIANS(angle)` | Converts an angle value in degrees to radians. Learn more |

Math | RAND | `RAND()` | Returns a random number between 0 inclusive and 1 exclusive. Learn more |

Math | RANDBETWEEN | `RANDBETWEEN(low, high)` | Returns a uniformly random integer between two values, inclusive. Learn more |

Math | ROUND | `ROUND(value, [places])` | Rounds a number to a certain number of decimal places according to standard rules. Learn more |

Math | ROUNDDOWN | `ROUNDDOWN(value, [places])` | Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. Learn more |

Math | ROUNDUP | `ROUNDUP(value, [places])` | Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn more |

Math | SEC | `SEC(angle)` | The SEC function returns the secant of an angle, measured in radians. Learn more. |

Math | SECH | `SECH(value)` | The SECH function returns the hyperbolic secant of an angle. Learn more |

Math | SIGN | `SIGN(value)` | Given an input number, returns -1 if it is negative, 1 if positive, and 0 if it is zero. Learn more |

Math | SIN | `SIN(angle)` | Returns the sine of an angle provided in radians. Learn more |

Math | SINH | `SINH(value)` | Returns the hyperbolic sine of any real number. Learn more |

Math | SQRT | `SQRT(value)` | Returns the positive square root of a positive number. Learn more |

Math | SQRTPI | `SQRTPI(value)` | Returns the positive square root of the product of Pi and the given positive number. Learn more |

Math | SUM | `SUM(value1, [value2, ...])` | Returns the sum of a series of numbers and/or cells. Learn more |

Math | SUMIF | `SUMIF(range, criterion, [sum_range])` | Returns a conditional sum across a range. Learn more |

Math | TAN | `TAN(angle)` | Returns the tangent of an angle provided in radians. Learn more |

Math | TANH | `TANH(value)` | Returns the hyperbolic tangent of any real number. Learn more |

Math | TRUNC | `TRUNC(value, [places])` | Truncates a number to a certain number of significant digits by omitting less significant digits. Learn more |

Operator | CONCAT | `CONCAT(value1, value2)` | Returns the concatenation of two values. Equivalent to the & operator. Learn more |

Statistical | AVERAGE | `AVERAGE(value1, [value2, ...])` | Returns the numerical average value in a dataset, ignoring text. Learn more |

Statistical | AVERAGEA | `AVERAGEA(value1, [value2, ...])` | Returns the numerical average value in a dataset. Learn more |

Statistical | AVERAGEIF | `AVERAGEIF(criteria_range, criterion, [average_range])` | Returns the average of a range depending on criteria. Learn more |

Statistical | CORREL | `CORREL(data_y, data_x)` | Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more |

Statistical | COUNT | `COUNT(value1, [value2, ...])` | Returns a count of the number of numeric values in a dataset. Learn more |

Statistical | COUNTA | `COUNTA(value1, [value2, ...])` | Returns a count of the number of values in a dataset. Learn more |

Statistical | FORECAST | `FORECAST(x, data_y, data_x)` | Calculates the expected y-value for a specified x based on a linear regression of a dataset. Learn more |

Statistical | FORECAST.LINEAR | `FORECAST.LINEAR(x, data_y, data_x)` | See FORECAST |

Statistical | LARGE | `LARGE(data, n)` | Returns the nth largest element from a data set, where n is user-defined. Learn more |

Statistical | MAX | `MAX(value1, [value2, ...])` | Returns the maximum value in a numeric dataset. Learn more |

Statistical | MAXA | `MAXA(value1, value2)` | Returns the maximum numeric value in a dataset. Learn more |

Statistical | MEDIAN | `MEDIAN(value1, [value2, ...])` | Returns the median value in a numeric dataset. Learn more |

Statistical | MIN | `MIN(value1, [value2, ...])` | Returns the minimum value in a numeric dataset. Learn more |

Statistical | MINA | `MINA(value1, value2)` | Returns the minimum numeric value in a dataset. Learn more |

Statistical | SLOPE | `SLOPE(data_y, data_x)` | Calculates the slope of the line resulting from linear regression of a dataset. Learn more |

Statistical | SMALL | `SMALL(data, n)` | Returns the nth smallest element from a data set, where n is user-defined. Learn more |

Statistical | STDEV | `STDEV(value1, [value2, ...])` | Calculates the standard deviation based on a sample. Learn more |

Statistical | STDEV.P | `STDEV.P(value1, [value2, ...])` | See STDEVP |

Statistical | STDEV.S | `STDEV.S(value1, [value2, ...])` | See STDEV |

Statistical | STDEVA | `STDEVA(value1, value2)` | Calculates the standard deviation based on a sample, setting text to the value 0. Learn more |

Statistical | STDEVP | `STDEVP(value1, value2)` | Calculates the standard deviation based on an entire population. Learn more |

Statistical | STDEVPA | `STDEVPA(value1, value2)` | Calculates the standard deviation based on an entire population, setting text to the value 0. Learn more |

Statistical | VAR | `VAR(value1, [value2, ...])` | Calculates the variance based on a sample. Learn more |

Statistical | VAR.P | `VAR.P(value1, [value2, ...])` | See VARP |

Statistical | VAR.S | `VAR.S(value1, [value2, ...])` | See VAR |

Statistical | VARA | `VARA(value1, value2)` | Calculates an estimate of variance based on a sample, setting text to the value 0. Learn more |

Statistical | VARP | `VARP(value1, value2)` | Calculates the variance based on an entire population. Learn more |

Statistical | VARPA | `VARPA(value1, value2,...)` | Calculates the variance based on an entire population, setting text to the value 0. Learn more |

Text | ARABIC | `ARABIC(roman_numeral)` | Computes the value of a Roman numeral. Learn more |

Text | CONCATENATE | `CONCATENATE(string1, [string2, ...])` | Appends strings to one another. Learn more |

Text | FIND | `FIND(search_for, text_to_search, [starting_at])` | Returns the position at which a string is first found within text. Learn more |

Text | LEFT | `LEFT(string, [number_of_characters])` | Returns a substring from the beginning of a specified string. Learn more |

Text | LEN | `LEN(text)` | Returns the length of a string. Learn more |

Text | LOWER | `LOWER(text)` | Converts a specified string to lowercase. Learn more |

Text | MID | `MID(string, starting_at, extract_length)` | Returns a segment of a string. Learn more |

Text | REPLACE | `REPLACE(text, position, length, new_text)` | Replaces part of a text string with a different text string. Learn more |

Text | RIGHT | `RIGHT(string, [number_of_characters])` | Returns a substring from the end of a specified string. Learn more |

Text | ROMAN | `ROMAN(number, [rule_relaxation])` | Formats a number in Roman numerals. Learn more |

Text | SEARCH | `SEARCH(search_for, text_to_search, [starting_at])` | Returns the position at which a string is first found within text. Learn more |

Text | TRIM | `TRIM(text)` | Removes leading and trailing spaces in a specified string. Learn more |

Text | UPPER | `UPPER(text)` | Converts a specified string to uppercase. Learn more |