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.