# Ants & Apps functions reference

Or browser by category:

- Array & List Functions
- Data Functions
- Database Functions
- Date & Time Functions
- Encryption Functions
- Engineering Functions
- Excel Formulas
- Financial Functions
- Formatting Functions
- GEO Data Functions
- HTML Processing Functions
- HTTP Functions
- Information Functions
- JSON Functions
- Logical Functions
- Lookup & Reference Functions
- Math & Trigonometry Functions
- Number Functions
- Parsing Functions
- Regular Expression Functions
- Statistical Functions
- Text Functions
- Text & Data Functions
- Web Functions

Ants & Apps supports Google Sheets / Excel-like functions as well as some programming and proprietary Ants & Apps ones. Functions can be used to create formulas that manipulate data (including lists and arrays), calculate numbers and strings.

Here is a list of all Ants & Apps functions available in each category. Please remember to add quotation marks around all function components made of alphabetic characters that aren't refeering to cells or columns.

- AGGREGATE
Returns an aggregate in a list or database

- ATAN2
The ATAN2 function returns the angle between the x-axis and a line segment from the origin (0,0) to the specified coordinate pair (`x`,`y`), in radians.

- BASE
Converts a number into a text representation with the given radix (base)

- BESSELK
Calculates the modified Bessel functions. Kn(x), which are also known as the hyperbolic Bessel Functions

- BESSELY
Returns the Bessel function, Yn(x), (also known as the Weber function or the Neumann function), for a specified order and value of x.

- CEILING
The CEILING function rounds a number up to the nearest integer multiple of specified significance.

- CEILING_MATH
Rounds a number up, to the nearest integer or to the nearest multiple of significance

- CEILING_PRECISE
Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.

- COMBIN
The COMBIN function returns the number of ways to choose some number of objects from a pool of a given size of objects.

- COMBINA
Returns the number of combinations with repetitions for a given number of items

- DECIMAL
Converts a text representation of a number in a given base into a decimal number

- FLOOR
The FLOOR function rounds a number down to the nearest integer multiple of specified significance.

- FLOOR_MATH
Rounds a number down, to the nearest integer or to the nearest multiple of significance

- FLOOR_PRECISE
Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.

- GT
Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator.

- GTE
Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator.

- ISO_CEILING
Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance

- LT
Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator.

- LTE
Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator.

- MINVERSE
Returns the multiplicative inverse of a square matrix specified as an array or range.

- MULTINOMIAL
Returns the factorial of the sum of values divided by the product of the values' factorials.

- MUNIT
Returns the unit matrix or the specified dimension

- RANDARRAY
Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.

- ROUND
The ROUND function rounds a number to a certain number of decimal places according to standard rules.

- ROUNDDOWN
The ROUNDDOWN function rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

- ROUNDUP
Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

- SERIESSUM
Given parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range `a`.

- SIGN
Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.

- SUBTOTAL
Returns a subtotal for a vertical range of variables using a specified aggregation function.

- SUMPRODUCT
The SUMPRODUCT function calculates the sum of the products of corresponding entries in 2 equally sized arrays or ranges.

- TRUNC
Truncates a number to a certain number of significant digits by omitting less significant digits.

- AMORDEGRC
Returns the depreciation for a given accounting using a depreciation coefficient determined by asset life.

- AMORLINC
The AMORLINC function returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.This function is available for users of the French accounting system.

- COUPDAYBS
Calculates the number of days from the first coupon, or interest payment, until settlement.

- COUPDAYS
Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.

- COUPDAYSNC
Calculates the number of days from the settlement date until the next coupon, or interest payment.

- COUPNUM
Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.

- CUMIPMT
Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

- CUMPRINC
Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

- DB
The DB function calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.

- DDB
The DDB function calculates the depreciation of an asset for a specified period using the double-declining balance method.

- DURATION
Returns the annual duration of a security with periodic interest payments

- EFFECT
Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.

- FV
The FV function calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

- FVSCHEDULE
The FVSCHEDULE function calculates the future value of some principal based on a specified series of potentially varying interest rates.

- INTRATE
Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself.

- IPMT
The IPMT function calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.

- IRR
Calculates the internal rate of return on an investment based on a series of periodic cash flows.

- ISPMT
The ISPMT function calculates the interest paid during a particular period of an investment.

- MDURATION
Returns the Macauley modified duration for a security with an assumed par value of $100

- MIRR
Calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income.

- NOMINAL
Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.

- NPER
The NPER function calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

- NPV
Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.

- ODDFPRICE
Returns the price per $100 face value of a security with an odd first period

- ODDFYIELD
Returns the yield of a security with an odd first period

- ODDLPRICE
Returns the price per $100 face value of a security with an odd last period

- ODDLYIELD
Returns the yield of a security with an odd last period

- PDURATION
The PDURATION function returns the number of periods for an investment to reach a specific value at a given rate. Mathematically, PDURATION = (log(futureValue) - log (currentValue))/(log(1 + rate)).

- PMT
The PMT function calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.

- PPMT
The PPMT function calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.

- PRICE
Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.

- PRICEDISC
Calculates the price of a discount (non-interest-bearing) security, based on expected yield.

- PRICEMAT
Calculates the price of a security paying interest at maturity, based on expected yield.

- PV
Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

- RATE
Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate.

- RECEIVED
Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date.

- RRI
The RRI function returns the interest rate needed for an investment to reach a specific value within a given number of periods.

- SLN
The SLN function calculates the depreciation of an asset for one period using the straight-line method.

- SYD
The SYD function calculates the depreciation of an asset for a specified period using the sum of years digits method.

- TBILLEQ
Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.

- VDB
Returns the depreciation of an asset for a specified or partial period by using a declining balance method

- XIRR
Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows.

- XNPV
Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate.

- YIELD
Returns the yield on a security that pays periodic interest

- YIELDDISC
Calculates the annual yield of a discount (non-interest-bearing) security, based on price.

- YIELDMAT
The YIELDMAT function calculates the annual yield of a security paying interest at maturity, based on price.

- ARRAY_REPLACE_RECURSIVE
Replaces elements from passed arrays into the first array recursively

- ARRAY_SEARCH
Searches the array for a given value and returns the first corresponding key if successful

- FLATTEN
Creates a new array with all sub-array elements concatenated into it recursively up to the specified depth.

- ASC
Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters

- BAHTTEXT
Converts a number to text, using the ß (baht) currency format

- CONTAINS
Determines whether a string contains the characters of a specified string. Case sensitive

- DBCS
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters

- IF_TEXT_MATCH
Determines whether a string contains the characters of a specified string. Case sensitive

- INCLUDES
Determines whether a string contains the characters of a specified string. Case sensitive

- JIS
Changes half-width (single-byte) characters within a string to full-width (double-byte) characters

- LASTINDEXOF
Returns the position of the last occurrence of a specified value in a string or last element index in array

- MB_STRTOLOWER
Make a string lowercase. Returns string with all alphabetic characters converted to lowercase.

- MB_STRTOUPPER
Make a string uppercase. Returns string with all alphabetic characters converted to uppercase.

- PHONETIC
Extracts the phonetic (furigana) characters from a text string

- PLURALIZE
Transforms all words into plural (EN, RU). (cookie - cookies, man - men, potato - potatoes)

- REPEAT
Returns a new string with a specified number of copies of the string it was called on.

- SINGULARIZE
Transforms all words into singular (EN, RU). (cookies - cookie, men - man, potatoes - potato)

- SPLIT_TEXT
Splits the text by specific character or a word. Returns a specified part by index, starting from 0

- STARTCASE
Make a string uppercase. Returns string with all alphabetic characters converted to uppercase.

- STR_IREPLACE
Case-insensitive Replace all occurrences of the search string with the replacement string

- STRIPOS
Find the position of the first occurrence of a case-insensitive substring in a string

- STRRIPOS
Find the position of the last occurrence of a case-insensitive substring in a string

- STRSPN
Finds the length of the initial segment of a string consisting entirely of characters contained within a given mask

- SUBSTRING
Extracts the characters from a string, between two specified indices, and returns the new sub string

- DAYS360
Returns the difference between two days based on the 360-day year used in some financial interest calculations.

- EOMONTH
Returns a date representing the last day of a month which falls a specified number of months before or after another date.

- ISOWEEKNUM
Returns the number of the ISO (International Organization for Standardization) week of the year where the provided date falls.

- NETWORKDAYS_INTL
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days

- SETFULLYEAR
Set the year (four digits for dates between year 1000 and 9999) of the date string

- WORKDAY_INTL
Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days

- YEARFRAC
Returns the number of years, including fractional years, between two dates using a specified day count convention.

- ADDRESS
Returns a reference as text to a single cell in a worksheet

- AREAS
Returns the number of areas in a reference

- COLUMN
Returns the column number of a reference

- COLUMNS
Returns the number of columns in a reference

- FILTER
Filters a range of data based on criteria you define

- FORMULATEXT
Returns the formula at the given reference as text

- GETPIVOTDATA
Returns data stored in a PivotTable report

- HLOOKUP
Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified variable in the column found.

- INDIRECT
Returns a reference indicated by a text value

- LOOKUP
Looks through a sorted row or column for a key and returns the value of the variable in a result range located in the same position as the search row or column.

- OFFSET
Returns a range reference shifted a specified number of rows and columns from a starting cell reference.

- ROW
Returns the row number of a reference

- ROWS
Returns the number of rows in a reference

- RTD
Retrieves real-time data from a program that supports COM automation

- SORTBY
Sorts the contents of a range or array based on the values in a corresponding range or array

- VLOOKUP
Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified variable in the row found.

- XLOOKUP
Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.

- AND
The AND function returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.

- IFNA
The IFNA function evaluates a value. If the value is an #N/A error, return the specified value.

- IFS
Evaluates multiple conditions and returns a value that corresponds to the first true condition.

- NOT
Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.

- OR
The OR function returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.

- SWITCH
Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met.

- XOR
The XOR function returns TRUE if an odd number of the provided arguments are logically true, and FALSE otherwise.

- AVERAGE
The AVERAGE function returns the numerical average value in a dataset, ignoring text.

- AVERAGEIFS
Returns the average (arithmetic mean) of all cells that meet multiple criteria.

- BETA_DIST
Returns the probability of a given value as defined by the beta distribution function.

- BETA_INV
Returns the value of the inverse beta distribution function for a given probability.

- BETADIST
The BETADIST function returns the probability of a given value as defined by the beta distribution function.

- BETAINV
The BETAINV function returns the value of the inverse beta distribution function for a given probability.

- BINOM_DIST
Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.

- 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 less than or equal to a criterion value

- BINOMDIST
Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.

- CHIDIST
Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.

- CHISQ_DIST
Returns the cumulative beta probability density function

- CHISQ_DIST_RT
Returns the one-tailed probability of the chi-squared distribution

- CHISQ_INV
Returns the cumulative beta probability density function

- CHISQ_INV_RT
Returns the inverse of the one-tailed probability of the chi-squared distribution

- CHISQ_TEST
Returns the test for independence

- CHITEST
Returns the test for independence

- CONFIDENCE
Calculates the width of half of the confidence interval for a normal distribution.

- CONFIDENCE_NORM
Returns the confidence interval for a population mean

- CONFIDENCE_T
Returns the confidence interval for a population mean, using a Student's t distribution

- COVARIANCE_P
Returns covariance, the average of the products of paired deviations

- COVARIANCE_S
Returns the sample covariance, the average of the products deviations for each data point pair in two data sets

- CRITBINOM
Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.

- EXPON_DIST
Returns the value of the exponential distribution function with a specified lambda at a specified value.

- EXPONDIST
Returns the value of the exponential distribution function with a specified lambda at a specified value.

- F_DIST
Returns the F probability distribution

- F_DIST_RT
Returns the F probability distribution

- F_INV
Returns the inverse of the F probability distribution

- F_INV_RT
Returns the inverse of the F probability distribution

- F_TEST
Returns the result of an F-test

- FINV
Returns the inverse of the F probability distribution

- FORECAST
Calculates the expected y-value for a specified x based on a linear regression of a dataset.

- FORECAST_ETS
Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm

- FORECAST_ETS_CONFINT
Returns a confidence interval for the forecast value at the specified target date

- FORECAST_ETS_SEASONALITY
Returns the length of the repetitive pattern Excel detects for the specified time series

- FORECAST_ETS_STAT
Returns a statistical value as a result of time series forecasting

- FORECAST_LINEAR
Returns a future value based on existing values

- FREQUENCY
Returns a frequency distribution as a vertical array

- GAMMA
Returns the Gamma function value

- GAMMA_DIST
The GAMMA_DIST function calculates the gamma distribution, a 2-parameter continuous probability distribution.

- GAMMA_INV
The GAMMA_INV function returns the value of the inverse gamma cumulative distribution function for the specified probability, alpha, and beta parameters.

- GAMMADIST
The GAMMADIST function calculates the gamma distribution, a 2-parameter continuous probability distribution.

- GAMMAINV
The GAMMAINV function returns the value of the inverse gamma cumulative distribution function for the specified probability, alpha, and beta parameters.

- GAMMALN_PRECISE
Returns the natural logarithm of the gamma function, Γ(x)

- GAUSS
Returns 0.5 less than the standard normal cumulative distribution

- GROWTH
Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values.

- HYPGEOM_DIST
Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws.

- HYPGEOMDIST
Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws.

- INTERCEPT
Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0).

- KURT
Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.

- LINEST
Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method.

- LOGEST
Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve.

- LOGINV
Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value.

- LOGNORM_DIST
Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.

- LOGNORM_INV
Returns the inverse of the lognormal cumulative distribution

- LOGNORMDIST
Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.

- MODE_MULT
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data

- MODE_SNGL
Returns the most frequently occurring number in a numeric data set. For example, MODE_SNGL(1,2,4,4,5,5,5,6) returns 5.

- NEGBINOM_DIST
Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.

- NEGBINOMDIST
Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.

- NORM_DIST
Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.

- NORM_S_DIST
Returns the value of the standard normal cumulative distribution function for a specified value.

- NORM_S_INV
Returns the value of the inverse standard normal distribution function for a specified value.

- NORMDIST
The NORMDIST function returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.

- NORMINV
Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.

- NORMSDIST
Returns the value of the standard normal cumulative distribution function for a specified value.

- NORMSINV
Returns the value of the inverse standard normal distribution function for a specified value.

- PERCENTILE_EXC
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive

- PERCENTILE_INC
Returns the k-th percentile of values in a range

- PERCENTRANK_EXC
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set

- PERCENTRANK_INC
Returns the percentage rank of a value in a data set

- PERMUT
Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.

- PERMUTATIONA
Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects

- PHI
Returns the value of the density function for a standard normal distribution

- POISSON
Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean.

- POISSON_DIST
Returns the Poisson distribution

- PROB
Returns the probability that values in a range are between two limits

- QUARTILE_EXC
Returns the quartile of the data set, based on percentile values from 0..1, exclusive

- QUARTILE_INC
Returns the quartile of a data set

- RANK_AVG
Returns the rank of a number in a list of numbers

- RANK_EQ
Returns the rank of a number in a list of numbers

- RSQ
Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.

- SKEW
Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.

- SKEW_P
Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean

- STANDARDIZE
Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.

- STDEV_P
Calculates the standard deviation for a sample set of data. STDEV_P calculates standard deviation using the "n" method, ignoring logical values and text.

- STDEV_S
Calculates the standard deviation for a sample set of data. STDEV_S replaces the older STDEV function, with the same behavior.

- STDEVPA
Calculates the standard deviation based on an entire population, setting text to the value `0`.

- STEYX
Calculates the standard error of the predicted y-value for each x in the regression of a dataset.

- T_DIST_2T
Returns the Percentage Points (probability) for the Student t-distribution

- T_DIST_RT
Returns the Student's t-distribution

- T_INV_2T
Returns the inverse of the Student's t-distribution

- T_TEST
Returns the probability associated with a Student's t-test

- TREND
Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.

- TRIMMEAN
Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.

- VAR_P
Returns the variance in an entire population. If data represents a sample of the population, use the VAR_S function.

- VAR_S
Returns the variance of a sample. If data represents the entire population, use the VAR_P function. VAR_S ignores text values and logicals in references.

- WEIBULL
Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.

- WEIBULL_DIST
Returns the Weibull distribution

- CALL
Calls a procedure in a dynamic link library or code resource

- CUBEKPIMEMBER
Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance.

- CUBEMEMBER
Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.

- CUBEMEMBERPROPERTY
Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member.

- CUBERANKEDMEMBER
Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students.

- CUBESET
Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel.

- CUBESETCOUNT
Returns the number of items in a set.

- CUBEVALUE
Returns an aggregated value from a cube.

- EUROCONVERT
Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation).

- FDIST
Returns the F probability distribution

- FTEST
Returns the result of an F-test

- NORM_INV
Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.

- REGISTER_ID
Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered

- TTEST
Returns the probability associated with a Student's t-test

- BITLSHIFT
The BITLSHIFT function shifts the bits of the input a certain number of places to the left. Bits on the right are filled with zeroes (0s).

- BITOR
The BITOR function returns the bitwise Boolean OR of 2 numbers. The BITOR truth table is below:

- BITRSHIFT
The BITRSHIFT function shifts the bits of the input a certain number of places to the right. Bits on the left are filled with zeroes.

- BITXOR
The BITXOR function is a bitwise XOR (exclusive or) of 2 numbers that returns a bit of "1" if 2 bits are different, and a bit of "0" otherwise. This function returns a number that's the result of performing an XOR function at each bit of the 2 given numbers.

- COMPLEX
The COMPLEX function creates a complex number, given real and imaginary coefficients.

- ERF
The ERF function returns the integral of the Gauss error function over an interval of values.

- GESTEP
The GESTEP function returns 1 if the rate is strictly greater than or equal to the provided step value, or 0 otherwise. If no step value is provided, then the default value of 0 is used.

- IMARGUMENT
The IMARGUMENT function returns the angle (also known as the argument, or theta) of the given complex number in radians. This is the angle θ such that, for any complex number in Cartesian form x + yi, x + yi = reiθ where r is the magnitude of the number.

- IMCOS
The IMCOS function returns the cosine of the given complex number. For example, a given complex number "x+yi" returns "cos(x+yi)."

- IMCOSH
The IMCOSH function returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)."

- IMCOT
The IMCOT function returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)."

- IMCSC
The IMCSC function returns the cosecant of the given complex number. For example, a given complex number "x+yi" returns "csc(x+yi)."

- IMCSCH
The IMCSCH function returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi)."

- IMSEC
The IMSEC function returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)."

- IMSECH
The IMSECH function returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)."

- IMSIN
The IMSIN function returns the sine of the given complex number. For example, a given complex number "x+yi" returns "sin(x+yi)."

- IMSINH
The IMSINH function returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi)."

- IMTAN
The IMTAN function returns the tangent of the given complex number. For example, a given complex number "x+yi" returns "tan(x+yi)."

- CELL
Returns information about the formatting, location, or contents of a cell

- ERROR_TYPE
Returns a number corresponding to an error type

- IFEMPTY
Returns the first value if this value is not empty, otherwise returns the second value

- IFERROR
Receives two values (or expressions) and tests if the first of these evaluates to an error.

- INFO
Returns information about the current operating environment

- ISFORMULA
Returns TRUE if there is a reference to a cell that contains a formula

- ISREF
Returns TRUE if the value is a reference

- SHEET
Returns the sheet number of the referenced sheet

- SHEETS
Returns the number of sheets in a reference

- FINDB
Returns the position at which a string is first found within text counting each double-character as 2.

- LEFTB
The LEFTB function returns the left portion of a string up to a certain number of bytes.

- MIDB
The MIDB function returns a section of a string starting at a given character and up to a specified number of bytes.

- NUMBERVALUE
Converts a number in text format to numeric value, using specified decimal and group separators. This function can be used to convert locale-specific values into locale-independent values.

- REPLACEB
The REPLACEB function replaces part of a text string, based on a number of bytes, with a different text string.

- RIGHTB
The RIGHTB function returns the right portion of a string up to a certain number of bytes.

- SEARCHB
Returns the position at which a string is first found within text counting each double-character as 2.

- TEXTJOIN
Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.

- UNICHAR
Returns the Unicode character for a number. This method supports returning characters in both the UTF-8 and UTF-16 character set.

- UNICODE
The UNICODE function returns the decimal Unicode value of the first character of the text.

- VALUE
Converts text that appears in a recognized format (i.e. a number, date, or time format) into a numeric value

- FILTERXML
Returns specific data from the XML content by using the specified XPath

- WEBSERVICE
Returns data from a web service.

- COUNTRY_OFFICIAL_NAME
Returns country official name by code. "de" - "Bundesrepublik Deutschland"

- DAVERAGE
Returns the average of a set of values selected from a database table-like array or range using a SQL-like query.

- DCOUNT
Counts numeric values selected from a database table-like array or range using a SQL-like query.

- DCOUNTA
Counts values, including text, selected from a database table-like array or range using a SQL-like query.

- DGET
Returns a single value from a database table-like array or range using a SQL-like query.

- DMAX
Returns the maximum value selected from a database table-like array or range using a SQL-like query.

- DMIN
Returns the minimum value selected from a database table-like array or range using a SQL-like query.

- DPRODUCT
Returns the product of values selected from a database table-like array or range using a SQL-like query.

- DSTDEV
Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.

- DSTDEVP
Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.

- DSUM
Returns the sum of values selected from a database table-like array or range using a SQL-like query.

- DVAR
Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.

- DVARP
Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.