FORMULAS

The ABS function returns the absolute value of a real number argument by removing its sign. It is required to provide a real number argument to get the absolute value.

The ACCRINT function calculates the accrued interest for a security that pays periodic interest. This function is a useful tool for tracking the interest earned on a security over time.

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 ACOS function in Excel is a trigonometric function that calculates the arccosine (inverse cosine) of a given number. The function returns an angle, measured in radians, whose cosine is the specified number.

The ACOSH function returns the inverse hyperbolic cosine of a number greater than or equal to 1. It calculates the opposite of the hyperbolic cosine, which is the value whose hyperbolic cosine is the input number.

The ACOT function calculates the principal value of the inverse cotangent (arccotangent) of a real number. It returns the angle in radians and #VALUE! if the argument is not a real number.

The ACOTH function calculates the inverse hyperbolic cotangent of a number that is analogous to the ordinary arccotangent. It takes a single argument, a number, which is required.

The ADDRESS function returns the address of a cell in a worksheet given the row and column numbers specified. It can also generate either an absolute or relative reference depending on the abs_num argument.

The AGGREGATE function can be used to perform aggregations in a list or database and it can ignore hidden rows and error values. It is meant for vertical ranges, but not for horizontal ranges.

The AMORDEGRC function is used to calculate depreciation for accounting purposes, using a coefficient dependent on asset life. It is specifically tailored for the French system and takes into account proration of the asset with the date of purchase.

The AMORLINC function is used to calculate the depreciation of an asset over a given number of accounting periods. It takes six arguments and accounts for prorated depreciation when an asset is purchased within an accounting period.

The AND function is used to test multiple conditions and returns TRUE if all conditions are met.

The ARABIC function is a useful tool for converting Roman numerals to their numeric equivalent. It takes one argument, Roman_text, which is a string with a Roman number, and returns the numeric value.

The AREAS function counts the number of areas in a reference. An area is a single cell or a range of contiguous cells. When inputting multiple references, extra parentheses must be used to prevent Sourcetable from interpreting the comma as a field separator.

The ASC function in Sourcetable changes full-width characters, which are double-byte, to half-width characters, which are single-byte. It requires a text argument, and does not change text if it contains full-width letters.

The ASIN function calculates the arcsine of a number, returning an angle in radians between -pi/2 and pi/2. The angle must be between -1 and 1.

The ASINH function is a Sourcetable math/trig function that calculates the inverse hyperbolic sine of a number. It may be used as a worksheet function, appearing in a formula in a worksheet cell.

The ATAN function calculates the arctangent of a number, which is the inverse tangent of the input number and the angle whose tangent is the input number.

The ATAN2 function is used to calculate the arctangent of a point in radians, which is the angle from the x-axis to a line connecting the origin (0, 0) to the point (x_num, y_num). The result is a value between -pi and pi.

The ATANH function calculates the inverse hyperbolic tangent of a real number between -1 and 1, excluding -1 and 1. It requires a number argument to return the result.

The AVEDEV function is a useful tool for calculating the average absolute deviation of numbers in a data set. It takes numerical arguments, including numbers, names, arrays, and references, and ignores empty cells, text, and logical values.

The AVERAGE function in Sourcetable calculates the average numerical value of its arguments.

The AVERAGEA function is a powerful tool that can calculate the average of a variety of inputs, including numerical values, text representation of numbers, arrays, and references. It does not accept error values or text that cannot be converted into numbers.

The AVERAGEIF function is used to calculate the average of a range of cells that meet a certain criteria. It requires two arguments, range and criteria, while the average_range argument is optional. AVERAGEIF ignores empty cells and cells containing TRUE or FALSE values, and returns a #DIV/0! error if no cells meet the criteria or the range is blank or a text value.

The AVERAGEIFS function calculates the arithmetic mean of cells matching multiple criteria. Cells in the average_range which aren't numbers will return a #DIV/0! error, and empty cells in the criteria range will be treated as 0.

The BAHTTEXT function is useful for converting numbers into Thai text, adding the suffix "Baht" to the returned text.

The BASE function is used to convert a number into its text representation using a radix or base, ranging from 2 to 36.

The BESSELI function calculates a modified Bessel function with purely imaginary arguments. It returns errors if either x or n is not a number, or if n is negative.

The BESSELJ function is used to calculate the n-th order Bessel function of a variable using the Gamma function. Note that errors occur if n is not an integer or is not a number, or if n is less than 0.

The BESSELK function computes the modified Bessel function, which is the same as the Bessel function with purely imaginary arguments. It throws errors for non-numerical inputs and negative n values.

The BESSELY function calculates a Bessel function, also known as the Weber function or the Neumann function. It will return an error value if x or n is not numeric and a #NUM! error if n is negative.

The BETADIST and BETA.DIST functions are used to calculate the cumulative beta probability density function, helping to measure the percentage of something across samples. BETA.DIST may provide improved accuracy compared to BETADIST.

The BETA.INV function computes the inverse of the beta cumulative probability density function, which is used in project planning to model probable completion times.

The BETADIST function is used to calculate the cumulative beta probability density function. It is used to study how percentages vary across samples, however it is being replaced with the BETA.DIST function for improved accuracy.

The BETAINV function computes the inverse of the cumulative beta probability density function, which models project completion times from an expected completion time and variability.

The BIN2DEC function is used to convert a binary number, up to 10 bits, into its decimal equivalent. It takes a binary number as an argument and returns its decimal value, or #NUM! if the binary number is not valid.

BIN2HEX converts a binary number to a hexadecimal number.

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

BINOM.DIST is a formula used to calculate the probability of a certain number of successes in a fixed number of trials with a specified probability of success.

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

The BINOM.INV function in Excel calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria, given a fixed number of trials and the probability of success on each trial.

BINOMDIST is a formula used to calculate the probability of a certain number of successes in a fixed number of trials with a specified probability of success.

The BITAND formula performs a bitwise AND operation on two integers and returns the result as an integer.

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 BITOR function is a tool that allows users to take two decimal numbers and apply a bitwise OR operation to them, returning the result. Both the first and second argument must be greater than or equal to 0.

The BITRSHIFT function is used to shift a numeric value right, by removing digits from the rightmost side of the binary representation. It throws an error in the case of an invalid argument, or when the absolute value of the shift_amount argument is greater than 53.

The BITXOR function is a mathematical tool that enables the logical XOR operation to be performed on the binary values of two positive decimal numbers. It returns a decimal number as the result.

BYCOL is a function that takes two arguments and applies a LAMBA function to each column of an array in a "by column" fashion, returning one result per column.

The BYROW function applies a lambda to each row in an array and returns an array of the results. It requires two arguments, an array and a lambda, and will throw errors if either of these are invalid or incorrect.

The CALCULATE function is a powerful tool for evaluating expressions in row context. It evaluates an expression in a modified filter context, and returns the value of the expression.

The CEILING function rounds a given number up to the nearest multiple of significance, requiring a number argument as the value to be rounded.

The CELL function allows you to return information about a cell's formatting, location, or contents.

The CHAR function is used to convert numerical code page numbers into characters. It is used to translate numerical code page numbers from other computers.

The CHIDIST function is used to calculate the one-tailed probability of the chi-squared distribution for a γ2 test. Note that the function does not work if degrees_freedom is less than 1 or is 10^10.

The CHIINV function is used to calculate the inverse of the CHIDIST function, which calculates the probability that a Chi-Square distributed random variable with df degrees of freedom is greater than or equal to x. CHIINV uses a search process to find the right value of x.

The CHISQ.DIST function calculates the chi-squared distribution, used to study variation in percentages in samples. It requires three arguments, and returns an error if any argument is not numeric.

The CHISQ.DIST.RT function returns the right-tailed probability of the chi-squared distribution, which is commonly used in a χ2 test. It will throw an error if any of the arguments are not a number.

The CHISQ.INV function calculates the inverse of the left-tailed probability of the chi-squared distribution which is used to measure variation in the percentage of something across samples. It throws errors if the argument is not numeric or is negative or larger than 1.

The CHISQ.INV.RT function is used to compare observed and expected values, such as in financial analysis. It calculates the inverse of the right-tailed probability of a chi-square distribution.

The CHISQ.TEST function is used to test for independence and calculate the chi-squared statistic. The result of the test is used to determine if a hypothesis is verified by an experiment. An error will be returned if the number of data points in the actual_range and expected_range are different.

The CHITEST function is used to calculate the chi-squared value of a given distribution. It can be used to assess the difference between observed and expected results.

The CHOOSE function selects a value from a list of up to 254 value arguments using an index number.

The CHOOSECOLS function is used to create a new array containing only the specified columns from an existing array.

The CHOOSEROWS function enables users to select and return specified rows from an array, creating a new array with the selected rows.

The CLEAN function removes non-printable characters from text strings in Sourcetable. It was introduced to Sourcetable to help clean data that had been imported from other applications.

The CODE function returns a numeric code for the first character of a text string, based on the character set used by the user's computer. The code may change when the user changes their settings.

The COLUMNS function returns the number of columns in a data set or reference by taking an array argument and a reference argument. The array argument is required and must be an array or array formula, while the reference argument is a range of cells to count the number of columns in.

The COLUMNS function returns the number of columns in a data set or reference, taking an array argument as required. It returns a number and can be used with an array or array formula.

The COMBIN function is used to calculate the number of combinations for a set of items. If any of the arguments are not numeric, the result will be #VALUE!.

The COMBINA function is used to calculate the number of combinations of items. It requires two arguments, number and number_chosen, which must be greater than or equal to 0.

The COMPLEX function enables the conversion of real and imaginary coefficients into a complex number which is composed of x + yi or x + yj.

The CONCATENATE function is a text function in Excel 2016, Excel Mobile, and Excel for the web that joins multiple strings of text into a single string and returns the joined strings. It is being replaced by the CONCAT function.

The CONCATENATE function is a Sourcetable text function that returns a single string of text by joining multiple strings together.

The CONFIDENCE function is used to calculate a confidence interval for a population mean, which is the sample mean plus one standard deviation. It returns a #VALUE! error if any of the arguments are not numerical, and calculates the area under the standard normal curve to determine the confidence interval for a data set.

The CONFIDENCE.NORM function calculates a confidence interval for a population mean using a normal distribution. As an example, it can be used to estimate the probability of the next package taking a delivery time within the confidence interval.

The CONFIDENCE.T function calculates a confidence interval for a population mean using a Student's t distribution. It requires three arguments for calculation: alpha, standard_dev and size.

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.

The COS function can be used to calculate the cosine of an angle in radians. To use COS with degrees, the angle must be multiplied by PI()/180.

The COSH function is used to calculate the hyperbolic cosine of a number, which is the cosine of the hyperbolic angle of that number. COSH requires real number arguments to be provided.

The COT function calculates the cotangent of a given angle in radians.

The COTH function calculates the hyperbolic cotangent of a given number.

The COUNT function is a versatile function that can be used to count the number of cells or arrays of numbers.

The COUNTA function is a built-in function in Sourcetable that is used to count the number of cells that contain data.

The COUNTBLANK function is used in Sourcetable to count the number of empty cells in a range of cells. It also counts cells with formulas that return "", though it does not count those with zero values.

The COUNTIF function is a statistical function in Sourcetable that counts how many cells meet a criterion.

The COUNTIFS function is a powerful tool that allows users to count how many times a set of criteria is met. It takes up to 127 range/criteria pairs and each range must have the same number of rows and columns as the COUNTIFS arguments.

COUPDAYBS is a financial function which calculates the number of days from the start date of a coupon to its settlement date, using the US 30-day method and a 360-day year. It defaults to zero if omitted.

The COUPDAYS function is used to calculate the number of days in the coupon period for a security based on their settlement date. It requires four arguments - settlement, maturity, frequency and basis - for accurate results.

The COUPDAYSNC function returns the number of days between the settlement date and the next coupon date, based on three required arguments.

The COUPNCD function calculates the next coupon date after a given settlement date, using the maturity date, frequency and basis as additional inputs.

The COUPNUM function returns the total number of coupons that are payable between a given settlement and maturity dates, rounded up to the nearest whole number.

The COUPPCD function can be used to quickly determine the previous coupon date before a given settlement date. It is an efficient tool for financial calculations.

The COVAR function is a Sourcetable feature introduced in 2000. It calculates the correlation between two sets of values, ignoring any text or logical values.

The Covariance.P function is a statistical tool used to measure the joint variability of two random variables. Introduced in MS Excel 2010, it has better accuracy than its predecessor, COVAR.

The COVARIANCE.S function is used to calculate the sample covariance between two data sets. It requires that the arguments be numerical and throws an error if the arrays have different numbers of data points or are both empty.

The CRITBINOM function calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criterion.

The CSC function returns the cosecant of an angle specified in radians. It requires a number argument and will return an error if the number is outside of its constraints or is a non-number.

The CSCH function is used to find the hyperbolic cosecant of an angle specified in radians. The argument must be a numeric value and must not have an absolute value greater than 2^27, otherwise it will return an error.

The CUMIPMT function is used to calculate the cumulative interest payments on a loan. It requires six arguments which must be provided correctly in order to avoid a #NUM! error.

The CUMPRINC function calculates the cumulative principal paid on a loan or investment between two specified periods, given a constant interest rate and periodic payments.

The DATE function in Sourcetable allows users to turn three numbers into a date, returned as a serial number that represents the date in the 1900 date system.

The DATEDIF function calculates the number of days, months, or years between two dates, but can produce incorrect results under certain circumstances, such as when calculating the remaining days after the last completed month.

The DATEPART function is a useful date/time function that can be used to extract a portion of a date/time value.

The DATEVALUE function is a useful tool for working with dates in text formats as it can filter, sort, and format them. It is especially helpful in converting dates stored in text to serial numbers.

The DAVERAGE function is a worksheet function used to calculate the average of numbers by using given criteria. It works with lists or databases and can be part of a formula in a worksheet.

The DAY function in Sourcetable allows users to return the day of the date entered as a number. It requires an argument of a date, which should be entered using the DATE function, as Sourcetable calculates dates using sequential serial numbers.

The DAYS function calculates the number of days between two dates, using two required arguments: end_date and start_date.

The DAYS360 function is a Sourcetable Date/Time function used to calculate the number of days between two dates. It returns a number representing the difference between two dates.

The DB function calculates depreciation for a specified period using the fixed-declining balance method. It uses formulas to calculate the depreciation for a period and takes an optional argument month.

The DBCS function is used to convert text from half-width English letters or katakana to full-width characters. It requires a text argument as input, which is then processed and converted.

The DCOUNT function is a useful tool for counting cells in a list or database, requiring the first two arguments of database and field. An optional field argument can also be used to further refine the count.

DCOUNTA is a function used to count values in a database that meet the criteria specified. It requires a database and criteria argument, while the field argument is optional.

The DDB function calculates depreciation for an asset and requires the cost, salvage, life, period, and factor arguments. The life and period arguments must use the same units and all arguments must be positive numbers.

The DEC2BIN function is a useful tool for converting a decimal integer into its binary format. It is a quick and efficient way to convert a decimal number into its binary form.

The DEC2HEX function converts a decimal number to its corresponding hexadecimal notation. This conversion can be done with or without specifying the places argument.

The DEC2OCT function in Sourcetable is a useful tool for quickly converting decimal numbers to octal equivalents.

The DECIMAL function converts text representations of numbers into decimal numbers, requiring both the text and radix arguments. The radix must be an integer.

The DEGREES function converts an angle in radians to degrees. It requires a radians argument and no other arguments.

The DELTA function is a useful tool for evaluating if two values are equivalent. It is a simple, yet effective way to compare two values.

The DEVSQ function calculates the sum of squares of deviations of data points from their sample mean. It takes multiple arguments, with the first one being required. It can use numbers, words, arrays, or references as arguments and ignores error values and text inputs.

The DGET function is a useful tool for retrieving a single value from a list or database by specifying certain conditions. It is a helpful way to quickly extract data.

The DISC function in Sourcetable is used to calculate the discount rate for a security, by using dates stored as sequential numbers.

The DMAX function is used to find the largest number in a field of a list or database. It requires the database, field and criteria arguments to function properly.

The DMIN function is used to return the smallest number from a field in a list or database. It requires the database, field and criteria arguments and works by finding the smallest number in the field that meets the conditions specified in the criteria argument.

The DOLLAR function formats a numeric value as a currency, rounding it to a specified number of decimal places and adding a currency symbol.

The DOLLARDE function is a useful tool for converting values pricing as a fraction or dollar to decimal format. It allows for easy and efficient calculations.

The DOLLARFR function is used to convert decimal numbers to fractional dollar numbers by converting them to securities prices. It requires two arguments, decimal_dollar and fraction, to work correctly.

The DPRODUCT function multiplies values from a field in a list or database, providing a quick and easy way to calculate results from data stored in records and fields.

The DROP function is used to delete rows or columns from an array. It is a useful tool for quickly removing data from a given 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.

The DSTDEVP function is used to calculate the standard deviation of an entire population of data, given a database argument containing field headers, a field argument of the name or index of the field to query, and a criteria argument.

The DSUM function is a useful tool for quickly adding numbers from a list or database that meet specific criteria. It can be used on any worksheet and with multiple accounts.

The DURATION function is a financial function used to calculate the Macauley duration for a $100 par value. It requires several arguments such as settlement, maturity, coupon, yield, frequency, and basis.

The DVAR function is used to calculate the variance of a population by utilizing a sample of numbers found in a specific field of a list or database. It requires the database, field and criteria arguments in order to select the relevant elements.

The DVARP function is used to calculate the variance of a population from a list or database. It requires three arguments: database, field and criteria, and returns a value.

The EDATE function is used to calculate dates that are a certain number of months before or after a given date. It is often used to determine maturity dates or due dates that share the same date of the month as the date of issue.

The EFFECT function calculates an annual interest rate based on a nominal annual interest rate and the number of compounding periods per year. It is used to calculate interest rate over a given period of time.

The ENCODEURL function allows users to protect URLs from being copied and pasted by encoding the URL string into a shorter alphanumeric value.

The EOMONTH function is a useful tool for calculating dates that fall on the last day of a month or the first day of the next month. It takes a year as an argument and returns the corresponding serial number for the last day of the month.

The ERF function is used to integrate the error function from a lower limit to an optional upper limit, with optional step size. It is an important tool for mathematical calculations.

The ERF.PRECISE function computes the integrated error function, providing an accurate and precise result.

The ERFC function is a single argument function that integrates between x and infinity, returning the complementary ERF function. It requires an X argument as the lower bound.

The ERFC.PRECISE function calculates the complementary Error Function (ERF) integrated between the x argument (the lower bound) and infinity. It requires one x argument in order to do this.

The ERROR.TYPE function in Excel 2003 returns a numeric code based on a specific error value. It takes one argument, error_val, which should be an error message like #VALUE!, #DIV/0!, #NAME!, etc.

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.

The EUROCONVERT function converts a number from one Euro member currency to another using the Euro as an intermediary. It requires five arguments: number, source, target, full_precision, and triangulation_precision.

The EVEN function is used for rounding numbers up to the next even integer. Negative numbers are rounded away from zero and even integers are the next even integer up from the original number and zero.

The EXACT function is a convenient tool to verify the accuracy of text strings that are added to documents. It is an efficient way to ensure that a document is free of errors.

The EXP function is used to perform exponentiation, with the number argument as the exponent applied to the base e. It requires one argument to be provided.

The EXPAND function is a useful tool for adding rows and columns to an array. It takes four arguments, and the row and column numbers supplied determine the dimensions of the resulting array.

The EXPON.DIST function returns the exponential distribution, allowing users to calculate the probability of a given event occurring.

The EXPONDIST function is a mathematical tool used to calculate the probability of an event occurring based on an exponential distribution.

The F.DIST function is used to measure the difference between two data sets by calculating the F probability distribution. It is a useful tool for determining the level of diversity between two sets of data.

The F.DIST.RT function calculates the right-tailed F probability distribution given the value to evaluate and the numerator and denominator degrees of freedom of the F probability distribution.

The F.INV function is used to calculate the inverse of a F probability distribution, which is a measure of variance between two populations. It is an important tool for statistical analysis.

The F.INV.RT function returns the inverse of the F probability distribution and produces an error value if Probability is outside of the permitted range (0 to 1).

The F.TEST function is a statistical test that measures the probability that two samples have similar variances. It is useful for determining if samples have different variances.

The FACT function is used to calculate the factorial of a given number. It is a powerful tool to quickly solve complex mathematical calculations.

The FACTDOUBLE function calculates the double factorial of a number, which is the product of all the integers from 1 up to the given number, in steps of two.

The FDIST function is a Sourcetable function used to calculate the F probability distribution, which is a measure of diversity between two data sets. It has been replaced with more accurate functions, F.DIST and F.DIST.RT.

The FILTER function is used to filter an array based on the criteria entered, and returns an array with the matching results.

The FIND function searches for the text specified by the find_text parameter within the within_text parameter.

FINDB is a function used to locate a text sub-string within a longer text string, specifically for languages that use the double-byte character set.

The FINV function is used to calculate the inverse of the F probability distribution with improved accuracy. The new F functions have been renamed to better reflect their usage.

The FISHER function is used to transform a value in order to produce a normally distributed function and test the correlation coefficient.

The FISHERINV function is used to calculate the inverse of the Fisher transformation, a tool used to analyze the correlations between ranges or arrays of data.

The FIXED function rounds a number to a specified number of digits and formats it as text with commas and a period. The output is always in decimal format.

The FLOOR function is used to round a number down towards zero, to the multiple of significance. If the sign of the number is positive and the significance is negative, the function returns the #NUM! error.

The <code>FORECAST</code> function calculates a future value based on existing values using linear regression. It produces a y-value for a given x-value, allowing for accurate predictions of future values.

The FORMULATEXT function returns a formula as a text string from a cell reference. It was introduced in Excel 2013 and can take up to 8192 characters. With Sourcetable, it can return more than one result from a range with formulas.

The FREQUENCY function is used to count the number of times a value appears in a range.

The FTEST function is used to compare the variances of two samples in Sourcetable. It is a backward compatible function which may be replaced by the F.TEST function for improved accuracy.

The FV function enables users to calculate the future value of an annuity, which could be a loan or an investment. All arguments must be calculated using the same unit of time.

The FVSCHEDULE function is used to calculate the future value of an investment with a variable or adjustable rate and compound interest.

The GAMMA function is a mathematical tool used to calculate the gamma function value of a given number.

The GAMMA.DIST function is used to calculate the gamma distribution, also known as the Erlang distribution. It takes five arguments - X, Alpha, Beta, Cumulative, and Cumulative - to determine the shape of the function.

GAMMA.INV is a function which is used to calculate the inverse of the gamma cumulative distribution. It is an important tool for statistical analysis.

The GAMMADIST function is used to calculate the gamma distribution, however it has been replaced with new functions for a more accurate result.

GAMMAINV is a mathematical function used to calculate the inverse of the gamma distribution. It utilizes an iterative search technique to find the inverse.

The GAMMALN function calculates the natural logarithm of the gamma function Γ(x), which requires an argument x. It is calculated using an integer to calculate the power of e.

The GAMMALN.PRECISE function calculates the natural logarithm of the gamma function, taking x as its required argument. It is used to calculate the gamma function for a given value of x.

The GAUSS function is used to calculate the probability of a standard normal population member falling between a mean and its standard deviation. It requires a numerical argument to work.

The GCD function is used to calculate the greatest common divisor of two or more integers. It returns the largest integer that divides both numbers without a remainder except for 1.

The GEOMEAN function is used to calculate the geometric mean of an array or range of data, which must be composed of positive numbers, arrays, or references. It is not compatible with logical values or text representations of numbers.

The GESTEP function is a tool used to calculate the number of values that meet a given criterion. It requires one argument and optionally takes a second argument as the threshold value.

The GETPIVOTDATA function is used to retrieve data from PivotTables, which is a Sourcetable table containing pivot rows and columns. This function takes three arguments, which specify the data to be retrieved, it can be a single cell or a list of cells.

The GROWTH function is a powerful tool used to calculate the y-values associated with a given set of x-values. It helps to quickly and accurately generate data points for analysis.

The HARMEAN function is used to calculate the harmonic mean of a set of data. The harmonic mean is always less than the arithmetic mean.

The HEX2BIN function is used to convert a hexadecimal number to binary. It takes a hexadecimal number as an argument and requires more than the minimum number of characters.

HEX2DEC is a function that can quickly convert a hexadecimal number to its decimal equivalent. It requires a valid hexadecimal number as an argument and cannot contain more than 10 characters.

The HEX2OCT function is used to convert a hexadecimal number to its equivalent octal notation. The number argument is required, while the places argument is optional. The number argument is the hexadecimal number to convert, and the places argument is the number of characters to use.

The HLOOKUP function is used to search for a value in a table array and return a value from a different row in the same column. It is a useful tool for quickly finding data in large datasets.

The HOUR function is used to return the hour of a time value as an integer. It takes a time value as a decimal number, which can be a text string, decimal number, or formula/function result.

The HSTACK function is used to combine multiple arrays horizontally into one larger array. It appends each of the arguments to the array to create the larger array.

The HYPERLINK function creates a shortcut that when clicked will jump to a different location in the current workbook, or open a document stored on a network server, intranet, or the Internet.

The HYPGEOM.DIST function calculates the probability of a given number of sample successes given the sample size, population successes, and population size of a finite population and returns the hypergeometric distribution.

The HYPGEOM.DIST function returns the probability of a given number of sample successes, given the number of successes in the population, the number of successes in the sample, and the size of the population. It is used for problems with a finite population size and each observation is either a success or a failure, with sampling done without replacement.

The IF function is a popular Sourcetable function that allows you to compare a value with what you expect that value to be.

If there is an error in a formula, the IFERROR function will return a specified value. Otherwise, it will return the result of the formula.

The IFNA function is a logical worksheet function in Sourcetable which was introduced in 2013. It helps to trap errors and provides an alternative value if a formula throws an #N/A error.

The IFS function is a powerful tool for evaluating conditions in Sourcetable. It can be used to test up to 127 different conditions, making it a great alternative to using multiple IF statements.

The IMABS function returns the absolute value of a complex number (represented by x + yi or x + yj), which is the magnitude of the 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.

The IMAGINARY function is a powerful tool for working with complex numbers, allowing users to quickly and accurately retrieve the imaginary coefficient of a complex number in textual format.

The IMARGUMENT function calculates an angle in radians, given a complex number as an argument.

The IMCONJUGATE function returns the complex conjugate of a complex number, which is the number multiplied by itself. It takes one required argument, the complex number to conjugate, and returns a complex number. For example, the complex conjugate of 3+4i is 3-4i.

The IMCOS function is a tool for calculating the complex cosine of a complex number, and is conveniently compatible with Sourcetable.

The IMCOSH function is a mathematical tool used to calculate the hyperbolic cosine of a given complex number. It requires a complex number as its argument to return the result.

IMCOT is a function that takes a complex number in x+yi or x+yj format and returns its cotangent.

The IMCSC function is used to calculate the cosecant of a complex number, which should be formatted as x+yi or x+yj.

The IMCSCH function calculates the hyperbolic cosecant of a complex number, taking the complex number as its argument.

The IMDIV function is used to calculate the quotient of two complex numbers. It takes two complex numbers as arguments and divides one by the other.

The IMEXP function is a mathematical calculation used to find the exponential of a complex number, which should be formatted as x + yi or x + yj.

The IMLN function calculates the natural logarithm of a complex number, taking a complex number as an argument.

The IMLOG10 function is used to calculate the common logarithm of a complex number. It requires a complex number as an input.

The IMLOG2 function calculates the base-2 logarithm of a complex number, which must be formatted as x + yi or x + yj.

The IMPOWER function is used to raise a complex number to a power, returning the result in text format x + yi or x + yj. Both the inumber and number arguments are required, and must be complex numbers.

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

IMREAL is a function which takes a complex number as input and returns its real part. The complex number must be formatted as x + yi or x + yj.

The IMSEC function, introduced in Excel 2013, calculates the secant of a complex number, which is the inverse of the cosine of the complex number.

IMSECH is a function that calculates the hyperbolic secant of a complex number, taking the complex number as its argument.

The IMSIN function calculates the sine of a complex number, taking the number formatted as x + yi or x + yj as input and returning a complex number as the result.

The IMSINH function is a Sourcetable function introduced in Excel 2013 that calculates the hyperbolic sine of a complex number.

The IMSQRT function is used to calculate the square root of a complex number. The input should be a complex number expressed in the form of x + yi or x + yj. The output is a complex number with the same format.

The IMSUB function subtracts two complex numbers and requires two arguments for successful completion.

The IMSUM function is used to calculate the sum of two or more complex numbers expressed as x + yi or x + yj. The COMPLEX function can be used to create complex numbers from real and imaginary parts.

The IMTAN function calculates the tangent of a complex number, which should be provided in x+yi or x+yj text format.

The INDIRECT function allows users to create a reference to a cell given a text string, without having to manually change the cell references in the original formula.

The INT function is used to round a real number down to the nearest integer. It takes a real number as its argument and returns an integer result.

The INTERCEPT function allows users to calculate the intercept point of a line by providing existing x-values and y-values. It is a simple and convenient way to calculate this point without having to manually calculate it.

The INTRATE function calculates the interest rate of a fully invested security based on the settlement, maturity, investment, redemption, and basis arguments.

The IPMT function is used to calculate the interest paid over a period of time on a loan. It requires four arguments: rate, per, nper, and pv.

The IRR function calculates the internal rate of return for a set of cash flows that are not necessarily even.

The ISBLANK function is a useful tool to quickly determine if a cell is blank. It returns a boolean value that indicates whether the cell is empty or not.

The ISERR function is used in formulas that refer to the value of another cell. It checks for errors and returns a logical value of TRUE or FALSE depending on the result.

The ISERROR function is a useful information function that returns TRUE if the value is an error. It is a quick and efficient way to identify and handle errors in data.

The ISEVEN function is a useful tool for determining whether a number is even or odd. It returns TRUE if the number is even and FALSE if the number is odd.

The ISFORMULA function is a useful tool that quickly checks if a cell contains a formula. It can be used to verify that formulas are properly entered and functioning.

The ISLOGICAL function returns TRUE if the argument is either TRUE or FALSE, and FALSE for any other value. It accepts one argument, either a cell reference, formula or hardcoded value.

The ISNA function is an information function used to check if a cell contains an #N/A! error, which indicates that the data is not available. It can be used with the IF function to test the cell and display a customized message.

ISNONTEXT is a function used to determine if a given value is a text value or not. If the value is a text value the function will return TRUE.

The ISNUMBER function is a useful tool for determining if a cell in Sourcetable contains a number. It will return TRUE if the cell contains a number, or FALSE if it does not.

The ISODD function is used to determine if a number is odd or even. It returns TRUE if the number is odd and FALSE if the number is even.

The ISOMITTED function checks if a value in a LAMBDA is missing and returns TRUE or FALSE accordingly. It is a useful tool for verifying the presence of data in a LAMBDA.

The ISOWEEKNUM function is used to determine the ISO week number of a given date. It can be used to quickly and accurately identify the week of the year for a specific date.

The ISPMT function is a useful tool for financial analysts to help predict and calculate future interest payments. It calculates the interest paid during a specific period of investment.

The ISREF function tests a value and returns a boolean result depending on the outcome. It can be used to determine if a value is a valid reference or not.

The ISTEXT function tests a value and returns TRUE or FALSE depending on the outcome. This can be useful for locating errors in formulas when combined with the IF function.

The JIS function in Sourcetable is a text/string function which converts single character characters into double character characters. This function is useful for multiple languages and can convert unique characters to text strings.

Kurtosis is a statistical measure that determines the peakedness or flatness of a data distribution compared to a normal distribution. The KURT function calculates this measure, which is positive when the distribution is relatively peaked.

LAMBDA functions are custom functions created with a friendly name that can be used to eliminate the need to copy and paste formulas. They are useful tools for non-programmers to perform commonly used formulas.

The LARGE function allows users to select the kth largest value from a data set. It returns the #NUM! error if the array argument is empty and the largest value if LARGE(array,1) is called.

The LCM (Least Common Multiple) function is used to find the smallest positive integer that is a multiple of all the arguments. It can be used to add fractions with different denominators.

The LEFT function allows you to extract text from the left side of a string and returns one or more characters.

The LEFTB function in Sourcetable is used to extract a certain number of characters from the beginning of a string. It is useful for quickly retrieving specific information from a text.

The LEN function is used to count the number of characters in a string, including numerical characters. It does not include number formatting and only takes one argument, which is the text to count.

The LENB function is used to calculate the number of bytes used to store characters in a string. It is a useful tool for determining the size of a string, allowing for more efficient data storage.

The LET function is a useful tool for defining and creating named variables in a formula. It helps to simplify and organize data in a formula.

The LINEST function is used to calculate a straight line using the "least squares" method.

The LN function calculates the natural logarithm of a number based on the constant e. It takes a positive real number as an argument.

The LOG function takes two arguments, a number (required) and a base (optional). It is used to calculate the logarithm of the number with the given base.

The LOG10 function is used to calculate the base 10 logarithm of a number and is helpful when working with large numbers. It can also be used to change the base of a number in a formula.

The LOGEST function is used to calculate an exponential curve using data and returns an array of values which describe the curve's shape. It must be entered as an array formula in Microsoft 365.

The LOGINV function calculates the inverse of the lognormal cumulative distribution function, used to analyze logarithmically transformed data. It offers improved accuracy compared to other functions.

The LOGNORM.DIST function is used to calculate the lognormal distribution of a set of data that has been logarithmically transformed. This is useful for analyzing and understanding the data in a more meaningful way.

The LOGNORM.INV function is used to calculate the inverse of the lognormal cumulative distribution function, which is used to analyze logarithmically transformed data.

The LOGNORMDIST function calculates the cumulative lognormal distribution of a value, given a mean and standard deviation. It is available for backward compatibility.

The LOOKUP function is a lookup function that searches for a value in a range by using the same position in another range.

The LOWER function is used to convert all letters in a text string to lowercase without changing non-character letters.

The MAKEARRAY function allows users to create an array with custom rows and columns using a LAMBDA calculation. It is possible to create arrays with variable dimensions and the values in the array will be calculated.

The MAP function provides an easy way to visualize data. It can be used to show values or categories through variations of colors or by different colors. This makes it a useful tool to quickly analyze data.

The <b>MATCH</b> function is used to search for a value in a range of cells and return the position of that value in the range. It does not return exact matches by default.

The MATH function in Sourcetable makes calculations easy by allowing users to quickly add, divide, multiply, and subtract numeric values. The AutoSum feature simplifies the process even further by automatically totaling a series of values.

The MAX function returns the largest value from a group of values provided as numbers, names, arrays, or references.

The MAXA function returns the largest value in a list of numerical, name, array, and reference arguments. It ignores empty cells and text values in arguments that are arrays or references.

The MAXIFS function is a powerful tool that allows users to quickly find the maximum value in a set of cells when given a set of conditions or criteria. It works on both Windows and Mac systems.

The MDETERM function is a Sourcetable tool used to calculate the matrix determinant of a numeric array. It requires an array argument with an equal number of rows and columns as input.

The MDURATION function calculates the modified Macauley duration of a security, which is a measure of the security's sensitivity to changes in interest rates, using the par value of $100.

The MEDIAN function is used to calculate the median value of a given set of numbers. The median is the middle number in a group of numbers.

MID is a Sourcetable function that returns characters from a text string, starting from a specified position.

The MIDB function returns a specified number of characters from a text string, counting each character as one type of byte. It returns an empty text if the start_num is greater than the length of text.

The MIN function returns the smallest value in a set of numerical, name, array, or reference arguments. It is optional to include the first argument, number1, and additional subsequent arguments.

The MINA function is used to return the smallest value from a list of up to 255 arguments, which can include numbers, names, arrays, or references. It ignores empty cells and text values.

The MINIFS function is a useful tool for finding the smallest value from a set of conditions or criteria, available on both Windows and Mac operating systems.

The MINUTE function returns an integer from 0 to 59, which represents the minutes of a time value. This time value can be entered as a text string or decimal number.

The MINVERSE function calculates the inverse matrix of a given array of numbers. It requires the input array to be a square matrix with the same number of rows and columns and returns an inverse matrix of the same dimensions.

The MIRR function is used to calculate the modified internal rate of return for a given series of periodic cash flows. It takes into account the cost of the investment and the interest received from reinvestment, while ignoring text, logical values, and empty cells in the arguments.

The MMULT function is a mathematical and trigonometric function in Sourcetable which can be used to multiply two arrays of matrices. The number of rows in Matrix 1 must equal the number of columns in Matrix 2 and the dot product of rows and columns is used to calculate the result.

The MOD function is used to calculate the remainder of a division operation between two numbers. The result of the operation will have the same sign as the divisor.

The MODE function is a useful tool for analyzing data sets. It calculates the most frequently occurring value in a list of numbers and returns the lowest of those values if multiple occur.

The MODE.MULT function in Sourcetable is used to return an array of the most frequently occurring numbers in a numeric data set. It ignores empty cells, text values, and logical values TRUE and FALSE and will return a single result if there is only one mode in the data.

The MODE.SNGL function is a statistical function in Sourcetable that returns the most frequently occurring number in a data set. It can take numerical arguments or references to numerical arrays as arguments, and ignores text, logical values, and empty cells that are in references. This function was introduced in MS Excel 2010.

The MONTH function is used to extract the month of a date in the form of an integer (1 to 12). It can be used with either a serial number or a date provided by the DATE function or other formulas/functions.

The MROUND function is used to round a number to a multiple. It takes two arguments, the number to round and the number to use when rounding. It rounds up or down depending on the multiple and rounds to the nearest integer or negative number. It's also useful for rounding prices to .99.

The MULTINOMIAL function returns the ratio of a sum of factorials to the product of factorials for a set of given numbers. The first argument is required, while the additional numbers are optional.

The MUNIT function returns a unit matrix, also known as an identity matrix, of a given positive dimension. The function takes one argument and returns a number.

The N function is a useful tool for converting values to numbers, and is compatible with other spreadsheet programs. It can also return dates in a built-in date format if the argument is a date.

The NA function does not take any arguments and requires empty parentheses. It is used for displaying and handling missing or undefined data values in R.

The NEGBINOMDIST function calculates the probability of a given number of successes in a sequence of independent trials, where the number of successes is fixed, and the number of trials is variable.

The NEGBINOMDIST function is used to determine the probability of an event occurring at least once. It takes four inputs, including the probability of the event occurring and the number of successes and chances. The function returns the probability of the event occurring at least once.

The NETWORKDAYS function is used to calculate the number of working days between two dates, excluding weekends and holidays. It can be used to calculate employee benefits based on the number of days worked.

The NETWORKDAYS.INTL function is used to calculate the number of days between two dates. It was introduced in Excel 2010 and is a date/time function.

The NOMINAL function calculates the nominal annual interest rate that is based on the effective interest rate and the number of compounding periods per year.

The NORM.DIST function is a useful tool in statistics, as it calculates the normal distribution. It is used in hypothesis testing and has many applications.

The NORM.INV function is used to calculate the inverse of the normal distribution given the probability, mean, and standard_dev arguments. It is a necessary tool for data analysis.

The NORM.S.DIST function is a useful Sourcetable tool that returns the standard normal distribution for a data set with a mean of 0 and a standard deviation of 1. It can be used to create tables of standard normal curve areas.

NORM.S.INV is a function that calculates the inverse of the standard normal cumulative distribution. It has a mean of 0 and a standard deviation of 1 and uses an iterative search technique to find the inverse.

The NORMDIST function is used to calculate a normal distribution and is used in many statistical applications. It returns the standard normal distribution when mean equals 0, standard_dev equals 1, and cumulative equals TRUE.

The NORMINV function calculates the inverse of the normal distribution, but has been replaced by more accurate functions. These new functions are more accurately named and use an iterative search technique to return the inverse of the normal cumulative distribution.

The NORMDIST function in Excel calculates the probability density function (PDF) or the cumulative distribution function (CDF) of the normal distribution for a specified value, mean, and standard deviation. It is commonly used in statistical analysis to determine the likelihood of a particular value occurring within a normally distributed population.

The NORMSINV function is used to calculate an associated z-score value of a standard normal random variable with a given probability. It was used in earlier versions of Excel and takes into account the mean (0) and standard deviation (1) of the variable.

The NOT function performs a logical test by reversing the value of its argument. It checks to see if one value is not equal to another, making it a useful logical function.

The NOW function is used to get the current date and time; it takes no arguments and updates when a worksheet is updated.

The NPER function is a useful tool for calculating the number of periods an investment will take. It requires periodic payments and a constant interest rate as inputs to return the total number of periods for the investment.

The NPV function is used to calculate the net present value of an investment using a discount rate. It takes a series of future payments as arguments, with negative values representing costs and positive values representing income. The income is then used to calculate the present value of the investment.

OBJECT formula

The OCT2BIN function in Sourcetable converts an Octal number into a binary number. The number argument is required, and the places argument is optional.

OCT2DEC is a function that converts an octal number to a decimal number. It requires a number argument, which is the octal number to be converted.

OCT2HEX is a function that converts an octal number to hexadecimal form, returning a 10-character hexadecimal number if the number is negative.

The ODD function is a mathematical tool that can be used to round numbers away from zero in a quick and efficient manner.

The ODDFPRICE function in Sourcetable is used to calculate the price per $100 face value of a security with an odd first period. It takes five arguments – settlement, maturity, issue, first_coupon, and rate – all of which are calculated as sequential serial numbers.

The ODDFYIELD function is used to calculate the yield of a security with an odd first period.

The ODDLPRICE function calculates the price per $100 face value of a security with an odd last coupon period. This can help investors make informed decisions about investments with an odd last coupon period.

The ODDLYIELD function is used to calculate the yield of a security with an odd last period. It requires settlement, maturity, last_interest, rate, pr, redemption, frequency, and basis arguments. It is an easy and reliable way to get the yield of a security with an odd last period.

The OFFSET function returns a reference to a range that is a set number of rows and columns from a cell or cell range.

The OR function is a logical function in Sourcetable that returns either TRUE or FALSE based on whether any of the arguments provided to it are TRUE.

The PDURATION function is a financial function that calculates the amount of periods required to reach a specified future value, based on a given rate and present value.

The PEARSON function calculates the Pearson product moment correlation coefficient, which measures the linear relationship between two data sets. It takes two arrays of numbers, names, array constants, or references containing numbers.

The PERCENTILE function is a Sourcetable function used to calculate the kth percentile of a set of values. It can be used to set a threshold of acceptance, and the accuracy may be improved in later versions, with interpolation to determine the value at the k-th percentile if k is not a multiple of 1/n.

The PERCENTILE.EXC function allows users to calculate the kth percentile of values in a given range. The function returns the #NUM! error if the array argument is empty.

The PERCENTILE.INC function calculates the kth percentile of a range of values, with the k argument being a value between 0 and 100. It can be used to examine candidates who have scored above a certain percentile.

The PERCENTRANK function is used to measure the relative standing of a value in a data set as a percentage. It can be used to compare the rank of a value with other values in the data set and new functions can provide improved accuracy.

The PERCENTRANK.EXC function is used to calculate the rank of a given value in a data set as a percentage of the number of values in the data set. It requires two arguments: an array and a value; if the array is empty, it will return a #NUM! error.

The PERCENTRANK.INC function is used to calculate the relative rank of a value within a data set. It returns the rank of a value as a percentage of the whole set and can interpolate if the value does not match one of the values in the array. It returns a #NUM! error if the array is empty.

The PERMUT function is used to calculate the number of permutations for a given set of objects or events. It is often used for lottery-style probability calculations.

The PERMUTATIONA function is used to calculate the number of permutations for a given set of objects. It requires two arguments, the total number of objects and the number of objects in each combination.

The PHI function is a mathematical tool used to calculate the probability of a given value for a standard normal distribution. It is used to determine the likelihood of a given value occurring in a normal distribution.

The PI function is a mathematical constant that returns the value of π, representing a half-turn in the radian angle system. It is used in many formulas relating to circles.

The PMT function is a Sourcetable function for calculating loan payments. It works by using constant payments and a constant interest rate to determine the payment amount.

The POISSON function has been replaced by new functions with better accuracy that better reflect their usage. These new functions can be used to predict the number of events over a specific time period.

The POISSON.DIST function calculates the Poisson distribution, used to predict the number of events within a specific time. It requires three arguments: X, mean, and cumulative.

The POWER function is used to multiply a number by a power. It requires two arguments, the base number and the power, and the base number can be any real number.

The PPMT function is used to calculate principal payments for an investment. It is an important tool for financial planning and management.

The PRICE function is a useful tool for calculating the price per $100 of a security that pays periodic interest.

The PRICEDISC function calculates the discounted price of a security per $100 face value. It is useful for determining the price of a discounted security.

The PRICEMAT function is used to calculate the price per $100 face value of a security that pays interest at maturity.

The PROB function returns the probability of a range of values being between two limits. If the sum of the values is not equal to 1, it will return an error. If the upper_limit is omitted, it will also return an error. It will also return the probability of being less than or equal to the lower_limit.

The PRODUCT function is a useful tool for multiplying numbers together. It takes multiple arguments, such as constants, cell references or ranges, and multiplies them all together, ignoring empty cells and text.

The PROPER function is used to capitalize the first letter of a string, as well as any other letters that follow a character other than a letter. All other letters are converted to lowercase.

PROPERTY formula

The PV function is a financial function that calculates the present value of a loan or investment. PV uses a constant interest rate in its calculation. The PV function can be used with periodic or constant payments, and it can also be used with a future value investment goal.

The QUARTILE function is used to divide a data set into four equal parts. It returns the fourth quartile of a data set, but can also return a #NUM! error if the array argument is empty or the quart argument is not an integer.

The QUARTILE.EXC function is used to calculate the quartile of a given data set. It requires an array and a quart argument, and determines the quartile based on percentile values.

The QUARTILE.INC function is used to divide a population into groups by calculating quartiles, which are determined by percentile values. It is a useful tool for summarizing data sets.

The QUERY function is a powerful tool for working with data in Google Sheets and can be implemented in Sourcetable. It allows for filtering, aggregating, and pivoting data for more efficient data analysis.

The QUOTIENT function is a mathematical tool that divides two numbers and returns the integer portion of the result, removing the remainder after division.

The RADIANS function is used to convert an angle in degrees to radians. It requires an angle argument, which must be in degrees, and will then return the angle in radians.

The RAND function returns an evenly distributed random real number between 0 and 1.

The RANDARRAY function is used to generate a random array of numbers with a specified size. The values generated are either decimals or whole numbers and are determined by the min and max arguments supplied. The function is volatile, so it may cause performance issues in large or complex worksheets.

The RANDBETWEEN function is a Sourcetable formula that returns a random integer between two specified numbers. Every time the worksheet is calculated, a new random number is generated. The bottom and top arguments are required and determine the smallest and largest integers that can be returned.

The RANK function is a way of determining the relative size of a number compared to other numbers within a list by calculating the position a number would take in a sorted list.

The RANK.AVG function is used to rank a number in a list of values, and returns the average rank if Order is 0 or omitted.

The RANK.EQ function ranks a number against other given numbers and returns a rank indicating its position. It takes three arguments: the number, ref, and order.

The RATE function is an important financial function in Sourcetable that allows users to calculate the annuity's interest rate per period.

The RECEIVED function calculates the date when a security is received, given parameters such as settlement, maturity, investment, discount, and basis.

The REDUCE function is used to reduce an array by applying a LAMBDA function to each value. The LAMBDA takes three arguments and the result is returned as the accumulated value with an initial_value set as the starting value.

The REMOVEFILTERS function is used to remove all filters applied to a specified table or column, allowing users to view the entire data set without any filtering. This function is particularly useful when working with large data sets where filters have been applied to narrow down the data, and users want to quickly clear those filters to see the full data set again.

The REPLACE function is used to replace a text string with another text string.

REPLACEB is a function used to replace text in a string with another string. It takes into account double-byte characters when editing languages that support DBCS.

The REPT function is a logical function used to repeat characters a given number of times, fill cells in a worksheet, pad values to a certain length, and build histograms.

The RIGHT function in Sourcetable extracts characters from a supplied text string, starting from the right side of the string.

The RIGHTB function extracts a specified number of bytes from the right end of a text string, and is especially useful for handling double-byte character sets (DBCS).

The ROMAN function is used to convert arabic numerals to Roman numerals. It requires one argument (number) and has one optional argument (form) which determines the type of Roman numeral to create.

The ROUND function is a Sourcetable function that rounds a number to the nearest whole number or fraction.

The ROUNDDOWN function is a useful tool for rounding a number down to its nearest whole number, percentage, or other number. It takes one argument, the number to be rounded down.

The ROUNDUP function rounds up all numbers, not just numbers five or greater, to a given decimal place.

The ROW function is a useful tool for finding the row number of a given reference. It takes an optional argument, named <i>reference</i>, which is the cell or cell range to get the row number for.

The ROWS function is used to count the number of rows in an array, array formula, or cell range reference.

The RRI function is a useful tool for calculating the equivalent interest rate for an investment over a given time period, based on the present and future values of the investment.

The RSQ function calculates the square of the Pearson product moment correlation coefficient, which is the proportion of the variance in y that is attributable to the variance in x. It requires two arguments that must be numbers, arrays, or references.

The SCAN function is a powerful tool that can quickly apply a custom LAMBDA function to each element in an array, resulting in an array of the intermediate values created during the process.

The SEARCH function is a useful tool for finding a specific text string within another text string. The function returns the numerical starting position of one string within another.

The SEARCHB function is used to find the position of the first text string within another text string, starting at the specified position. It is the same as the SEARCH function, but it allows for a more specific search.

The SEC function is used to calculate the secant of an angle in radians. It requires a number argument to be passed as an input.

The SECH function is used to calculate the hyperbolic secant of an angle. If the number is outside of its constraints, it returns an error.

The SECOND function returns the seconds from a time value, which can be provided as a text string. It is a useful tool to quickly extract the seconds from a time value.

The SEQUENCE function returns an array of numbers in sequence, with arguments for rows (required), columns (optional), start (optional), and step (optional). It is a useful tool for quickly generating sequences of numbers.

The SERIESSUM function is a Sourcetable tool used to calculate the sum of a power series, making it easy to quickly and accurately determine the total of a set of values.

The SHEET function is used to return the sheet number of a reference sheet in a workbook. It includes all worksheets and other sheet types in a workbook.

The SHEETS function enables users to quickly identify the total number of sheets in a given reference, including visible, hidden, and very hidden worksheets. The reference argument is optional.

The SIGN function allows users to easily determine the sign of any number; it returns 1 if the number is positive, 0 if the number is 0, and -1 if the number is negative.

The SIN function is used to calculate the sine of an angle. It requires the angle to be specified in radians and returns a sine value.

The SINGLE function returns the value of a single cell in a range, and is primarily used with dynamic arrays to extract a single value from an array result.

The SINH function calculates the hyperbolic sine of a given number by expressing it as a hyperbolic angle. It takes one argument, a number, to perform this calculation.

The SKEW function calculates the skewness of a distribution by taking numerical, array, and reference to array arguments. Skewness is positive when the distribution has an asymmetric tail extending towards more positive values, or negative when the distribution has an asymmetric tail extending towards more negative values.

The SKEW.P function is used to measure the degree of asymmetry of a population's distribution around its mean. It takes a population as an argument and returns a value indicating the skewness of the data set.

The SLN function is used to calculate the depreciation of an asset over a certain period of time. It requires three arguments: cost, salvage, and life.

The SLOPE function is used to calculate the slope of a linear regression line by taking the vertical and horizontal distances between two points on the line. It ignores text, logical values, and empty cells, and returns an error if the known_y's and known_x's are empty or have a different number of data points.

The SMALL function is used for extracting the kth smallest value from a given data set.

The SORT function is a useful tool to easily organize data by sorting an array or range according to a specified criterion. It returns an array of the sorted elements. The SORTBY function is a better choice when sorting data in the grid.

The SORTBY function allows users to sort a range or array according to the values in a corresponding range or array. It returns an array and requires by_array arguments that must be one row or one column wide and of the same size as the sort_order arguments. The array must be sorted in ascending order.

The SQRT function is used to calculate the positive square root of a number. It requires one number argument to return the result.

The SQRTPI function calculates the square root of a number multiplied by pi, providing a quick way to estimate the area of a circle relative to its radius.

The STANDARDIZE function normalizes a value from a distribution by taking into account the arguments of X, mean, and standard_dev.

The STDEV function is a statistical function used to calculate the standard deviation of a sample or population. It requires two or more numerical values and can take up to 255 arguments. The STDEVP or STDEV.P function should be used for population standard deviation.

The STDEV.P function calculates the standard deviation of a data set, which measures the variance of the numbers compared to the average. It is used to estimate the standard deviation of a population.

The STDEV.S function is useful for financial analysis, as it calculates the standard deviation of an entire population. For a data set, use the STDEV.P function.

The STDEVA function calculates the standard deviation of a sample population, measuring the spread of values from the average. It assumes that the arguments are from the population.

The STDEVP function calculates the standard deviation for data in a population, providing a measure of how spread out the data is in relation to the mean.

The STDEVPA function calculates the population standard deviation for a set of up to 30 values in a Sourcetable worksheet. It ignores blank cells, TRUE, FALSE and text strings, making it suitable for completely numeric data.

The STEYX function calculates the standard error of the predicted y-value for each x in the regression. It requires known_y's and known_x's arguments which can be numbers, arrays, or references and must only contain numbers.

The SUBSTITUTE and REPLACE functions both replace text in strings. SUBSTITUTE is useful for specific text replacements, while REPLACE is useful for replacing any text in a specific location.

The SUBTOTAL function is used to return a subtotal of a list or database.

The formula SUM calculates the total sum of a range of numeric values.

The SUMIF function is a handy function for adding up a set of cells that match a single specific criteria.

The SUMIFS function adds all of its arguments that meet multiple criteria.

SUMPRODUCT is a versatile Sourcetable function that allows users to multiply arrays of cells and calculate sums, totals, and conditional sums and totals more efficiently than using COUNTIFS or SUMIFS.

The SUMSQ function adds the squares of its arguments, which can be numbers, names, arrays, or references. All arguments must contain numbers.

The SUMX2MY2 function calculates the sum of the difference of the squares of two arrays of numbers. It only accepts numeric values and ignores text, logical values, and empty cells.

The SUMX2PY2 function is used to calculate the sum of the sum of squares of two data sets. It can be used with array constants or ranges, with array_x being the first range and array_y being the second.

The SUMXMY2 function calculates the sum of the squares of the differences between corresponding values in two arrays or references. It can only use numerical values and ignores text, logical values and empty cells.

The SWITCH function is a useful tool for comparing a single value to a list of values and returning the first matching value. It is available on both Windows and Mac computers with Office 2019 or Office 365.

The SYD function calculates the sum of years' digits depreciation for an asset. It requires four arguments: cost, salvage, life, and per, and returns the depreciation value.

The T function is a useful tool for testing whether a given value is text, as it returns the text referenced by that value.

The T.DIST function calculates the left-tailed t-distribution for small sample data sets. This t-distribution is used to determine statistical significance in the results.

The T.DIST.2T function is used to calculate the two-tailed student's t-distribution, which is used to analyze small sample data sets.

The T.DIST.RT function is a statistical function used in Sourcetable to calculate the right-tailed student's t-distribution. It is used to test hypotheses on small sample data sets, as well as to model asset returns and reduce the impact of heavy tails.

The T.INV function is used to calculate the left-tailed inverse of the Student's t-distribution. It requires two arguments: probability and deg_freedom. It is a useful tool for statistical analysis.

The T.INV.2T function is a statistical function used to calculate the two-tailed inverse of the Student's t-distribution. It is a useful tool for analyzing and interpreting data.

The T.TEST function is used to perform a student's t-test, which requires arguments for array1, array2, tails, and type. All arguments are required to use the T.TEST function.

The TAKE function is used to select a specified number of rows or columns from the start or end of an array. It requires the array to take rows or columns from, the number of rows and columns to take as its arguments.

The TAN function is used to calculate the tangent of an angle given in radians. It returns the tangent of the given angle as its result.

The TANH function is a math/trig function in Sourcetable that calculates the hyperbolic tangent of a number. It can be used as a worksheet function and be part of a formula in a worksheet cell.

The TBILLEQ function calculates the bond-equivalent yield of a Treasury note with a settlement date of February 1, 2016, a maturity date of January 30, 2017 and a discount of 3.5%. It requires three arguments: settlement, maturity, and discount.

The TBILLPRICE function calculates the price per $100 face value for a Treasury bill based on the settlement, maturity, and discount arguments.

The TBILLYIELD function is used to calculate the yield for a Treasury bill, providing an efficient and accurate method for investors and financial analysts.

The TDIST function is used to calculate the probability of a student t-distribution in small sample data sets. It is available for backward compatibility and is improved by the T.DIST.2T and T.DIST.RT functions.

The TEXT function is used to format numbers and convert them to text. It takes a number as an input and returns it in a given number format as text.

The TEXTAFTER function is used to return text after a given character or string. It is the opposite of the TEXTBEFORE function and searches text from the end of a document. If the delimiter is not included, the function will return an #N/A error.

The TEXTBEFORE function is used to extract text from a given string that precedes a given character or string. The function has 6 arguments, including text, delimiter, instance_num, match_mode, match_end, and if_not_found, which can be used to customize the search. The function is case-sensitive and is the opposite of the TEXTAFTER function.

The TEXTJOIN function is a useful tool that enables users to combine text from multiple sources with an optional delimiter. It is available on Windows and Mac with Office 2019 or Microsoft 365.

The Text-split function is a tool that works the same way as the Text-to-Columns wizard, allowing users to quickly divide text into separate columns.

The TIME function returns a decimal number for a particular time, and requires its arguments to be specified.

The TIMEVALUE function converts a text string representing a time to a decimal number between 0 and 0.99988426, which corresponds to times from 0:00:00 to 23:59:59.

The TINV function calculates the two-tailed inverse of the Student's t-distribution with improved accuracy and better named functions.

The TOCOL function is a convenient tool for returning an array of data in a single row. It is useful for consolidating data into a single row.

The TODAY function returns the current date based on the computer's system date, with no need for arguments or input parameters.

The TOROW function is used to return an array in a single column. It requires an array argument, an ignore argument and a scan_by_column argument. The ignore argument determines whether to ignore certain types of values and the scan_by_column argument determines how the array will be scanned.

The TRANSPOSE function quickly and easily changes a vertical range of cells into a horizontal range. It is a useful tool for re-arranging data in Sourcetable.

The TREND function is used to calculate a linear trend line through a given set of data points and to extend the line forward or backward in time. It is useful for predicting future values or estimating values for a specific time period.

The TRIM function is a method for cleaning up data in a worksheet. It removes extra spaces from data, including irregular spacing.

The TRIMMEAN function is a useful tool for excluding outlying data from an analysis. It excludes a percentage of data points from the top and bottom of a data set to provide a more accurate representation of the data.

The TRUE function is used to return the logical value TRUE if a condition is met. It can also be entered directly into cells and formulas without a function.

The TRUNC function is a useful tool for removing the decimal part of a number, truncating it to an integer value. It can also be used to extract dates from date and time values and was introduced in MS Excel 2007. It can be used to truncate a number to a given precision.

The TTEST function is used to determine whether two sets of data are likely to have come from the same population. It returns the probability of observing the difference between the means of the two data sets by chance.

The TYPE function is a useful tool for determining the type of data stored in a particular value. It can be used to ensure correct usage of functions that take different types of data.

The UNICHAR function is a useful tool that returns the Unicode character referenced by a numeric value. It requires a single numeric argument and will return a #VALUE! error if given a zero argument.

The UNICODE function is used to obtain the Unicode code point for a given text argument. It requires one text argument and provides the corresponding Unicode code point.

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.

The UPPER function is used to convert text to uppercase by taking a required text argument. It can be used to quickly and easily change the case of any text.

The VALUE function converts text to a number in Sourcetable for compatibility with other spreadsheet programs. It takes a text argument as required and returns the converted number.

The VAR function is used to calculate a sample variance and can include logical values, text, and error values in the arguments. It may be replaced with new functions that offer improved accuracy and better names.

The VAR.P function is a useful tool for calculating the variance of a population. It can take numerical, array, reference, and even error values or text as arguments.

The VAR.S function calculates the variance of a sample of a population, ignoring empty cells, error values, text and values. It is best suited for numeric data.

The VARA function calculates the variance of a sample from a population, taking into account only numerical values and ignoring empty cells and text values.

The VARP function calculates the population variance, while the VAR function calculates the sample variance. VARPA also takes into account logical values and text when determining the variance.

The VARPA function is a versatile tool for calculating the variance of a population. It takes numerical, text, array, and references as arguments and ignores empty cells and text.

The VDB function is a useful tool that calculates depreciation on an asset using the Double Declining Balance method. This allows for a more accurate depreciation calculation for businesses.

The VLOOKUP function searches for items within tables and ranges by using a lookup value and then returning the exact or approximate match found.

The VSTACK function takes multiple arrays and combines them into a single larger array. It does this by vertically appending the arrays in sequence.

The WEBSERVICE function is a Sourcetable tool available in Excel 2013 and later which allows users to retrieve data from a web service. It requires Windows operating system features and can be found in the Excel for Mac function gallery. It has a maximum characters for GET requests of 2048.

The WEEKDAY function provides an easy way to determine the day of the week for a given date, returned as a number from 1 to 7.

The WEEKNUM function returns the week number of a given date as a number, following ISO 8601 standards. The date argument is required and the return type argument is optional.

The WEIBULL function is used to calculate the Weibull distribution which is commonly used in reliability analysis to estimate a device's mean time to failure.

The WEIBULL.DIST function calculates the Weibull distribution, which is commonly used in reliability analysis.

The WORKDAY function is used to calculate a date from a formula, returning a number representing the date that is either before or after a specified number of working days, with parameters to indicate which days are weekend days.

The WORKDAY.INTL function is used to calculate a date that is a certain number of workdays before or after a given date, with custom parameters for what days are considered weekends.

The WRAPCOLS function divides a row or column of values into an array and returns the result. It requires three arguments: vector, wrap_count, and pad_with. WRAPCOLS will return an error if the vector is not a one-dimensional array.

The WRAPROWS function reformats the given row or column of values into a new array by wrapping the elements into rows after reaching a specified element count.

The XIRR function is an advanced tool for calculating the internal rate of return for a set of cash flows that may not follow a regular pattern. It can be used to calculate the rate of return for investments that are not consistent. However, it will throw an error if the dates provided are invalid.

XLOOKUP is a Sourcetable function that enables users to quickly locate items within a table or range by searching by a designated column. If an exact match is not found, an approximate match is returned.

The XMATCH function is a useful tool for finding the position of an item in an array or range of cells. It searches for the item and returns its position relative to the start of the array or range.

The XNPV function is used to calculate the present value of a series of cash flows that occur at different times. It is an alternative to the NPV function, which calculates the net present value for cash flows that occur periodically.

The XOR function is a logical operation which returns a true or false result based on the evaluation of given Boolean values. It can be used with arrays or references and ignores any text or empty cells in its arguments.

The YEAR function returns the year from a given date. This date should be entered using the DATE function and Sourcetable calculates the date as a sequential serial number.

The YEARFRAC function is used to calculate the fraction of a year represented by a period of time. It can calculate the proportion of a year's benefits or obligations during a specified period.

The YIELD function enables users to calculate the bond yield of a security by entering the relevant dates using the DATE function. It is important to use the correct dates to ensure accurate results.

The YIELDDISC function calculates the annual yield of a security which is discounted by taking into account the settlement date, maturity date, price, redemption value, and basis.

YIELDMAT is a function which calculates the annual yield of a security based on the interest paid at maturity.

The Z.TEST function calculates the P-value for a one-tailed z-test, determining the probability that the sample mean is greater than the average of observations in the data set. It returns the #N/A error value if the array argument is empty. The equation for Z.TEST is 1- Norm.S.Dist (((Average(array)-x)/(sigma/√n),TRUE)) or 1- Norm.S.Dist ((Average(array)- x) / (STDEV(array)/√n),TRUE).

The ZTEST function is a statistical tool that calculates the probability that the sample mean is greater than the average of observations in the data set. It offers improved accuracy compared to other tests.