Spreadsheet.com allows the creation of cell and column formulas using over 400 functions with identical syntax to those typically found in traditional spreadsheet systems. In addition to these common functions, you'll also find new functions that are unique to Spreadsheet.com, such as those for working with data in parent and child rows in worksheets with row hierarchies.
Below is a complete list of all the functions available in Spreadsheet.com by category.
| Type | Function | Syntax | Description |
| Array | ARGS2ARRAY | ARGS2ARRAY(value1, [value2,…]) | Converts arguments into an array. Learn more |
| Array | FLATTEN | FLATTEN(value1, [value2,…]) | Flattens a 2D array into a 1D array. Learn more |
| Array | FREQUENCY | FREQUENCY(data, classes) | Calculates the frequency distribution of a one-column array into specified classes. Learn more |
| Array | GROWTH | GROWTH(known_data_y, known_data_x, [new_data_x], [statistics]) | Calculates values based on exponential trend. Learn more |
| Array | LINEST | LINEST(known_data_y, [known_data_x], [constant], [statistics]) | Returns an array that describes the best fit linear trend using least squares method. Learn more |
| Array | LOGEST | LOGEST(known_data_y, [known_data_x], [constant], [statistics]) | Returns an array that describes the exponential curve that fits the given data. Learn more |
| Array | SUMPRODUCT | SUMPRODUCT(array1, [array2,…]) | Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more |
| Array | SUMX2MY2 | SUMX2PY2(array1, array2) | Calculates the sum of the differences of the squares of values in two arrays or ranges. Learn more |
| Array | SUMX2PY2 | SUMXMY2(array1, array2) | Calculates the sum of the sums of the squares of values in two arrays or ranges. Learn more |
| Array | SUMXMY2 | SUMXYMY2(array1, array2) | Calculates the sum of the squares of differences of values in two arrays or ranges. Learn more |
| Array | TRANSPOSE | TRANSPOSE(range) | Fits a linear trend using least squares method. Learn more |
| Array | TREND | TREND(known_data_y, known_data_x, [new_data_x], [statistics]) | Transposes the rows and columns of an array or range of cells. Learn more |
| Date and time | DATE | DATE(year, month, day) | Converts year/month/day into a date. Learn more |
| Date and time | DATEVALUE | DATEVALUE(date_string) | Converts a date string into a date value. Learn more |
| Date and time | DAY | DAY(date) | Returns the day corresponding to the given date. Learn more |
| Date and time | DAYS | DAYS(value1, value2) | Calculates the difference, in days, between two date values. Learn more |
| Date and time | DAYS360 | DAYS360(start_date, end_date, [method]) | Returns the difference between two days based on the 360 day year used in some financial interest calculations. Learn more |
| Date and time | EDATE | EDATE(start_date, [months]) | Returns a date a specified number of months before or after a given date. Learn more |
| Date and time | EOMONTH | EOMONTH(start_date, [months]) | Returns the date on the last day of a month that falls before/after a given date. Learn more |
| Date and time | HOUR | HOUR(date) | Returns the hour component, as an integer, for the given time value. Learn more |
| Date and time | ISOWEEKNUM | ISOWEEKNUM(date) | Returns the ISO week number of the year where the provided date falls. Learn more |
| Date and time | MINUTE | MINUTE(time) | Returns the minute component, as an integer, for the given time value. Learn more |
| Date and time | MONTH | MONTH(date) | Returns the month corresponding to the given date. Learn more |
| Date and time | NETWORKDAYS | NETWORKDAYS(start_date, end_date, [holidays]) | Returns the number of net working days between two provided dates. Learn more |
| date and time | NETWORKDAYS.INTL | NETWORKDAYS(start_date, end_date, [holidays]) | The number of workdays between two dates (excluding specified weekends).Learn more |
| Date and time | NOW | NOW() | Returns the current computer system date and time. The value is updated when your document recalculates. This function has no arguments. Learn more |
| Date and time | SECOND | SECOND(time) | Returns the second component, as an integer, for the given time value. Learn more |
| Date and time | TIME | TIME(hour, minute, second) | Converts hours/minutes/seconds into a time. Learn more |
| Date and time | TIMEVALUE | TIMEVALUE(time_string) | Returns the fraction of a 24-hour day the time represents. Learn more |
| Date and time | TODAY | TODAY() | Returns the current computer system date. The value is updated when your document recalculates. This function has no arguments. Learn more |
| Date and time | WEEKDAY | WEEKDAY(date, [type]) | Returns the day of the week for a given date. Returns an integer, based on the type. Learn more |
| Date and time | WEEKNUM | WEEKNUM(date, [type]) | Returns the week number of the year. Returns an integer, based on the type. Learn more |
| Date and time | WORKDAY | WORKDAY(start_date, days, [holidays]) | Calculates the date after a number of working days from a specified start date. Learn more |
| date and time | WORKDAY.INTL | WORKDAY.INTL(start_date, days, [weekends], [holidays]) | Returns a date adjusted by a given number of working days (excluding specified weekends).Learn more |
| date and time | WORKDAYINTL | WORKDAYINTL(start_date, days, [weekends], [holidays]) | Returns a date adjusted by a given number of working days (excluding specified weekends).Learn more |
| Date and time | YEAR | YEAR(date) | Returns the year corresponding to the given date. Learn more |
| Date and time | YEARFRAC | YEARFRAC(value1, value2, [type]) | Calculates the difference in years, including fractional years, between two dates, using a specified day-count method. Learn more |
| Engineering | BESSELI | BESSELI(x, n) | Returns the modified Bessel function In(x). Learn more |
| Engineering | BESSELJ | BESSELJ(x, n) | Returns the Bessel function Jn(x). Learn more |
| Engineering | BESSELK | BESSELK(x, n) | Returns the modified Bessel function Kn(x). Learn more |
| Engineering | BESSELY | BESSELY(x, n) | Returns the Bessel function Yn(x). Learn more |
| Engineering | BIN2DEC | BIN2DEC(number) | Converts a binary number to a decimal number. Learn more |
| Engineering | BIN2HEX | BIN2HEX(number, [places]) | Converts a binary number to a hexadecimal number. Learn more |
| Engineering | BIN2OCT | BIN2OCT(number, [places]) | Converts a binary number to an octal number. Learn more |
| Engineering | BITAND | BITAND(value1, value2) | Returns a bitwise boolean 'AND' of two numbers. Learn more |
| Engineering | BITLSHIFT | BITLSHIFT(value1, shiftby) | Returns a number shifted left by the specified number of bits. Learn more |
| Engineering | BITOR | BITOR(value1, value2) | Returns a bitwise boolean 'OR' of two numbers. Learn more |
| Engineering | BITRSHIFT | BITRSHIFT(value1, shiftby) | Returns a number shifted right by the specified number of bits. Learn more |
| Engineering | BITXOR | BITXOR(value1, value2) | Returns a bitwise boolean 'XOR' of two numbers. Learn more |
| Engineering | COMPLEX | COMPLEX(number1, number2, [suffix]) | Creates a complex number given real and imaginary coefficients. Learn more |
| Engineering | CONVERT | CONVERT(value, from_unit, to_unit) | Converts a numeric value to a different unit of measure. Learn more |
| Engineering | DEC2BIN | DEC2BIN(number, [places]) | Converts a decimal number to a binary number. Learn more |
| Engineering | DEC2HEX | DEC2HEX(number, [places]) | Converts a decimal number to a hexadecimal number. Learn more |
| Engineering | DEC2OCT | DEC2OCT(number, [places]) | Converts a decimal number to an octal number. Learn more |
| Engineering | DELTA | DELTA(number1, number2) | Compares two numeric values. Returns 1 if the arguments are equal, and returns 0 otherwise. Learn more |
| Engineering | ERF | ERF(lower_limit, [upper_limit]) | Returns the integral of the Gauss error function over an interval of values. Learn more |
| Engineering | ERFC | ERFC(lower_limit) | Returns the complementary Gauss error function of a value. Learn more |
| Engineering | GESTEP | GESTEP(value, [step]) | Returns 1 if number ≥ step, returns 0 otherwise. Learn more |
| Engineering | HEX2BIN | HEX2BIN(number, [places]) | Converts a hexadecimal number to a binary number. Learn more |
| Engineering | HEX2DEC | HEX2DEC(number, [places]) | Converts a hexadecimal number to a decimal number. Learn more |
| Engineering | HEX2OCT | HEX2OCT(number, [places]) | Converts a hexadecimal number to an octal number. Learn more |
| Engineering | IMABS | IMABS(complex_number) | Returns the absolute value of a complex number. Learn more |
| Engineering | IMAGINARY | IMAGINARY(complex_number) | Returns the imaginary coefficient of a complex number. Learn more |
| Engineering | IMARGUMENT | IMARGUMENT(complex_number) | Returns the angle of a complex number, in radians. Learn more |
| Engineering | IMCONJUGATE | IMCONJUGATE(complex_number) | Returns the conjugated complex complement of a complex number. Learn more |
| Engineering | IMCOS | IMCOS(complex_number) | Returns the cosine of a complex number. Learn more |
| Engineering | IMCOSH | IMCOSH(complex_number) | Returns the hyperbolic cosine of a complex number. Learn more |
| Engineering | IMCOT | IMCOT(complex_number) | Returns the cotangent of a complex number. Learn more |
| Engineering | IMCSC | IMCSC(complex_number) | Returns the cosecant of a complex number. Learn more |
| Engineering | IMCSCH | IMCSCH(complex_number) | Returns the hyperbolic cosecant of a complex number. Learn more |
| Engineering | IMDIV | IMDIV(complex_number1, complex_number2) | Returns the result of division of two complex numbers. Learn more |
| Engineering | IMEXP | IMEXP(complex_number) | Returns the exponential of a complex number. Learn more |
| Engineering | IMLN | IMLN(complex_number) | Returns the natural logarithm of a complex number. Learn more |
| Engineering | IMLOG10 | IMLOG10(complex_number) | Returns the base-10 logarithm of the given complex number. Learn more |
| Engineering | IMLOG2 | IMLOG2(complex_number) | Returns the base-2 logarithm of the given complex number. Learn more |
| Engineering | IMPOWER | IMPOWER(complex_number, number) | Returns the integer power of a complex number. Learn more |
| Engineering | IMPRODUCT | IMPRODUCT(complex_number1, [complex_number2, ...]) | Returns the result of multiplication of a series of complex numbers. Learn more |
| Engineering | IMREAL | IMREAL(complex_number) | Returns the real coefficient of a complex number. Learn more |
| Engineering | IMSEC | IMSEC(complex_number) | Returns the secant of a complex number. Learn more |
| Engineering | IMSECH | IMSECH(complex_number) | Returns the hyperbolic secant of a complex number. Learn more |
| Engineering | IMSIN | IMSIN(complex_number) | Returns the sine of a complex number. Learn more |
| Engineering | IMSINH | IMSINH(complex_number) | Returns the hyperbolic sine of a complex number. Learn more |
| Engineering | IMSQRT | IMSQRT(complex_number) | Returns the square root of a complex number. Learn more |
| Engineering | IMSUB | IMSUB(complex_number1, complex_number2) | Returns the difference between two complex numbers. Learn more |
| Engineering | IMSUM | IMSUM(complex_number1, [complex_number2, ...]) | Returns the result of addition of two or more complex numbers. Learn more |
| Engineering | IMTAN | IMTAN(complex_number) | Returns the tangent of a complex number. Learn more |
| Engineering | OCT2BIN | OCT2BIN(number, [places]) | Converts an octal number to a binary number. Learn more |
| Engineering | OCT2DEC | OCT2DEC(number, [places]) | Converts an octal number to a decimal number. Learn more |
| Engineering | OCT2HEX | OCT2HEX(number, [places]) | Converts an octal number to a hexadecimal number. Learn more |
| Financial | ACCRINT | ACCRINT(issue, first_interest, settlement, rate, redemption, frequency, [basis]) | Calculates the accrued interest of a security that pays periodic interest. Learn more |
| Financial | CUMIPMT | CUMIPMT(rate, total_periods, present value, first_period, last_period, type) | Calculates the cumulative interest payments for an investment based on a constant interest rate. Learn more |
| Financial | CUMPRINC | CUMPRINC(rate, total_periods, present value, first_period, last_period, type) | Calculates the cumulative principal paid for an investment based on a constant interest rate. Learn more |
| Financial | DB | DB(cost, salvage, life, period, [method]) | Returns the depreciation of an asset for a specified period using the arithmetic declining balance method. Learn more |
| Financial | DDB | DDB(cost, salvage, life, period, [factor]) | Returns the depreciation of an asset for a specified period using the double declining balance method. Learn more |
| Financial | DOLLARDE | DOLLARDE(fractional_price, fraction) | Converts a price quotation given as a decimal fraction into a decimal value. Learn more |
| Financial | DOLLARFR | DOLLARFR(decimal_price, fraction) | Converts a price quotation given as a decimal value into a decimal fraction. Learn more |
| Financial | EFFECT | EFFECT(nominal_rate, frequency) | Calculates the effective annual interest rate. Learn more |
| Financial | FV | FV(rate, total_periods, payment_amount, present_value, type) | Calculates the future value of an annuity investment based on a constant interest rate. Learn more |
| Financial | FVSCHEDULE | FVSCHEDULE(principal, schedule) | Calculates the accumulated future value of principal for a series of rates. Learn more |
| Financial | IPMT | IPMT(rate, period, total_periods, present_value, [future_value], [type]) | Calculates the payment on interest for an investment based on periodic payments and a constant interest rate. Learn more |
| Financial | IRR | IRR(values, [guess]) | Calculates the internal rate of return for an investment where the payments occur at regular intervals, such as monthly or annually. Learn more |
| Financial | ISPMT | ISPMT(rate, period, total_periods, present_value) | Calculates the interest paid at a particular period of an investment. Learn more |
| Financial | MIRR | MIRR(values, finance_rate, reinvest_rate) | Calculates the modified internal rate of return for a list of payments based on the difference between the interest rate paid on the invested funds versus the return received on reinvested income. Learn more |
| Financial | NOMINAL | NOMINAL(effective_rate, periods_year) | Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.Learn more |
| Financial | NPER | NPER(rate, payment_amount, present_value, [future_value], [type]) | 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(rate, 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 | PDURATION | PDURATION(rate, present_value, future_value) | Computes the time needed for an investment to reach a specified value. Learn more |
| Financial | PMT | PMT(rate, total_periods, present_value, [future_value], [type]) | 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, total_periods, present_value, [future_value], [type]) | 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, total_periods, payment_amount, [future_value], [type]) | Calculates the present value of an annuity investment based on a constant interest rate. Learn more |
| Financial | RATE | RATE(total_periods, payment_amount, present_value, [future_value], [type], [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 | RRI | RRI(total_periods, present_value, future_value) | Computes the rate needed for an investment to reach a specific value within a specific number of periods. Learn more |
| Financial | SLN | SLN(cost, salvage, life) | Returns the depreciation of an asset for one period using the straight-line method. Learn more |
| Financial | SYD | SYD(cost, salvage, life, period) | Returns the depreciation of an asset for a specified period using the sum of years digits method. Learn more |
| Financial | TBILLEQ | TBILLEQ(settlement, maturity, discount) | Returns the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more |
| Financial | TBILLPRICE | TBILLPRICE(settlement, maturity, discount) | Calculates the price of a US Treasury Bill based on discount rate. Learn more |
| Financial | TBILLYIELD | TBILLYIELD(settlement, maturity, price) | Calculates the yield of a US Treasury Bill based on price. Learn more |
| Financial | XIRR | XIRR(values, dates, [guess]) | Calculates the internal rate of return for a list of payments that take place on different dates. Learn more |
| Financial | XNPV | XNPV(rate, 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 |
| Hierarchy | ANCESTORCELLS | ANCESTORCELLS(cell) | Returns all of the ancestor cell values above a given cell in the row hierarchy. Learn more |
| Hierarchy | CHILDCELLS | CHILDCELLS(cell) | Returns all of the first-level child cell values below a given parent cell in the row hierarchy. Learn more |
| Hierarchy | DESCENDANTCELLS | DESCENDENTCELLS(cell) | Returns all of the descendant cell values below a given cell in the row hierarchy. Learn more |
| Hierarchy | PARENTCELL | PARENTCELL(cell) | Returns the parent cell value above a given cell in the row hierarchy. Learn more |
| Information | ISBINARY | ISBINARY(value) | Returns TRUE if the value is a binary value. Learn more |
| Information | ISBLANK | ISBLANK(value) | Returns TRUE if the value is blank. Learn more |
| Information | ISERR | ISERR(value) | Returns TRUE if the value is an error other than ‘#NA’. Learn more |
| Information | ISERROR | ISERROR(value) | Returns TRUE if the value is any error value. Learn more |
| Information | ISEVEN | ISEVEN(number) | Returns TRUE if the given number is even, or FALSE if the number is odd. Learn more |
| Information | ISFORMULA | ISFORMULA(reference) | Simple way to test whether a cell has a formula. Returns TRUE if the referenced cell contains a formula, and FALSE if not. Learn more |
| Information | ISLOGICAL | ISLOGICAL(value) | Returns TRUE if the value is a logical value. Learn more |
| Information | ISNA | ISNA(value) | Checks if a value is the error N/A.Learn more |
| Information | ISNONTEXT | ISNONTEXT(value) | Returns TRUE if the value is not text. Learn more |
| Information | ISNUMBER | ISNUMBER(value) | Returns TRUE if the value is a number. Learn more |
| Information | ISODD | ISODD(number) | Returns TRUE if the given number is odd, or FALSE if the number is even. Learn more |
| Information | ISREF | ISREF(value) | Checks if a value is a valid cell reference.Learn more |
| Information | ISTEXT | ISTEXT(value) | Returns TRUE if the value is text. Learn more |
| Information | NA | NA() | Returns the “value not available” error, ‘#N/A’. This function has no arguments. Learn more |
| Logical | AND | AND(logical_expression1, [logical_expression2, ...]) | Returns TRUE if all arguments are TRUE. Returns FALSE if any of the arguments is FALSE. Learn more |
| Logical | FALSE | FALSE() | Sets the logical value to FALSE. This function has no arguments. Learn more |
| Logical | IF | IF(logical_expression, then_value, otherwise_value) | Returns a value based on a logical test. Learn more |
| Logical | IFERROR | IFERROR(value, [value_if_error]) | Returns a specified value if a formula evaluates to an error; otherwise, it returns the result of the formula. Learn more |
| Logical | IFNA | IFNA(value, value_if_error) | Returns a value after checking for the NA error.Learn more |
| Logical | NOT | NOT(logical_expression1) | Returns TRUE if the argument is FALSE. Returns FALSE if the argument is TRUE. Learn more |
| Logical | OR | OR(logical_expression1, [logical_expression2, ...]) | Returns TRUE if at least one argument is TRUE. Returns FALSE if all of the arguments are FALSE. Learn more |
| Logical | SWITCH | SWITCH(expression, case1, value1, [case2,..], [value2,..]) | Tests an expression against a list of cases and returns the corresponding value of the first matching case. Learn more |
| Logical | TRUE function | TRUE() | Sets the logical value to TRUE. This function has no arguments. Learn more |
| Logical | XOR | XOR(logical_expression1, [logical_expression2, ...]) | Returns TRUE if an odd number of arguments are TRUE. Else, returns FALSE. Learn more |
| Lookup | CHOOSE | CHOOSE(index, choice1, [choice2,..]) | Returns an element from a list of choices based on index. Learn more |
| Lookup | COLUMN | COLUMN([cell reference]) | Returns the column number of a cell. Learn more |
| Lookup | COLUMNS | COLUMNS(range) | Returns the number of columns in a specified array or range. Learn more |
| Lookup | HLOOKUP | HLOOKUP(value, range, index, [sorted]) | Horizontal lookup. Searches down the first row of a range for a key and returns the value of a specified cell in the column found. Learn more |
| Lookup | HYPERLINK | HYPERLINK(url, [label]) | Creates a hyperlink inside a cell. Learn more |
| Lookup | INDEX | INDEX(reference, [row], [column]) | Returns the content of cell(s) specified by the row and column number indexes. Learn more |
| Lookup | INDIRECT | INDIRECT(text, [A1_notation]) | Returns a cell reference specified by a string. Learn more |
| Lookup | MATCH | MATCH(value, range, search_type) | Returns the position of an item in a range that matches a specified value. Learn more |
| Lookup | OFFSET | OFFSET(reference, rows, columns, [height], [width]) | Returns a reference to a range that is a specified number of rows and columns from a cell reference. Learn more |
| Lookup | ROW | ROW([cell reference]) | Returns the row number of a cell. Learn more |
| Lookup | ROWS | ROWS(range) | Returns the number of rows in a specified array or range. Learn more |
| Lookup | UNIQUE | UNIQUE(range) | Returns all the unique rows in the provided range. Learn more |
| Lookup | VLOOKUP | VLOOKUP(value, range, index, [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 |
| Lookup | XLOOKUP | XLOOKUP(value, range, index, [match_type], [search_type]) | Lookup value in a range .Learn more |
| Math | ABS | ABS(number) | Returns the absolute value of the given number. Learn more |
| Math | ACOS | ACOS(number) | Returns the inverse cosine of the given number in radians. Learn more |
| Math | ACOSH | ACOSH(number) | Returns the inverse hyperbolic cosine of the given number in radians. Learn more |
| Math | ACOT | ACOT(number) | Returns the inverse cotangent of the given number in radians. Learn more |
| Math | ACOTH | ACOTH(number) | Returns the inverse hyperbolic cotangent of the given number in radians. Learn more |
| Math | ADD | ADD(number_1, number_2) | Returns the sum of two numbers. Learn more |
| Math | AGGREGATE | AGGREGATE(function_code, options range1, [range2,..]) | Returns an aggregate in a list or database. Learn more |
| Math | ASIN | ASIN(number) | Returns the inverse sine of the given number in radians. Learn more |
| Math | ASINH | ASINH(number) | Returns the inverse sine of the given number in radians. Learn more |
| Math | ATAN | ATAN(number) | Returns the inverse tangent of the given number in radians. Learn more |
| Math | ATAN2 | ATAN2(x_coordinate, y_coordinate) | Returns the inverse tangent of the specified x and y coordinates, expressed in radians. Learn more |
| Math | ATANH | ATANH(number) | Returns the inverse hyperbolic tangent of the given number in radians. Learn more |
| Math | BASE | BASE(value, base, [min_length]) | Converts a number into a text representation in another base. Learn more |
| Math | CEILING | CEILING(value, [factor]) | Rounds a number up to the nearest integer multiple of specified significance factor. Learn more |
| Math | CEILING.MATH | CEILING.MATH(value, [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(value, [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 | CEILINGMATH | CEILINGMATH(value, [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 | CEILINGPRECISE | CEILINGPRECISE(value, [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 | COMBIN | COMBIN(number1, number2) | Returns the number of combinations for a given number of objects. Learn more |
| Math | COMBINA | COMBINA(number1, number2) | Returns the number of combinations (including repetitions) for a given number of objects. Learn more |
| Math | COS | COS(number) | Returns the cosine of the given angle, provided in radians. Learn more |
| Math | COSH | COSH(number) | Returns the hyperbolic cosine of the given angle, provided in radians. Learn more |
| Math | COT | COT(number) | Returns the cotangent of the given angle, provided in radians. Learn more |
| Math | COTH | COTH(number) | Returns the hyperbolic cotangent of the given angle, provided in radians. Learn more |
| Math | COUNTBLANK | COUNTBLANK(range) | Returns a count of the number of empty cells in a dataset. Learn more |
| Math | COUNTIF | COUNTIF(range, criteria) | Returns the number of elements within a cell range that meet a certain criteria. Learn more |
| Math | COUNTIFS | COUNTIFS(range1, criteria1 [range2, ...], [criteria2, ...]) | Returns the number of elements within a cell range that meet multiple criteria. Learn more |
| Math | COUNTIN | COUNTIN(range, element) | Returns the number of occurrences of given element within a cell range. Learn more |
| Math | COUNTUNIQUE | COUNTUNIQUE(value1, [value2, ...]) | Counts the number of unique values in a dataset. Learn more |
| Math | CSC | CSC(number) | Returns the cosecant of a number. Learn more |
| Math | CSCH | CSCH(number) | Returns the hyperbolic cosecant of a number. Learn more |
| Math | DECIMAL | DECIMAL(value, base) | Converts the text representation of a number in another base to decimal. Learn more |
| Math | DEGREES | DEGREES(number) | Converts the given number in radians to degrees. Learn more |
| Math | DIVIDE | DIVIDE(number1, number2) | Returns the result of division of two numbers. Learn more |
| Math | E | E() | Returns the value of e (Euler’s number). This function has no arguments. Learn more |
| Math | EQ | EQ(value1, value2) | Returns TRUE if two specified values are equal and FALSE otherwise. Learn more |
| Math | EVEN | EVEN(number) | Rounds the given number up to the nearest even integer. Learn more |
| Math | EXP | EXP(number) | Returns e raised to the power of the given number. Learn more |
| Math | FACT | FACT(number) | Returns the factorial of the given number. Learn more |
| Math | FACTDOUBLE | FACTDOUBLE(number) | Returns the double factorial of the given number. Learn more |
| Math | FLOOR | FLOOR(value, [factor]) | Rounds a number down to the nearest integer multiple of specified significance factor. Learn more |
| Math | FLOOR.MATH | FLOOR.MATH(value, [factor]) | Rounds number down to nearest multiple of a factor.Learn more |
| Math | FLOOR.PRECISE | FLOOR.PRECISE(value, [factor]) | Rounds number down to nearest multiple of a factor.Learn more |
| Math | GCD | GCD(value1, [value2, ...]) | Returns the greatest common divisor of one or more integers. Learn more |
| Math | GT | GT(value1, value2) | Checks if a value is greater than another.Learn more |
| Math | GTE | GTE(value1, value2) | Returns TRUE if the first argument is greater than or equal to the second, and FALSE otherwise. Learn more |
| Math | INT | INT(number) | Rounds the number to the nearest integer. Learn more |
| Math | ISO.CEILING | ISO.CEILING(value, [significance]) | Rounds a number up to nearest multiple of a factor.Learn more |
| Math | LCM | LCM(value1, [value2, ...]) | Returns the least common multiple of one or more integers. Learn more |
| Math | LN | LN(number) | Returns the natural logarithm of a number, base e. Learn more |
| Math | LOG | LOG(number, base) | Returns the logarithm of the given number to the specified base. Learn more |
| Math | LOG10 | LOG10(number) | Returns the base-10 logarithm of the given number. Learn more |
| Math | LT | LT(value1, value2) | Returns TRUE if the first argument is lesser than the second, and FALSE otherwise. Learn more |
| Math | LTE | LTE(value1, value2) | Returns TRUE if the first argument is lesser than or equal to the second, and FALSE otherwise. Learn more |
| Math | MINUS | MINUS(value1, value2) | Returns the difference of two numbers. Learn more |
| Math | MOD | MOD(number1, number2) | Returns the remainder after the division of two numbers. Learn more |
| Math | MROUND | MROUND(value, factor) | Rounds number to an integer multiple of a factor. Learn more |
| Math | MULTINOMIAL | MULTINOMIAL(value1, [value2, ...]) | Returns the factorial of the sum of values divided by the product of the values' factorials. Learn more |
| Math | MULTIPLY | MULTIPLY(value1, value2) | Returns the product of two numbers. Learn more |
| Math | NE | NE(value1, value2) | Returns TRUE if the specified values are not equal and "FALSE" otherwise. Learn more |
| Math | ODD | ODD(number) | Rounds the given number up to the nearest odd integer. Learn more |
| Math | PI | PI() | Returns the value of PI. This function has no arguments. Learn more |
| Math | POW | POW(base, exponent) | Returns the result of a number raised to a given power. Learn more |
| Math | POWER | POWER(base, exponent) | Returns the result of a number raised to a given power. Learn more |
| Math | PRODUCT | PRODUCT(value1, [value2, ...]) | Returns the product of a series of numbers and/or cells. Learn more |
| Math | QUOTIENT | QUOTIENT(number1, number2) | Returns the result of division of two numbers. Learn more |
| Math | RADIANS | RADIANS(number) | Converts the given number in degrees to radians. Learn more |
| Math | RAND | RAND() | Returns a random number between 0 and 1. This function has no arguments. Learn more |
| Math | RANDBETWEEN | RANDBETWEEN(number1, number2) | Returns a random number between two specified values (inclusive). Learn more |
| Math | ROUND | ROUND(value1, [value2]) | Rounds a given number to a specified number of places. Learn more |
| Math | ROUNDDOWN | ROUNDDOWN(value1, [count]) | Rounds down a given number to a specified number of places. Learn more |
| Math | ROUNDUP | ROUNDUP(value1, [count]) | Rounds up a given number to a specified number of places. Learn more |
| Math | SEC | SEC(number) | Returns the secant of a number. Learn more |
| Math | SECH | SECH(number) | Returns the hyperbolic secant of a number. Learn more |
| Math | SERIESSUM | SERIESSUM(x, n, m, coefficients) | Returns the sum of a power series. Learn more |
| Math | SIGN | SIGN(number) | Returns the sign of a given number. The function returns 1 for a positive sign, -1 for a negative sign, and 0 for zero. Learn more |
| Math | SIN | SIN(number) | Returns the sine of the given angle, provided in radians. Learn more |
| Math | SINH | SINH(number) | Returns the hyperbolic sine of the given angle, provided in radians. Learn more |
| Math | SQRT | SQRT(value) | Returns the positive square root of the given number. Learn more |
| Math | SQRTPI | SQRTPI(number) | Returns the positive square root of the product of Pi and the given positive number. Learn more |
| Math | SUBTOTAL | SUBTOTAL(function_code, range1 , [range2,..]) | Returns a subtotal for a vertical range of cells using a specified aggregation function. Learn more |
| Math | SUM | SUM(value1, [value2, ...]) | Returns the sum of a series of numbers and/or cells. Learn more |
| Math | SUMIF | SUMIF(range, criteria, [sum_range]) | Adds the cells specified by a given criteria. Learn more |
| Math | SUMIFS | SUMIFS(range, criteria_range1 criteria1, [criteria_range2], [criteria2]) | Returns the sum of a range depending on multiple criteria. Learn more |
| Math | SUMSQ | SUMSQ(value1, [value2, ...]) | Calculates the sum of the squares of the arguments. Learn more |
| Math | TAN | TAN(number) | Returns the tangent of the given angle, provided in radians. Learn more |
| Math | TANH | TANH(number) | Returns the hyperbolic tangent of the given angle, provided in radians. Learn more |
| Math | TRUNC | TRUNC(number, [count]) | Truncates a number to a specified number of digits. Learn more |
| Statistical | AVEDEV | AVEDEV(value1, [value2, ...]) | Calculates the average of the deviations of data points from their mean. Learn more |
| Statistical | AVERAGE | AVERAGE(value1, [value2, ...]) | Returns the average value of a series of numbers and/or cells. Learn more |
| Statistical | AVERAGEA | AVERAGEA(value1, [value2, ...]) | Returns the average value of a series of numbers and/or logical statements. Learn more |
| Statistical | AVERAGEIF | AVERAGEIF(range, criteria, [average_of]) | The average of cells that meet a criteria. Learn more |
| Statistical | AVERAGEIFS | AVERAGEIFS(range, criteria_range1 criteria1, [criteria_range2], [criteria2]) | The average of cells that meet multiple criteria. Learn more |
| Statistical | BETA.DIST | BETA.DIST(number, alpha, beta, [start], [end]) | Returns the cumulative beta probability density function. Learn more |
| Statistical | BETA.INV | BETA.INV(probability, alpha, beta, [start], [end]) | Returns the inverse of the cumulative beta probability density function. Learn more |
| Statistical | BETADIST | BETADIST(number, alpha, beta, [start], [end]) | Returns the cumulative beta probability density function. Learn more |
| Statistical | BETAINV | BETAINV(probability, alpha, beta, [start], [end]) | Returns the inverse of the cumulative beta probability density function. Learn more |
| Statistical | BINOM.DIST | BINOM.DIST(number_s, trials, probability_s, cumulative) | Returns the individual term binomial distribution probability. Learn more |
| Statistical | BINOM.DIST.RANGE | BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2]) | Returns the probability of a trial result using a binomial distribution. Learn more |
| Statistical | BINOM.INV | BINOM.INV(trials, probability_s, alpha) | Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria. Learn more |
| Statistical | BINOMDIST | BINOMDIST(number_s, trials, probability_s, cumulative) | Returns the individual term binomial distribution probability. Learn more |
| Statistical | CHISQ.DIST | CHISQ.DIST(number, degrees_freedom, cumulative) | Calculates the left-tailed chi-squared distribution. Learn more |
| Statistical | CHISQ.DIST.RT | CHISQ.DIST.RT(number, degrees_freedom, cumulative) | Calculates the right-tailed chi-squared distribution. Learn more |
| Statistical | CHISQ.INV | CHISQ.INV(probability, degrees_freedom) | Calculates the inverse of the left tailed chi squared distribution. Learn more |
| Statistical | CHISQ.INV.RT | CHISQ.INV.RT(probability, degrees_freedom) | Calculates the inverse of the right tailed chi squared distribution. Learn more |
| Statistical | CONFIDENCE | CONFIDENCE(alpha, standard_deviation, size) | Returns the confidence interval for a population mean, using a normal distribution. Learn more |
| Statistical | CONFIDENCE.NORM | CONFIDENCE.NORM(alpha, standard_deviation, size) | Calculates the width of half the confidence interval for a normal distribution. Learn more |
| Statistical | CONFIDENCE.T | CONFIDENCE.T(alpha, standard_deviation, size) | Calculates the width of half the confidence interval for a Student’s T distribution. 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 | COVARIANCE.P | COVARIANCE.P(array1, array2) | Returns population covariance, the average of the products of deviations for each data point pair in two datasets. Learn more |
| Statistical | COVARIANCE.S | COVARIANCE.S(array1, array2) | Returns the sample covariance, the average of the products of deviations for each data point pair in two datasets. Learn more |
| Statistical | DEVSQ | DEVSQ(value1, [value2, ...]) | Calculates the sum of squares of deviations based on a sample. Learn more |
| Statistical | EXPON.DIST | EXPON.DIST(X, lambda, [cumulative]) | Returns the value of the exponential distribution function with a specified lambda at a specified value. Learn more |
| Statistical | EXPONDIST | EXPONDIST(X, lambda, [cumulative]) | Returns the value of the exponential distribution function with a specified lambda at a specified value. Learn more |
| Statistical | F.DIST | F.DIST(number, degrees_freedom, cumulative) | Calculates the left-tailed F probability distribution for two data sets with given input x. Learn more |
| Statistical | F.DIST.RT | F.DIST.RT(number, degrees_freedom, cumulative) | Calculates the right-tailed F probability distribution for two data sets with given input x. Learn more |
| Statistical | F.INV | F.INV(probability, degrees_freedom1, degrees_freedom2) | Calculates the inverse of the left-tailed F probability distribution. Learn more |
| Statistical | F.INV.RT | F.INV.RT(probability, degrees_freedom1, degrees_freedom2) | Calculates the inverse of the right-tailed F probability distribution. Learn more |
| Statistical | FDIST | FDIST(number, degrees_freedom, cumulative) | Calculates the left-tailed F probability distribution for two data sets with given input x. Learn more |
| Statistical | FDISTRT | FDISTRT(number, degrees_freedom, cumulative) | Calculates the right-tailed F probability distribution for two data sets with given input x. Learn more |
| Statistical | FINV | FINV(probability, degrees_freedom1, degrees_freedom2) | Calculates the inverse of the left-tailed F probability distribution. Learn more |
| Statistical | FINVRT | FINVRT(probability, degrees_freedom1, degrees_freedom2) | Calculates the inverse of the right-tailed F probability distribution. Learn more |
| Statistical | FISHER | FISHER(number) | Returns the Fisher transformation of the specified number. Learn more |
| Statistical | FISHERINV | FISHERINV(number) | Returns the inverse of the Fisher transformation of the specified number. 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 | GAMMA | GAMMA(number) | Returns the gamma function value of a given number. Learn more |
| Statistical | GAMMA.DIST | GAMMA.DIST(number, alpha, beta, cumulative) | Calculates the gamma distribution, a two-parameter continuous probability distribution. Learn more |
| Statistical | GAMMA.INV | GAMMA.INV(probability, alpha, beta) | Returns the value of the inverse gamma cumulative distribution function for the specified probability and alpha and beta parameters. Learn more |
| Statistical | GAMMADIST | GAMMADIST(number, alpha, beta, cumulative) | Calculates the gamma distribution, a two-parameter continuous probability distribution. Learn more |
| Statistical | GAMMAINV | GAMMAINV(probability, alpha, beta) | Returns the value of the inverse gamma cumulative distribution function for the specified probability and alpha and beta parameters. Learn more |
| Statistical | GAMMALN | GAMMALN(number) | Returns the natural logarithm of the gamma function. Learn more |
| Statistical | GAMMALN.PRECISE | GAMMALN.PRECISE(number) | Returns the natural logarithm of the gamma function. Learn more |
| Statistical | GAUSS | GAUSS(number) | Calculates the probability of a standard normal variable falling between the mean and between the mean and z standard deviations from the mean. Learn more |
| Statistical | GEOMEAN | GEOMEAN(value1, [value2, ...]) | Calculates the geometric mean of a dataset. Learn more |
| Statistical | HARMEAN | HARMEAN(value1, [value2, ...]) | Calculates the harmonic mean of a dataset. Learn more |
| Statistical | HYPGEOM.DIST | HYPGEOM.DIST(successes, draws, total_successes, population) | Returns the hypergeometric distribution. Learn more |
| Statistical | HYPGEOMDIST | HYPGEOMDIST(successes, draws, total_successes, population) | Returns the hypergeometric distribution. Learn more |
| Statistical | INTERCEPT | INTERCEPT(data_y, data_x) | Calculates the y-value at which a line will intercept the y-axis by using a linear regression of a dataset of known x-values and y-values. Learn more |
| Statistical | KURT | KURT(value1, [value2, ...]) | Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution. Learn more |
| Statistical | LARGE | LARGE(data, rank) | Returns the Nth largest value in a dataset. Learn more |
| Statistical | LOGNORM.DIST | LOGNORM.DIST(x, mean, standard_deviation) | Returns the value of the lognormal cumulative distribution. Learn more |
| Statistical | LOGNORM.INV | LOGNORM.INV(x, mean, standard_deviation) | Returns the value of the inverse lognormal cumulative distribution. Learn more |
| Statistical | LOGNORMDIST | LOGNORMDIST(x, mean, standard_deviation) | Returns the value of the lognormal cumulative distribution. Learn more |
| Statistical | LOGNORMINV | LOGNORMINV(x, mean, standard_deviation) | Returns the value of the inverse lognormal cumulative distribution. Learn more |
| Statistical | MAX | MAX(value1, [value2, ...]) | Returns the maximum value in a series of numbers and/or cells. Learn more |
| Statistical | MAXA | MAXA(value1, [value2, ...]) | Returns the maximum value in a dataset. Learn more |
| Statistical | MAXIFS | MAXIFS(range, criteria_range1, criteria1, [criteria_range2,...], [criteria2,...]) | Returns the maximum value in a dataset depending on multiple criteria. 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 series of numbers and/or cells. Learn more |
| Statistical | MINA | MINA(value1, [value2, ...]) | Returns the minimum value in a dataset. Learn more |
| Statistical | MINIFS | MINIFS(range, criteria_range1, criteria1, [criteria_range2,...], [criteria2,...]) | Returns the minimum value in a dataset depending on multiple criteria. Learn more |
| Statistical | MODE.MULT | MODE.MULT(value1, [value2, ...]) | Returns the most commonly occurring values in a dataset. Learn more |
| Statistical | MODE.SNGL | MODE.SNGL(value1, [value2, ...]) | Returns the most commonly occurring value in a dataset. Learn more |
| Statistical | MODEMULT | MODEMULT(value1, [value2, ...]) | Returns the most commonly occurring values in a dataset. Learn more |
| Statistical | MODESNGL | MODESNGL(value1, [value2, ...]) | Returns the most commonly occurring value in a dataset. Learn more |
| Statistical | NEGBINOM.DIST | NEGBINOM.DIST(number1, number2, probability) | Returns the negative binomial distribution. Learn more |
| Statistical | NEGBINOMDIST | NEGBINOMDIST(number1, number2, probability) | Returns the negative binomial distribution. Learn more |
| Statistical | NORM.DIST | NORM.DIST(number1, mean, standard_deviation, cumulative) | Returns the normal distribution for the specified mean and standard deviation. Learn more |
| Statistical | NORM.INV | NORM.INV(number, mean, standard_deviation) | Returns the inverse of the normal distribution for the specified mean and standard deviation. Learn more |
| Statistical | NORM.S.DIST | NORM.S.DIST(number) | Returns the standard normal cumulative distribution for the given number. Learn more |
| Statistical | NORM.S.INV | NORM.S.INV(number) | Returns the inverse of the standard normal distribution for the given number. Learn more |
| Statistical | NORMDIST | NORMDIST(number1, mean, standard_deviation, cumulative) | Returns the inverse of the normal distribution for the specified mean and standard deviation. Learn more |
| Statistical | NORMINV | NORMINV(number1, mean, standard_deviation) | Returns the standard normal cumulative distribution for the given number. Learn more |
| Statistical | NORMSDIST | NORMSDIST(number) | Returns the inverse of the standard normal distribution for the given number. Learn more |
| Statistical | NORMSINV | NORMSINV(number) | Returns the normal distribution for the specified mean and standard deviation. Learn more |
| Statistical | PEARSON | PEARSON(data_y, data_x) | Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more |
| Statistical | PERCENTILE | PERCENTILE(range, percentile) | Returns the value at a given percentile of a dataset. Learn more |
| Statistical | PERCENTILE.EXC | PERCENTILE.EXC(range, percentile) | Returns the value at a given percentile of a dataset. Learn more |
| Statistical | PERCENTILE.INC | PERCENTILE.INC(range, percentile) | Returns the value at a given percentile of a dataset. Learn more |
| Statistical | PERCENTILEEXC | PERCENTILEEXC(range, percentile) | Returns the value at a given percentile of a dataset. Learn more |
| Statistical | PERCENTILEINC | PERCENTILEINC(range, percentile) | Returns the value at a given percentile of a dataset. Learn more |
| Statistical | PERCENTRANK.EXC | PERCENTRANK.EXC(range, value, [places]) | Percentage rank from 0 to 1 (exclusive).Learn more |
| Statistical | PERCENTRANKEXC | PERCENTRANKEXC(range, value, [places]) | Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set. Learn more |
| Statistical | PERCENTRANKINC | PERCENTRANKINC(range, value, [places]) | Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set. Learn more |
| Statistical | PERMUT | PERMUT(number1, number2) | Returns the number of permutations to choose some objects from a given number of objects. Learn more |
| Statistical | PERMUTATIONA | PERMUTATIONA(number1, number2) | Returns the number of permutations (including repetitions) to choose some objects from a given number of objects. Learn more |
| Statistical | PHI | PHI(X) | Returns the value of the density function for a standard normal distribution. Learn more |
| Statistical | POISSON.DIST | POISSON.DIST(number, mean, [cumulative]) | Returns the value of the Poisson distribution function or the Poisson cumulative distribution function for a specified number and mean. Learn more |
| Statistical | POISSONDIST | POISSONDIST(number, mean, [cumulative]) | Returns the value of the Poisson distribution function or the Poisson cumulative distribution function for a specified number and mean. Learn more |
| Statistical | PROB | PROB(range, probabilities, lower_limit,[upper_limit]) | Probability that a value falls between two limits. Learn more |
| Statistical | QUARTILE.EXC | QUARTILE.EXC(range, quartile) | Returns the specified quartile of a data set, based on percentile values from 0..1, inclusive. Learn more |
| Statistical | QUARTILE.INC | QUARTILE.INC(range, quartile) | Returns the specified quartile of a data set, based on percentile values from 0..1, inclusive. Learn more |
| Statistical | QUARTILEEXC | QUARTILEEXC(range, quartile) | Returns the specified quartile of a data set, based on percentile values from 0..1, exclusive. Learn more |
| Statistical | QUARTILEINC | QUARTILEINC(range, quartile) | Returns the specified quartile of a data set, based on percentile values from 0..1, exclusive. Learn more |
| Statistical | RANK | RANK(value, data, [order]) | Rank of a value in a dataset.Learn more |
| Statistical | RANK.AVG | RANK.AVG(value, data, [order]) | Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned. Learn more |
| Statistical | RANK.EQ | RANK.EQ(value, data, [order]) | Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned. Learn more |
| Statistical | RANKAVG | RANKAVG(value, data, [order]) | Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned. Learn more |
| Statistical | RANKEQ | RANKEQ(value, data, [order]) | Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned. Learn more |
| Statistical | RSQ | RSQ(data_y, data_x) | Calculates the square of r; where r is the Pearson product-moment correlation coefficient of a dataset. Learn more |
| Statistical | SKEW | SKEW(value1, [value2, ...]) | Returns the skewness of a distribution. Learn more |
| Statistical | SKEW.P | SKEW.P(value1, [value2, ...]) | Returns the skewness of a distribution based on a population. Learn more |
| Statistical | SKEWP | SKEWP(value1, [value2, ...]) | Returns the skewness of a distribution based on a population. 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, rank) | Returns the Nth smallest value in a dataset. Learn more |
| Statistical | STANDARDIZE | STANDARDIZE(number, mean, standard_deviation) | Converts a random variable to a normalized value. Learn more |
| Statistical | STDEV | STDEV(value1, [value2, ...]) | Estimates the standard deviation based on a sample. Learn more |
| Statistical | STDEV.P | STDEV.P(value1, [value2, ...]) | Calculates the standard deviation based on an entire population. Learn more |
| Statistical | STDEV.S | STDEV.S(value1, [value2, ...]) | Estimates the standard deviation based on a sample. Learn more |
| Statistical | STDEVA | STDEVA(value1, [value2, ...]) | Estimates 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 | STDEVS | STDEVS(value1, [value2, ...]) | Estimates the standard deviation based on a sample. Learn more |
| Statistical | STEYX | STEYX(data_y, data_x) | Returns the standard error of the predicted y value for each x in the regression. Learn more |
| Statistical | T.DIST | T.DIST(number, degrees_freedom, mode) | Calculates the probability for Student’s t-distribution for given number. Learn more |
| Statistical | T.DIST.2T | T.DIST.2T(number, degrees_freedom) | Calculates the two-tailed Student's t-distribution for given number. Learn more |
| Statistical | T.DIST.RT | T.DIST.RT(number, degrees_freedom) | Calculates the right-tailed Student's t-distribution for given number. Learn more |
| Statistical | T.INV | T.INV(probability, degrees_freedom) | Calculates the negative inverse of the one-tailed T.DIST function. Learn more |
| Statistical | T.INV.2T | T.INV.2T(probability, degrees_freedom) | Calculates the two-tailed inverse of the Student's t-distribution. Learn more |
| Statistical | TDIST | TDIST(number, degrees_freedom, mode) | Calculates the probability for Student’s t-distribution for given number. Learn more |
| Statistical | TDIST2T | TDIST2T(number, degrees_freedom) | Calculates the two-tailed Student's t-distribution for given number. Learn more |
| Statistical | TDISTRT | TDISTRT(number, degrees_freedom) | Calculates the right-tailed Student's t-distribution for given number. Learn more |
| Statistical | TINV | TINV(probability, degrees_freedom) | Calculates the negative inverse of the one-tailed TDIST function. Learn more |
| Statistical | TINV2T | TINV2T(probability, degrees_freedom) | Calculates the two-tailed inverse of the Student's t-distribution. Learn more |
| Statistical | TRIMMEAN | TRIMMEAN(range, exclude) | Returns the mean of the interior of a dataset. Learn more |
| Statistical | VAR.P | VAR.P(value1, [value2…]) | Calculates variance based on the entire population. It ignores logical values and text in the sample. Learn more |
| Statistical | VAR.S | VAR.S(value1, [value2…]) | Estimates variance based on a sample. It ignores logical values and text in the sample. Learn more |
| Statistical | VARA | VARA(value1, [value2…]) | Estimates variance based on a sample. Text and logical values are included in the calculation. Learn more |
| Statistical | VARP | VARP(value1, [value2,…]) | Calculates variance based on the entire population. It ignores logical values and text in the sample. Learn more |
| Statistical | VARPA | VARPA(value1, [value2, ...]) | Calculates the variance based on the entire population. Text and logical values are included in the calculation. Learn more |
| Statistical | VARS | VARS(value1, [value2…]) | Estimates variance based on a sample. It ignores logical values and text in the sample. Learn more |
| Statistical | WEIBULL.DIST | WEIBULL.DIST(number, alpha, beta, cumulative) | Returns the values of the Weibull distribution for the given number. Learn more |
| Statistical | WEIBULLDIST | WEIBULLDIST(number, alpha, beta, cumulative) | Returns the values of the Weibull distribution for the given number. Learn more |
| Text | ARABIC | ARABIC(value) | Converts a Roman number into an Arabic number. Learn more |
| Text | CHAR | CHAR(value) | Coverts a number into a character specified by the current Unicode table. Learn more |
| Text | CLEAN | CLEAN(text) | Removes all non-printing characters from the string. Learn more |
| Text | CODE | CODE(text) | Returns the numeric Unicode map value of the first character of the string. Learn more |
| Text | CONCAT | CONCAT(text_1, text_2) | Combines two text strings. Learn more |
| Text | CONCATENATE | CONCATENATE(text_1, [text_2, ...]) | Combines several text strings into one text string. Learn more |
| Text | EXACT | EXACT(string1, string2) | Tests if two strings are identical. Returns TRUE if the strings are identical. Learn more |
| Text | FIND | FIND(search_for, text, start_at) | Finds position of string in text. Returns the position at which a string is first found within text. Learn more |
| Text | FORMULATEXT | FORMULATEXT(cell_reference) | Returns formula expression as text. It returns an error if the cell reference does not contain a formula. Learn more |
| Text | HTML2TEXT | HTML2TEXT(text) | Removes HTML and formatting elements from string, and returns as plain text. Learn more |
| Text | JOIN | JOIN(delimiter, array_1, [array_2, ...]) | Combines the elements of one or more one-dimensional arrays using a specified delimiter. Learn more |
| Text | LEFT | LEFT(text, [number]) | Returns the leftmost characters of a string. Learn more |
| Text | LEN | LEN(text) | Returns the length of a string, including spaces. Learn more |
| Text | LOWER | LOWER(text) | Converts the specified string to lower case. Learn more |
| Text | MID | MID(text, start_at, length) | Returns a segment of a string. Learn more |
| Text | NUMBERS | NUMBERS(range) | Returns only numbers from a range.Learn more |
| Text | PROPER | PROPER(text) | Capitalizes the first letter in all the words of a text string. Learn more |
| Text | REGEXEXTRACT | REGEXEXTRACT(text, regular_expression) | Extracts matching substrings according to a regular expression. Learn more |
| Text | REGEXMATCH | REGEXMATCH(text, regular_expression) | Checks whether a piece of text matches a regular expression. Learn more |
| Text | REGEXREPLACE | REGEXREPLACE(text, regular_expression, replacement) | Replaces part of a text string with a different text string using regular expressions. Learn more |
| Text | REPLACE | REPLACE(text, position, length, new_text) | Replaces characters within a text string. Learn more |
| Text | REPT | REPT(text, [number]) | Repeats a character string by the given number of copies. Learn more |
| Text | RIGHT | RIGHT(text, [number]) | Returns the rightmost characters of a string. Learn more |
| Text | ROMAN | ROMAN(number, [mode]) | Converts a number into a Roman numeral. Learn more |
| Text | SEARCH | SEARCH(search_for, text, start_at) | Finds position of string in text. Returns the position at which a string is first found within text. Learn more |
| Text | SPLIT | SPLIT(text, delimiter, [split_each], [remove_empty]) | Splits text using delimiter(s). Splits text into separate cells. Learn more |
| Text | SUBSTITUTE | SUBSTITUTE(value, old_text, new_text, [occurrence]) | Substitutes new text for old text in a string. Learn more |
| Text | T | T(value) | Returns string arguments as text. Returns a blank text string where the argument is a number. Learn more |
| Text | TEXT | TEXT(number, format) | Formats a number and converts it to text. Learn more |
| text | TEXTJOIN | 'TEXTJOIN(delimiter, array_1, [array_2, ...]) | Combines text from multiple strings.Learn more |
| Text | TRIM | TRIM(text) | Removes the spaces that are in front of a string, or aligns the cell contents to the left. Learn more |
| Text | UNICHAR | UNICHAR(number) | Returns the Unicode character of a number that is referenced by the given numeric value. Learn more |
| Text | UNICODE | UNICODE(text) | Returns the number that corresponds to the first character of the text. Learn more |
| Text | UPPER | UPPER(text) | Converts the specified string to upper case. Learn more |
| Text | VALUE | VALUE(text) | Converts text into a number, including converting formatted strings like date or date-time. Learn more |
| Web | HYPERLINK | HYPERLINK(url, [label]) | Creates a hyperlink inside a cell. Learn more |