FORMULAS

Calculate the absolute value of a number

Calculate accrued interest for a security that pays periodic interest.

Calculate the inverse cosine of a number.

Calculate the inverse hyperbolic cosine of a number.

Calculate the principal value of the arccotangent of a number.

Calculate the inverse hyperbolic cotangent of a number.

Return the address of a cell using a row and column number.

Calculate an aggregation.

Return accounting depreciation for a period.

Calculate depreciation for an accounting period.

Convert Roman numerals to Arabic numerals.

Calculate the number of areas in a reference.

Convert full-width characters to half-width characters.

Calculate the inverse sine of a number.

Calculate the inverse hyperbolic sine for a number.

Calculate the arctangent of a number.

Calculate the arctangent using x- and y-coordinates.

Calculate the inverse hyperbolic tangent of a number.

Calculate the sum of the squared deviations of a data set.

Calculate the average of a set of numbers and text.

Calculate the average of numbers in a range that meet a specific criteria.

Calculate the average of cells that satisfy multiple criteria.

Convert a number into Thai text and add the "Baht" suffix.

Convert numbers to other bases.

Compute the modified Bessel function.

Calculate the Bessel function.

Return the modified Bessel function.

Calculate the Bessel function.

Calculate the cumulative beta distribution.

Compute the inverse of the beta cumulative probability density function.

Calculate the cumulative beta probability density function.

Calculate the inverse of the cumulative beta probability density function.

Convert a binary number to decimal.

Return a decimal number representing the bitwise OR of two numbers.

Shift numbers by bits.

Return a decimal number representing the bitwise XOR of two numbers.

Process data in an array or range in a "by column" fashion.

Apply a function to each row in an array.

Evaluate an expression.

Round a number up to the nearest multiple specified.

Retrieve characters from numbers.

Calculate the one-tailed probability of the chi-squared distribution for a given γ2 test.

Return the appropriate x value based on the accuracy of CHIDIST.

Return the chi-squared distribution.

Calculate the right-tailed probability for the chi-squared distribution.

Return the inverse of the left-tailed probability of the chi-squared distribution.

Calculate the inverse of the right-tailed probability of a chi-square distribution.

Determine if an experiment verifies the hypothesized results.

Determine if a hypothesis is verified using an experiment.

Return specific columns from an array.

Return specific rows from an array or range.

Remove non-printable characters from text.

Identify a numeric code for a character.

Return the column number for a reference.

Get the count of columns in a given reference.

Calculate combinations without repetition.

Count combinations with repetitions allowed.

Create complex numbers with real and imaginary coefficients.

Combine strings of text values.

Calculate a range of values to estimate the population mean with a given confidence level.

Calculate a confidence interval for a population mean using a normal distribution.

Return a confidence interval for a population mean.

Convert units of measurement.

The CORREL function calculates the correlation coefficient between two cell ranges to determine the relationship between two properties. It is used to measure if changes in one property will result in changes in the other.

Calculate the cosine of an angle.

Calculate the hyperbolic cosine of a number.

Count blank cells.

Sums up the cells matching several criteria.

Calculate the number of days from the start of the coupon period to the settlement date.

Calculate the number of days in a coupon period.

Calculate the number of days between the settlement date and the next coupon date.

Calculate the next coupon date after the settlement date.

Calculate the number of coupons or interest payments payable between the settlement date and maturity date.

Calculate the previous coupon date before the settlement date for a coupon bond.

Covariance helps to measure the relationship between two data sets by calculating the average of the products of deviations for each data point pair. This can be used to analyse correlations between variables, such as whether greater education is linked to higher earnings. Covariance can be a useful tool for analysing relationships between different components of a dataset.

Calculate the relationship between two data sets by determining the covariance of the deviations for the data points.

Return the sample covariance.

Calculate the cosecant of an angle in radians.

Return the hyperbolic cosecant of an angle.

Calculate the cumulative interest paid on a loan.

Calculate the number of days, months, or years between two dates.

Return a part of a date.

Convert text dates to valid Sourcetable dates.

Calculate the average from matching records.

Retrieve the day as a number from a date.

Calculate the number of days between dates.

Calculate the number of days between two dates in a 360-day year.

Calculate depreciation of an asset.

Convert half-width letters to full-width letters.

Count matching records in a database using criteria and a field.

Count matching records in a database using criteria and an optional field.

Calculate depreciation of an asset.

Convert decimal numbers to binary.

Convert decimal numbers to hexadecimal numbers.

Convert decimal numbers to octal numbers.

Convert a text representation of a number into a decimal number.

Convert angles to degrees.

Compare two numeric values.

Calculate the sum of squared deviations from the mean.

Retrieve a single value from a record using criteria.

Calculate the discount rate for a security.

Calculate the maximum value in a field from a set of records that match a criteria.

Calculate the minimum value in a field from a set of records that match specified criteria.

Convert dollar prices entered with a special notation to decimal numbers.

Convert prices to a fractional notation.

Calculate the product of matching records.

Remove a portion of an array

The DSTDEV function is a worksheet function used to calculate the standard deviation of a population using a sample of numbers in a column of a table.

Calculate the standard deviation of a population of data.

Calculate the sum of values from a set of records that match specified criteria.

Calculate the Macauley duration for a $100 par value.

Calculate the population variance using a sample.

Return the variance of a population.

Calculate a date which is a specified number of months before or after a given date.

Calculate an annual interest rate.

Encode a text string into a URL-safe format.

Return the serial number of the last day of the month in a given year.

Calculate the integral between lower_limit and upper_limit using the ERF function.

Return the error function.

Calculate the complementary ERF function.

Return the complementary ERF function between x and infinity.

Return a number representing an error value.

The EUROCONVERT function allows users to easily convert a number from one euro member currency to another, or to euros. Fixed conversion rates set by the EU are used for accuracy.

Convert European Union currencies.

Round numbers up to the next even integer.

Compare strings of text.

Calculate the value of e raised to the power of a number.

Expand an array by adding rows and columns.

Calculate the exponential distribution.

Return the exponential distribution.

Calculate the difference in diversity between two data sets.

Determine if two datasets have different degrees of diversity.

Calculate the inverse of the F probability distribution.

Calculate the inverse of the right-tailed F probability distribution.

Determine if two samples have the same variances.

Calculate the factorial of a number.

Calculate the double factorial of a number.

Determine whether two data sets have different amounts of diversity.

Find the starting position of text within a parent string in languages using the double-byte character set.

Calculate the inverse of the F probability distribution.

Calculate hypothesis testing on the correlation coefficient.

Calculate the inverse of the Fisher transformation.

Format numbers as text with fixed decimals.

Round numbers down to a multiple specified.

Retrieve the formula in a cell as text.

Determine whether two samples have different variances.

Calculate the future value of an investment.

Calculate the future value of a single sum using a schedule of interest rates.

Return the gamma function value.

Calculate skewed variables using GAMMA.DIST.

Calculate the inverse of a gamma distribution.

Study variables with a skewed distribution.

Study a variable whose distribution is skewed.

Calculate the natural logarithm of the gamma function.

Calculate the natural logarithm of the gamma function with precision.

Calculate the probability of a standard normal population member falling between the mean and standard deviations.

Calculate the greatest common divisor of multiple integers.

Calculate the geometric mean.

Filter values using GESTEP.

Retrieve data from a pivot table by name.

Calculate predicted exponential growth.

Calculate the harmonic mean.

Convert a hexadecimal number to binary.

Convert a hexadecimal number to its decimal equivalent.

Convert a hexadecimal number to octal.

Find values in a horizontal table.

Extract the hour from a time.

Combine arrays horizontally into a single array.

Create a clickable link.

Calculate the hypergeometric distribution.

Calculate the hypergeometric distribution.

Trap #N/A errors.

Calculate the absolute value of a complex number.

The IMAGE function allows users to insert images, spheres, and cylinders into cells in a worksheet. It works with various image formats and can be customized to specify alternate text and dimensions.

Calculate the imaginary coefficient of a complex number.

Return the argument of a complex number.

Return the complex conjugate of a complex number.

Calculate the complex cosine of a complex number.

Return the cosine of a complex number.

Calculate the cotangent of a complex number.

Calculate the cosecant of a complex number.

Calculate the hyperbolic cosecant of a complex number.

Divide complex numbers.

Calculate the exponential of a complex number.

Calculate the natural logarithm of a complex number.

Calculate the complex common logarithm of a number.

Calculate the base-2 logarithm of a complex number.

Raise a complex number to a given power.

The IMPRODUCT function is used to multiply complex numbers by taking a set of complex numbers as arguments.

Calculate the real coefficient of a complex number.

Calculate the secant of a complex number.

Calculate the hyperbolic secant of a complex number.

Calculate the sine of a complex number.

Calculate the hyperbolic sine of a complex number.

Calculate the square root of a complex number.

Calculate the difference between two complex numbers.

Calculate the sum of complex numbers.

Calculate the tangent of a complex number.

Round down a decimal number to the nearest integer.

Calculate the intercept of a regression line.

Calculate the annual effective interest rate for a security that is fully invested.

Calculate interest in a given period.

Determine if a cell is empty.

Test for any error but #N/A.

Test for errors in Sourcetable.

Test if a value is even.

Test if a cell contains a formula.

Test if a value is logical.

Test for the #N/A error.

Test for a non-text value.

Test if a cell contains a number.

Test whether a value is odd.

Check if a LAMBDA has a missing argument.

Calculate the ISO week number for a date.

Calculate the interest paid during a specified period of an investment.

Test if a cell contains a reference.

Test if a cell contains a text value.

Convert single byte characters into double byte characters in a specific encoding.

Calculate the kurtosis of a data set.

Create custom functions for use throughout a workbook.

Identify the nth largest value in an array.

Calculate the least common multiple of numbers.

Extract text from the left of a string.

Calculate the length of text.

Assign variables in a formula.

Calculate the natural logarithm of a number.

Calculate the logarithm of a number.

Calculate the base 10 logarithm of a number.

Calculate an exponential curve using data.

Calculate the inverse of the lognormal cumulative distribution function.

Calculate the lognormal distribution.

Calculate the inverse of the lognormal cumulative distribution function.

Calculate data that has been logarithmically transformed and divided into a range of values.

Convert text to lower case.

Create an array with calculated values.

Apply a custom function to an array.

Find the largest numeric value in a range.

Find the maximum value in a range using criteria.

Compute the matrix determinant of an array.

Calculate the Macauley modified duration for a security with an assumed par value of $100.

Return a specified number of characters from a text string starting at a specified position.

Find the smallest value in the data supplied.

Find the smallest numeric value in a range of values.

Find the minimum value in a range using criteria.

Return the minute from a given time.

Calculate the inverse matrix of an array.

Calculate the modified internal rate of return.

Perform matrix multiplication.

Calculate the most frequently occurring number in a set of numbers.

Calculate the most frequently occurring numbers in a data set.

Find the most frequently occurring number in a set of numbers.

Retrieve the month from a date.

Round a number to the nearest multiple.

Calculate the ratio of the factorial of a sum of values to the product of factorials.

Return a unit matrix of a specified dimension.

Convert a value to a number.

Create an #N/A error.

Calculate the negative binomial distribution.

Calculate the probability of an event occurring given that the event has a specific number of chances of occurring.

Calculate the number of working days between two dates.

Calculate the number of working days between two dates.

Calculate the nominal interest rate.

Calculate values and areas for the normal probability density function and the normal cumulative distribution function.

Calculate the inverse of the normal cumulative distribution.

Calculate the standard normal CDF and PDF.

Calculate the inverse of the standard normal cumulative distribution.

Return values for the normal probability density function (PDF) and the normal cumulative distribution function (CDF).

Calculate the inverse of the normal cumulative distribution.

Calculate the standard normal cumulative distribution.

Calculate the value of z such that with a given probability p, a standard normal random variable is less than or equal to z.

Reverse a value.

Calculate the number of periods for a loan or investment.

Calculate the net present value of an investment.

Convert an octal number into a binary number.

Convert an octal number to a decimal number.

Convert an octal number to hexadecimal.

Round up a number to the next odd integer.

Calculate the price per $100 face value for a security with an odd first period.

Calculate the yield of a security with an odd first period.

Calculate the price per $100 face value of a security with an odd last period.

Calculate the yield of a security with an odd last period.

Calculate the number of periods needed to reach a given value.

Calculate the Pearson product moment correlation coefficient.

Calculate the kth percentile for a set of data.

Calculate the kth percentile.

Calculate the kth percentile.

Calculate the percentile rank of a value in a data set.

Calculate the relative ranking of a value in a data set as a percentage.

Calculate the relative rank of a value in a data set as a percentage.

Calculate the number of permutations without repetitions.

Calculate the number of permutations with repetitions.

Calculate the density function for a standard normal distribution.

Calculate the value of π.

Calculate the Poisson distribution.

Calculate the Poisson distribution.

Raise a number to a power.

Calculate the principal portion of a loan payment.

Calculate the price per $100 face value of a security that pays periodic interest.

Calculate the price per $100 face value of a discounted security.

Calculate the price per $100 face value of a security that pays interest at maturity.

Calculate the probability of a range of values between two limits.

Multiply numbers given as arguments.

Capitalize the first letter of each word in a text string.

Calculate the quartile in a data set.

Calculate the quartile for a set of data.

Calculate the quartile of a data set.

Calculate the quotient of a division.

Convert degrees into radians.

Generate an array of random numbers.

Generate a random integer between two numbers.

Rank a number against other numeric values.

Rank a number against other numeric values.

Calculate the amount received at maturity for a fully invested security.

Reduce an array.

Clear the filters from a table.

Replace text in a string using the number of bytes specified.

Repeat specified text.

Convert numbers to Roman numerals as text.

Round down to a specified number of digits.

Calculate an equivalent interest rate for growth.

Calculate the square of the Pearson product moment correlation coefficient.

Return intermediate results from scanning an array.

Find where a substring is within another string.

Calculate the secant of an angle.

Calculate the hyperbolic secant of an angle.

Return the second component of a time as a number between 0-59.

Generate a list of numbers in an array.

Calculate the sum of a power series.

Return the sheet number for a reference sheet.

Calculate the number of sheets in a reference.

Calculate the sign of a number.

Calculate the sine of an angle using radians.

Calculate the hyperbolic sine of a number.

Calculate the skewness of a distribution.

Calculate the skewness of a distribution.

Calculate depreciation.

Calculate the slope of a linear regression line.

Organize a range or array.

Sort a range or array by column.

Calculate the positive square root of a number.

Calculate the square root of a number using pi.

Calculate a z-score using the mean and standard deviation.

Calculate the standard deviation for a sample.

Calculate the standard deviation for a data set.

Calculate the standard deviation for a data set.

Calculate the standard deviation for a sample of data.

Calculate the standard deviation for a population.

Calculate the standard deviation for a population.

Calculate the standard error of the predicted y-value for each x in a regression.

Replace text based on content.

Return the sum of products from multiplying arrays.

Calculate the sum of the squares of the provided values.

Calculate the sum of the squares of differences of corresponding values in two arrays.

Calculate the sum of the sum of squares of corresponding values in two arrays.

Calculate the sum of squares of differences between corresponding values in two arrays.

Match multiple values with the SWITCH function.

Calculate sum of years depreciation.

Filter text values only.

Compute the student's left-tailed t-distribution.

Compute the two-tailed Student's t-distribution.

Calculate the right-tailed student's t-distribution.

Calculate the left-tailed inverse of the Student's t-distribution.

Calculate the two-tailed inverse of the Student's t-distribution.

Determine if two samples come from the same two underlying populations with the same mean.

Retrieve a subset of an array.

Calculate the tangent of an angle.

Calculate the hyperbolic tangent of a number.

Calculate the bond-equivalent yield for a Treasury bill.

Calculate the price per $100 face value for a Treasury bill.

Calculate the yield for a Treasury bill.

Compute the probability for the student t-distribution.

Extract text after a delimiter.

Extract text before a delimiter.

Combine text values using a delimiter.

Split text using a delimiter.

Create a time with hours, minutes, and seconds.

Convert a text string into a time.

Calculate the two-tailed inverse of the Student's t-distribution.

Return an array in a single column.

Transform an array into a single column.

Flip the orientation of a range of cells.

Fits polynomial curves using regression.

Calculate the mean of a data set while excluding outliers.

Verify the logical value TRUE.

"Truncate a number to a specified precision."

Calculate the probability associated with the Student's T Test.

Determine the type of value in a cell.

Return the Unicode character corresponding to a given number.

Retrieve the number from a Unicode character.

The UNIQUE function returns a list of unique values from a list or range, ensuring that all names are different. It is an effective way to separate and manage data.

Convert text to uppercase.

Convert text to a number.

Calculate the variation of a sample of data.

Calculate the variance of a population.

Calculate the variance of a sample of data.

Calculate the variation in a sample of data.

Calculate the variance of a population.

Calculate the variance of a population.

Calculate depreciation for an asset.

Combine arrays vertically.

Retrieve data from a web service.

Determine the week number for a date.

Calculate the Weibull distribution.

Calculate the Weibull distribution.

Calculate a date n working days in the future or past.

Calculate the nearest working day in the future or past using an offset value.

Wrap an array into columns.

Calculate the internal rate of return for an irregular cash flow.

Find values in a range or array using XLOOKUP.

Find where an item is in a list or table.

Calculate the net present value of an investment using a discount rate and irregular cash flows.

Perform exclusive OR.

Retrieve the year from a date.

Calculate the fraction of a year between two dates.

Calculate the periodic interest yield on a security.

Calculate the annual yield for a discounted security.

Calculate the annual yield of a security with interest at maturity.

Calculate the P-value for a z-test.

Calculate the one-tailed probability-value of a z-test.

To test multiple logical conditions at the same time.

The CELL function is used in Sourcetable to get information about a cell, such as the address, data type, and contents.

To get a value from a list using a list index.

Joins strings of text together.

To count the number of cells that contain data.

Counts cells that match a criterion.

Creates dates from inputting a year, month, and day

Filters a range of cells based on supplied criteria

To find out where a substring is located within a string.

Predicts values based on a linear trend

Counts how many times each value appears in a data set

To test a condition and return one value if the condition is true and another value if the condition is false.

To trap and manage errors.

Evaluates multiple conditions and returns the first result that is TRUE

To retrieve a value based on its location within a given array, vector, or reference.

Uses text to create references

Determines the internal rate of return for a given investment.

To extract text from the left of a text string.

Calculates the length of any text string

Calculates the parameters of the best-fit line for a set of data points

Searches a one-column range for a specific value

Locates the position of a specific value within an array

To get the largest value in a set of data.

Calculates the middle value of a set of numbers

To extract text from a given string.

Calculates the remainder when two numbers are divided

Displays the current date and time

To create a reference from a specific starting point.

Tests multiple logical conditions simultaneously

To calculate periodic loan payments.

Calculates the present value of an investment

Generates a random number between 0 and 1

Determines the relative rank of a given number compared to other numbers in a list or array

Calculates the periodic interest rate of an annuity.

To replace characters in a string by location.

To find a specified number of characters from the right end of the source string

Rounds a number to the desired number of digits specified

Rounds a number up to a specified number of decimal places

Identifies and returns the row number for a given reference

To return the number of rows in a reference.

To find where a substring is within another string.

Identifies the n^th smallest value in an array of given values

Add cells together based on a given criteria.

To sum cells in a range that meet one or more conditions.

Converts numbers into their textual equivalent

Gets today's date.

Removes any unnecessary white space from text

Searches for data stored in the first column of a table.

Retrieves the day of the week from a given date

To calculate the average of a set of numbers.

To count numerical values.

To get a subtotal from a list or database.

To pull data from a data table into the sheet.

To calculate the total or sum of a range of numeric values, including individual numbers, cell references, or cell ranges.

To calculate the probability of a specific number of successes in a fixed number of trials with a specified probability of success.

The CRITBINOM function calculates the smallest number of successes required in a fixed number of binomial trials to meet or exceed a specified criterion value, making it useful for determining critical values in hypothesis testing.

To converts a binary number to its hexadecimal equivalent.

The BIN2OCT formula converts a binary number to its octal equivalent.

The BITAND formula performs a bitwise AND operation on two integers, comparing each pair of corresponding bits and returning an integer result where each bit is the logical AND of the corresponding bits in the input integers.

The BITLSHIFT formula performs a bitwise left shift operation on an integer, shifting its bits a specified number of positions to the left and returning the result as an integer.

The ACCRINTM formula calculates the accrued interest for a security that pays interest at maturity, based on the issue date, maturity date, and rate of interest.

The BINOM.DIST formula calculates the binomial probability or the cumulative binomial distribution for a given number of successes, trials, and probability of success on each trial.

The BINOM.DIST.RANGE formula calculates the probability of achieving a specified range of successes in a fixed number of trials, each with the same probability of success, using the binomial distribution.

The BINOM.INV function calculates the smallest number of successes (k) for which the cumulative binomial distribution is greater than or equal to a specified criteria (alpha), given a fixed number of trials (n) and the probability of success (p) on each trial.

To calculate the cotangent of a specified angle in radians, which is the reciprocal of the tangent of the angle.

To calculate the hyperbolic cotangent of a given number, which is the reciprocal of the hyperbolic tangent of that number.

The CUMPRINC function calculates the cumulative principal paid on a loan between two specified periods, providing the total amount of principal repaid over a range of payment periods.

The DOLLAR function converts a numeric value into a text string formatted as currency, with the default currency symbol and a specified number of decimal places.

To extract a specified number of bytes from the right end of a text string, making it useful for handling text in double-byte character sets (DBCS).

The SINGLE function is used to extract a single value from an array or range, making it particularly useful for retrieving a specific value from a dynamic array result.

To wrap a row or column by a certain number of rows which creates a new array.