Spreadsheet Functions
Functions in Row Zero are compatible with Excel and Google Sheets. Most popular spreadsheet functions are supported.
If the function you need isn't listed here, send us a request and we'll explore adding it. You can also use the Python code window to create custom spreadsheet functions.
| Function | Description |
|---|---|
| ABS | Compute the absolute value of a number |
| ACCRINT | Returns the accrued interest for a security that pays periodic interest |
| ACCRINTM | Returns the accrued interest at maturity for a security that pays interest at maturity |
| ACOS | Compute the arccosine of a number, returning an angle in radians |
| ACOSH | Compute the inverse hyperbolic cosine of a number |
| ACOT | Returns the arccotangent (inverse cotangent) of a number in radians. |
| ACOTH | Returns the inverse hyperbolic cotangent of a number. |
| ADD | Adds two numeric values (x+y) |
| AMORLINC | Returns the depreciation for each accounting period using a linear method |
| AND | Returns TRUE if all of the values are TRUE, and FALSE otherwise. |
| ARABIC | Converts a Roman numeral to an Arabic numeral |
| ARRAY | Creates a range from a datatable |
| ARRAYFORMULA | Allow array formulas to return multiple values |
| ASIN | Compute the arcsine of a number, returning an angle in radians |
| ASINH | Compute the inverse hyperbolic sine of a number |
| ATAN | Compute the arctangent of a number, returning an angle in radians |
| ATAN2 | Compute the arctangent of the given x and y coordinates, returning an angle in radians between PI and -PI, excluding -PI |
| ATANH | Compute the inverse hyperbolic tangent of a number |
| AVEDEV | Calculates the average of the absolute deviations of the given values from their mean |
| AVERAGE | Calculates the average (arithmetic mean) of the given values |
| AVERAGEIF | Calculates the average (arithmetic mean) of all values in a range that meet a criterion |
| AVERAGEIFS | Calculates the average (arithmetic mean) of all values that meet multiple criteria |
| BAHTTEXT | Converts a number to Thai text and adds a suffix of "Baht" |
| BASE | Converts a number into a text representation with the given radix (base) |
| BESSELI | Returns the modified Bessel function of the first kind |
| BESSELJ | Returns the Bessel function of the first kind |
| BESSELK | Returns the modified Bessel function of the second kind |
| BESSELY | Returns the Bessel function of the second kind |
| BETA.DIST | Returns the beta distribution. |
| BETA.INV | Returns the inverse of the beta cumulative distribution. |
| BETADIST | Legacy compatibility form of BETA.DIST. |
| BIN2DEC | Converts a binary number to decimal |
| BIN2HEX | Converts a binary number to hexadecimal |
| BIN2OCT | Converts a binary number to octal |
| BINOM.DIST | Returns the individual term binomial distribution probability |
| BINOM.DIST.RANGE | Returns the probability of a trial result using a binomial distribution |
| BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value |
| BITAND | Returns a bitwise AND of two numbers |
| BITLSHIFT | Returns a number shifted left by the specified number of bits |
| BITOR | Returns a bitwise OR of two numbers |
| BITRSHIFT | Returns a number shifted right by the specified number of bits |
| BITXOR | Returns a bitwise XOR of two numbers |
| BUCKETCOUNT | Bucketizes data into a specified number of equally-sized buckets. Non-numeric values are ignored. |
| BUCKETSIZE | Bucketizes data into a buckets of specified size. Non-numeric values are ignored. |
| CEILING | Rounds a number up to the nearest multiple of a specified factor |
| CEILING.MATH | Rounds a number up to the nearest integer or multiple of significance |
| CEILING.PRECISE | Rounds a number up to the nearest multiple of significance |
| CHAR | Returns the character specified by a number |
| CHISQ.DIST | Returns the chi-squared distribution |
| CHISQ.DIST.RT | Returns the right-tailed probability of the chi-squared distribution |
| CHISQ.INV | Returns the inverse of the left-tailed probability of the chi-squared distribution |
| CHISQ.INV.RT | Returns the inverse of the right-tailed probability of the chi-squared distribution |
| CHOOSE | Returns the value at the specified position in a list of values |
| CLEAN | Removes nonprintable characters from text |
| CODE | Returns the numeric code for the first character in the text. |
| COLUMN | Returns the column number of the cell containing the formula. If given a reference, returns the column number of the reference. |
| COLUMNS | Compute the number of columns in a range |
| COMBIN | Returns the number of combinations for a given number of items. |
| COMBINA | Returns the number of combinations with repetitions for a given number of items. |
| CONCAT | Concatenates a list of values into a single text value |
| CONFIDENCE.NORM | Returns the confidence interval for a population mean using a normal distribution. |
| CONFIDENCE.T | Returns the confidence interval for a population mean using a t distribution. |
| CONVERT | Converts a number from one measurement unit to another |
| COS | Compute the cosine of an angle in radians |
| COSH | Returns the hyperbolic cosine of a number |
| COT | Returns the cotangent of an angle specified in radians. |
| COTH | Returns the hyperbolic cotangent of a number. |
| COUNT | Counts the number of non-empty numeric or temporal values |
| COUNTA | Counts the number of non-empty values |
| COUNTBLANK | Counts the number of empty cells in a range |
| COUNTIF | Counts the number of cells within a range that meet a criterion |
| COUNTIFS | Counts the number of cells within a range that meet multiple criteria |
| COUNTUNIQUE | Counts the number of unique values in a range |
| COUNTUNIQUEIFS | Counts the number of unique values in a range that meet multiple criteria |
| COUPDAYS | Returns the number of days in the coupon period that contains the settlement date |
| COUPDAYSNC | Returns the number of days from the settlement date to the next coupon date |
| COUPNCD | Returns the next coupon date after the settlement date |
| COUPNUM | Returns the number of coupons payable between the settlement and maturity dates |
| COUPPCD | Returns the previous coupon date before the settlement date |
| CSC | Returns the cosecant of an angle specified in radians. |
| CSCH | Returns the hyperbolic cosecant of a number. |
| CUMIPMT | Returns the cumulative interest paid between two periods |
| CUMPRINC | Returns the cumulative principal paid between two periods |
| DATATABLE | Creates a data table |
| DATE | Create a date from its components |
| DATEDIF | Returns the difference between two dates in the requested units |
| DATEPART | Extract the date part of a datetime |
| DATEVALUE | Converts a date in text format to a date value |
| DAY | Returns the numeric (1-31) day of the month |
| DAYS | Returns the number of days between two dates |
| DAYS360 | Returns the number of days between two dates based on a 360-day year (12 30-day months) |
| DB | Returns the depreciation of an asset for a specified period using the fixed-declining balance method |
| DDB | Returns the depreciation of an asset for a specified period using the double-declining balance method |
| DEC2BIN | Converts a decimal number to binary |
| DEC2HEX | Converts a decimal number to hexadecimal |
| DEC2OCT | Converts a decimal number to octal |
| DECIMAL | Converts a text representation of a number in a given base into a decimal number |
| DEGREES | Convert an angle from radians to degrees |
| DELTA | Tests whether two values are equal. |
| DISC | Returns the discount rate for a security |
| DIVIDE | Divides the first numeric value by the second (x/y) |
| DOLLARDE | Converts a fractional dollar amount to a decimal dollar amount |
| DOLLARFR | Converts a decimal dollar amount to a fractional dollar amount |
| EDATE | Returns a date some number of months before or after a given date |
| EFFECT | Returns the effective annual interest rate from a nominal rate and compounding periods |
| EOMONTH | Returns the last day of the month a number of months before or after a given date |
| ERF | Returns the error function value |
| ERF.PRECISE | Returns the error function value using a precise algorithm |
| ERFC | Returns the complementary error function value |
| ERROR.TYPE | Returns a number corresponding to an error type |
| EVEN | Rounds a number up to the nearest even integer |
| EXACT | Compare two strings for exact, case-sensitive equality |
| EXP | Compute e to the power of a number (e^x) |
| EXPON.DIST | Returns the exponential distribution. |
| EXTRACTCOLUMNNAME | Returns the column name of a column as text |
| F.DIST | Returns the F probability distribution |
| F.DIST.RT | Returns the right-tailed F probability distribution |
| F.INV | Returns the inverse of the F probability distribution |
| F.INV.RT | Returns the inverse of the right-tailed F probability distribution |
| FACT | Returns the factorial of a number |
| FACTDOUBLE | Returns the double factorial of a number |
| FALSE | Returns the logical value FALSE |
| FILTER | Filters a range based on a condition |
| FIND | Finds one text value within another (case-sensitive) and returns the position of the found text (starting at 1) |
| FISHER | Returns the Fisher transformation. |
| FISHERINV | Returns the inverse Fisher transformation. |
| FIXED | Rounds a number and returns it as text with optional commas |
| FLATTEN | Flattens the values from one or more ranges in row-major order into a single column |
| FLOOR | Rounds a number down to the nearest multiple of a specified factor |
| FLOOR.MATH | Rounds a number down to the nearest integer or multiple of significance |
| FLOOR.PRECISE | Rounds a number down to the nearest multiple of significance |
| FORECAST | Predicts a y value at a given x using linear regression on known data points |
| FREQUENCY | Calculates how often values occur within a range of values. Non-numeric values are ignored. |
| FV | Returns the future value of an investment |
| GAMMA | Returns the gamma function value. |
| GAMMA.DIST | Returns the gamma distribution. |
| GAMMA.INV | Returns the inverse gamma cumulative distribution. |
| GAMMALN | Returns the natural log of the gamma function. |
| GAMMALN.PRECISE | Returns the natural log of the gamma function. |
| GAUSS | Returns the probability that a standard normal variable lies between 0 and z. |
| GCD | Returns the greatest common divisor of two or more integers |
| GESTEP | Tests whether a number is greater than or equal to a threshold value. |
| GLUE | Concatenates a list of values into a single text value with a delimiter between each value |
| HEX2BIN | Converts a hexadecimal number to binary |
| HEX2DEC | Converts a hexadecimal number to decimal |
| HEX2OCT | Converts a hexadecimal number to octal |
| HISTOGRAM | Compute the unique values from a specified range and how many times each value appears |
| HOUR | Returns the hour (0-23) of a time |
| HSTACK | Stacks multiple ranges horizontally |
| HYPGEOM.DIST | Returns the hypergeometric distribution. |
| HYPGEOMDIST | Legacy compatibility form of HYPGEOM.DIST. |
| IF | Return the first value if the condition is TRUE and the second value if the condition is FALSE |
| IFERROR | Returns the first argument if it is not an error, otherwise returns the second argument |
| IFNA | Returns the first argument if it is not #N/A, otherwise returns the second argument |
| IFS | Return the first value for which the condition is TRUE |
| IMPORTRANGE | Imports data from a range in another workbook |
| INDEX | Return the value from a range at the given row and column |
| INT | Converts a number to an integer by rounding down, and parses strings into integers |
| INTRATE | Returns the interest rate for a fully invested security |
| IPMT | Returns the interest component of a payment for a specific period |
| IRR | Returns the internal rate of return for a series of cash flows |
| ISBLANK | Returns true if the value is blank, otherwise returns false |
| ISERR | Returns true if the value is an error (excluding #N/A), otherwise returns false |
| ISERROR | Returns true if the value is an error, otherwise returns false |
| ISEVEN | Returns TRUE if number is even, or FALSE if number is odd. |
| ISLOGICAL | Returns TRUE if the value is a logical value (TRUE or FALSE), or FALSE otherwise. |
| ISNA | Returns true if the value is an #N/A error, otherwise returns false |
| ISNONTEXT | Returns TRUE if the value is not text, or FALSE otherwise. |
| ISNUMBER | Returns TRUE if the value is a number, a date, or a time value. Returns FALSE otherwise. |
| ISO.CEILING | Rounds a number up to the nearest multiple of significance |
| ISODD | Returns TRUE if number is odd, or FALSE if number is even. |
| ISOWEEKNUM | Returns the ISO week number of a date |
| ISOYEAR | Returns the ISO week-numbering year for a date |
| ISPMT | Returns the interest payment for a specific period of an investment with even principal payments |
| ISREF | Returns TRUE if the argument is a reference |
| ISTEXT | Returns TRUE if the value is text, or FALSE otherwise. |
| JSONEXTRACT | Extracts a from a JSON object based on a hierarchical field path |
| KIND | Returns the kind of value as text |
| LARGE | Compute the nth largest value in a range |
| LCM | Returns the least common multiple of two or more integers |
| LEFT | Returns the first N characters from some text |
| LEN | Compute the number of characters in a value |
| LINEST | Fits a linear regression and returns coefficients with optional statistics |
| LN | Compute the natural logarithm of a positive number |
| LOG | Compute the logarithm of a number to a specified base |
| LOG10 | Returns the base-10 logarithm of a number |
| LOGNORM.DIST | Returns the log-normal cumulative distribution function or probability density function |
| LOGNORM.INV | Returns the inverse of the lognormal cumulative distribution function |
| LOWER | Converts text to lowercase |
| MAKEERROR | Creates an error value |
| MATCH | Compute the row index of a value in a range |
| MAX | Compute the largest numeric or temporal value |
| MAXIFS | Returns the maximum value in a range that meets multiple criteria |
| MDURATION | Returns the modified Macaulay duration of a security with an assumed par value of 100 |
| MEDIAN | Compute the median of the given values |
| MID | Returns the specified number of characters from some text starting at the specified position |
| MIN | Compute the smallest numeric or temporal value |
| MINIFS | Returns the minimum value in a range that meets multiple criteria |
| MINUS | Subtracts the second numeric value from the first (x-y) |
| MINUTE | Returns the minute (0-59) of a time |
| MOD | Returns the remainder of a division |
| MODE | Returns the most common number in the given values |
| MONTH | Returns the month (1-12) of a date |
| MROUND | Rounds a number to the nearest specified multiple |
| MULTILOOKUP | Return the first row from the return range where all the keys match the specified values in the key ranges |
| MULTIPLY | Multiplies two numeric values (x*y) |
| N | Converts a value to a number |
| NA | Returns the #N/A error |
| NEGBINOM.DIST | Returns the negative binomial distribution. |
| NEGBINOMDIST | Legacy compatibility form of NEGBINOM.DIST. |
| NETWORKDAYS | Returns the number of whole workdays between two dates |
| NETWORKDAYS.INTL | Returns the number of whole workdays between two dates with custom weekend parameters |
| NOMINAL | Returns the nominal annual interest rate from an effective rate and compounding periods |
| NORM.DIST | Returns the normal distribution for the specified mean and standard deviation |
| NORM.INV | Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation |
| NORM.S.DIST | Returns the standard normal distribution (with mean of 0 and standard deviation of 1) |
| NORM.S.INV | Returns the inverse of the standard normal cumulative distribution (with mean of 0 and standard deviation of 1) |
| NOT | Reverses the logical value of its argument. Returns TRUE if the argument is FALSE and returns FALSE if the argument is TRUE. |
| NOW | Returns the current date and time in the timezone configured in workbook settings |
| NPER | Returns the number of periods needed for payments to reach a goal |
| NPV | Returns the net present value of an investment |
| NUMBERVALUE | Parses text into a number |
| OBJECT | Creates a JSON object |
| OCT2BIN | Converts an octal number to binary |
| OCT2DEC | Converts an octal number to decimal |
| OCT2HEX | Converts an octal number to hexadecimal |
| ODD | Rounds a number up to the nearest odd integer |
| ODDFPRICE | Returns the price per $100 face value of a security with an odd first coupon period |
| ODDFYIELD | Returns the yield of a security with an odd first coupon period |
| ODDLPRICE | Returns the price per $100 face value of a security with an odd last coupon period |
| ODDLYIELD | Returns the yield of a security with an odd last coupon period |
| OR | Returns TRUE if any of the values are TRUE, and FALSE otherwise. |
| PARSE | Parses text into a value, as if it were typed into a cell |
| PDURATION | Returns the number of periods required for an investment to reach a specified future value |
| PERCENTILE | Compute the specified percentile of the given values |
| PERMUT | Returns the number of permutations for a given number of objects. |
| PERMUTATIONA | Returns the number of permutations for a given number of objects (with repetition allowed). |
| PHI | Returns the standard normal probability density function. |
| PI | The constant pi (π) |
| PMT | Returns the payment for an annuity |
| POISSON.DIST | Returns the Poisson distribution. |
| POWER | Compute the result of a number raised to a power (x^y) |
| PPMT | Returns the principal component of a payment for a specific period |
| PRICEDISC | Returns the price per $100 face value of a discounted security |
| PRICEMAT | Returns the price per $100 face value of a security that pays interest at maturity |
| PRODUCT | Computes the product of the numeric values |
| PROPER | Capitalizes the first letter in a text and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters |
| PV | Returns the present value of an investment |
| QUARTILE | Returns the quartile of a dataset |
| QUOTIENT | Returns the integer portion of a division |
| RADIANS | Convert an angle from degrees to radians |
| RAND | Returns a random number between 0 (inclusive) and 1 (exclusive) |
| RANDARRAY | Returns an array of random numbers between the specified minimum and maximum values |
| RANDBETWEEN | Returns a random number between the specified minimum and maximum values |
| RANK | Compute the rank of a number in a range |
| RANK.EQ | Compute the rank of a number in a range |
| RATE | Returns the interest rate per period of an annuity |
| RECEIVED | Returns the amount received at maturity for a fully invested security |
| REGEXEXTRACT | Extracts text based on a supplied regular expression |
| REGEXREPLACE | Replaces text based on a supplied regular expression |
| REGEXTEST | Tests if a text matches a regular expression |
| REPLACE | Replaces part of a text with another text |
| REPT | Repeats text a given number of times. |
| RIGHT | Returns the last N characters in some text |
| ROMAN | Converts an Arabic numeral to Roman, as text |
| ROUND | Rounds a number to a specified number of digits |
| ROUNDDOWN | Rounds a number down towards zero to a specified number of digits |
| ROUNDUP | Rounds a number up away from zero to a specified number of digits |
| ROW | Returns the row number of the cell containing the formula, or the row in the data table column. If given a reference, returns the row number of the reference. |
| ROWS | Compute the number of rows in a range |
| RRI | Returns the equivalent interest rate for an investment over a number of periods. |
| SEARCH | Finds one text value within another (case-insensitive) and returns the position of the found text (starting at 1) |
| SEC | Returns the secant of an angle specified in radians. |
| SECH | Returns the hyperbolic secant of a number. |
| SECOND | Returns the second (0-59) of a time |
| SECONDS | Converts a number of seconds into a duration value |
| SELECTCOLUMNS | Selects columns from a data table to form a new data table |
| SEQUENCE | Returns an array of sequential numbers |
| SIGN | Determines the sign of a number: returns 1 if positive, 0 if zero, and -1 if negative |
| SIN | Compute the sine of an angle in radians |
| SINH | Returns the hyperbolic sine of a number |
| SLN | Returns the straight-line depreciation of an asset for one period |
| SLOPE | Returns the slope of the linear regression line through known data points |
| SMALL | Compute the nth smallest value in a range |
| SMARTSAMPLE | Samples a specified number of (x1, x2, ... xN) tuples from the given columns or ranges, making an effort to retain outliers. This is useful for any visual inspection of large datasets and things like scatter plots. |
| SORT | Sorts the contents of a range |
| SORTBY | Sorts the contents of a range or array based on values in a corresponding range or array |
| SQRT | Compute the square root of a number |
| SQRTPI | Returns the square root of (number * pi) |
| STANDARDIZE | Returns a normalized value (z-score). |
| STDEV | Compute sample standard deviation of the given values (divides by n-1) |
| STDEV.P | Compute population standard deviation of the given values (divides by n) |
| STDEV.S | Compute sample standard deviation of the given values (divides by n-1) |
| SUBSTITUTE | Replaces occurrences of a specified substring within text with another substring |
| SUBTOTAL | Computes a subtotal for a range using a specified function number |
| SUM | Computes a sum of the numeric values |
| SUMIF | Sums the values in a range that meet a criterion |
| SUMIFS | Sums the values in a range that meet multiple criteria |
| SUMPRODUCT | Compute the sum of the product of corresponding values in the given ranges |
| SWITCH | Match an expression against a list of values and return the corresponding result |
| SYD | Returns the sum-of-years' digits depreciation of an asset for a specified period |
| T | Returns the value if it is text; otherwise returns empty text |
| T.DIST | Returns the Student's t-distribution |
| T.DIST.2T | Returns the two-tailed Student's t-distribution |
| T.DIST.RT | Returns the right-tailed probability of Student's t-distribution. |
| T.INV | Returns the left-tailed inverse of the Student's t-distribution |
| T.INV.2T | Returns the two-tailed inverse of the Student's t-distribution |
| T.TEST | Returns the probability associated with a Student's t-test |
| TAN | Compute the tangent of an angle in radians |
| TANH | Returns the hyperbolic tangent of a number |
| TBILLEQ | Returns the bond-equivalent yield for a treasury bill |
| TBILLPRICE | Returns the price per $100 face value for a Treasury bill |
| TBILLYIELD | Returns the yield for a Treasury bill |
| TDIST | Legacy compatibility form of Student's t-distribution probability. |
| TEXT | Formats a value as text according to the format pattern |
| TEXTAFTER | Returns text that occurs after a given delimiter |
| TEXTBEFORE | Returns text that occurs before a given delimiter |
| TEXTJOIN | Concatenates a list of values into a single text value, with a specified delimiter |
| TEXTSPLIT | Splits text into an array of substrings based on a delimiter |
| TIME | Create a time value from hour, minute, and second components |
| TIMEPART | Extract the time part of a datetime |
| TIMEVALUE | Converts a time in text format to a time value |
| TODAY | Returns the current date in the timezone configured in workbook settings |
| TRANSPOSE | Transposes a range |
| TRIM | Removes all spaces from text except for single spaces between words |
| TRUE | Returns the logical value TRUE |
| TRUNC | Truncates a number to an integer by removing the fractional part |
| TYPE | Returns a number that identifies the type of a value. |
| TYPEDUNIQUE | Compute a list of unique values from a specified range |
| UNICHAR | Returns the Unicode character for the given numeric value. |
| UNICODE | Returns the Unicode number for the first character of the text. |
| UNIQUE | Compute a list of unique rows or columns from a specified range |
| UPPER | Converts text to uppercase |
| VALUE | Parses text into a number |
| VAR | Compute sample variance of the given values (divides by n-1) |
| VAR.P | Compute population variance of the given values (divides by n) |
| VAR.S | Compute sample variance of the given values (divides by n-1) |
| VDB | Returns the depreciation of an asset for a specified period using a declining balance method |
| VLOOKUP | Searches for a value in the first column the given range and returns the value in the same row from the specified column |
| VSTACK | Stacks multiple ranges vertically |
| WEEKDAY | Returns the weekday for a date |
| WEEKNUM | Returns the week number of a date |
| WEIBULL.DIST | Returns the Weibull distribution |
| WILDCARDESCAPE | Transforms text so the wildcard characters ? and * no long trigger the pattern matcher |
| WORKDAY | Returns a date that is the specified number of working days before or after a date |
| WORKDAY.INTL | Returns a date that is the specified number of working days before or after a date with custom weekend parameters |
| XIRR | Returns the internal rate of return for a schedule of cash flows that are not necessarily periodic. |
| XLOOKUP | Search for a value in the lookup range and return the corresponding value from the return range |
| XMATCH | Compute the position of a value in a range |
| XNPV | Returns the net present value of an investment based on a specified date |
| XOR | Returns TRUE if an odd number of values are TRUE, and FALSE otherwise. |
| YEAR | Returns the year of a date value |
| YEARFRAC | Returns the fraction of a year between two dates |
| YIELDMAT | Returns the annual yield of a security that pays interest at maturity |