Spreadsheet.com function list

  • Updated

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