Tables

Undocumented

Tables’ data source

Tables’ delegate

A type of error made for Tables

Absolute value of a number

Arc-Cosinus of a number.

Hyperbolic Arc-Cosinus of a number.

Arc-Cotangent of a number.

Hyperbolic Arc-Cotangent of a number.

Arc-Sinus of a number.

Hyperbolic Arc-Sinus of a number.

Arc-Tangent of a number.

ATAN2(Y,X) returns the four-quadrant inverse tangent (tan-1) of Y and X, which must be real. The atan2 function follows the convention that atan2(x,x) returns 0 when x is mathematically zero (either 0 or -0).

Hyperbolic Arc-Tangent of a number.

Convert number to any base

Returns number rounded up, away from zero, to the nearest multiple of significance.

For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula =CEILING(4.42,0.05) to round prices up to the nearest nickel.

Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.

It uses combinations with repetitions: n! / (k! * (n - k)!)

Returns the number of combinations (with repetitions) for a given number of items.

It uses combinations with repetitions: (n + k - 1)! / (k! * (n - 1)!)

Cosinus of a number.

Hyperbolic Cosinus of a number.

Cotangent of a number.

Hyperbolic Cotangent of a number.

Cosecant of a number.

Hyperbolic Cosecant of a number.

Converts a text representation of a number in a given base into a decimal number.

Converts radians into degrees.

Returns number rounded up to the nearest even integer.

You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate is full when the number of items, rounded up to the nearest two, matches the crate’s capacity.

Returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm.

Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...* number.

Returns the double factorial of a number. The factorial of a number is equal to 1*2*3*...* number.

Rounds number down, toward zero, to the nearest multiple of significance.

For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula =FLOOR(4.42,0.05) to round prices up to the nearest nickel.

Returns the greatest common divisor of two or more integers.

The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.

Returns the greatest common divisor of two or more integers.

The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.

Rounds a number down to the nearest integer.

Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with different denominators.

Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with different denominators.

Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904)

LN is the inverse of the EXP function.

Returns the logarithm of a number to the base you specify.

Returns the logarithm base 10

Returns the matrix determinant

The MINVERSE function returns the inverse matrix for a matrix stored in a Matrix object (Tables will convert that when using the parser).

The MMULT function returns the matrix product of two Matrix. The result is an array with the same number of rows as lhs and the same number of columns as rhs.

MROUND returns a number rounded to the desired multiple.

Returns the remainder after number is divided by divisor.

The result has the same sign as divisor.

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

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

Returns number rounded up to the nearest odd integer.

Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an odd integer, no rounding occurs.

Returns the mathematical constant

Originally defined as the ratio of a circle’s circumference to its diameter, it now has various equivalent definitions and appears in many formulas in all areas of mathematics and physics. It is approximately equal to 3.14159. It has been represented by the Greek letter “π” since the mid-18th century, though it is also sometimes spelled out as “pi”. It is also called Archimedes’ constant.

Returns the result of a number raised to a power.

Let’s say you want to calculate an extremely small tolerance level for a machined part or the vast distance between two galaxies. To raise a number to a power, use the POWER function.

The “^” operator can be used instead of POWER to indicate to what power the base number is to be raised, such as in 5^2.

The PRODUCT function multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT(A1, A2) to multiply those two numbers together. You can also perform the same operation by using the multiply (*) mathematical operator; for example, =A1 * A2. The PRODUCT function is useful when you need to multiply many cells together. For example, the formula =PRODUCT(A1:A3, C1:C3) is equivalent to =A1 * A2 * A3 * C1 * C2 * C3.

The PRODUCT function multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT(A1, A2) to multiply those two numbers together. You can also perform the same operation by using the multiply (*) mathematical operator; for example, =A1 * A2. The PRODUCT function is useful when you need to multiply many cells together. For example, the formula =PRODUCT(A1:A3, C1:C3) is equivalent to =A1 * A2 * A3 * C1 * C2 * C3.

Returns the integer portion of a division. Use this function when you want to discard the remainder of a division.

Tip: If you want to divide numeric values, you should use the “/” operator as there isn’t a DIVIDE function in Euler.Tables. For example, to divide 5 by 2, you would type =5/2 into a cell, which returns 2.5. The QUOTIENT function for these same numbers =QUOTIENT(5,2) returns 2, since QUOTIENT doesn’t return a remainder.

Converts degrees to radians.

RAND returns an evenly distributed random real number greater than or equal to 0 and less than 1.

A new random real number is returned every time the worksheet is calculated.

Returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated.

The ROUND function rounds a number to a specified number of digits.

For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula:

=ROUND(A1, 2) The result of this function is 23.78.

• If digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
• If digits is 0, the number is rounded to the nearest integer.
• If digits is less than 0, the number is rounded to the left of the decimal point.
• To always round up (away from zero), use the ROUNDUP function.
• To always round down (toward zero), use the ROUNDDOWN function.
• To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function.

Rounds a number down, toward zero.

Rounds a number up, away from zero.

Returns the secant of an angle.

Returns the hyperbolic secant of an angle.

Many functions can be approximated by a power series expansion. Returns the sum of a power series based on the formula:

Many functions can be approximated by a power series expansion. Returns the sum of a power series based on the formula:

Determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative.

Sinus function

Hyperbolic sinus function

Returns a positive square root.

Returns a positive nth root.

Returns the square root of (number * pi).

Add 2 numbers

Substract 2 numbers

Divide 2 numbers

Multiply 2 numbers

Greater than or equal (>=)

Less than (<)

Less than or equal (<=)

Equal (==)

Not equal (==)

Returns the result of a number raised to a power. Same as POWER

Let’s say you want to calculate an extremely small tolerance level for a machined part or the vast distance between two galaxies. To raise a number to a power, use the POWER function.

The “^” operator can be used instead of POWER to indicate to what power the base number is to be raised, such as in 5^2.

The SUM function adds values.

The SUM function adds values.

The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.

Example: SUMPRODUCT([1, 2, 3], [2, 3, 4]) //= 20

The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.

Example: SUMPRODUCT([1, 2, 3], [2, 3, 4]) //= 20

Returns the sum of the squares of the arguments.

Returns the sum of the squares of the arguments.

Returns the sum of the difference of squares of corresponding values in two arrays.

Returns the sum of the sum of squares of corresponding values in two arrays. The sum of the sum of squares is a common term in many statistical calculations.

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

Tangent of a number.

Hyperbolic Tangent of a number.

Truncates a number to an integer by removing the fractional part of the number.

The DATE function returns the sequential serial number that represents a particular date.

The DATEVALUE function converts a date that is stored as text to a serial number.

For example, the formula =DATEVALUE(“1/1/2008”) returns 39448, the serial number of the date 1/1/2008. Remember, though, that your computer’s system date setting may cause the results of a DATEVALUE function to vary from this example The DATEVALUE function is helpful in cases where a worksheet contains dates in a text format that you want to filter, sort, or format as dates, or use in date calculations.

YEARFRAC calculates the fraction of the year represented by the number of whole days between two dates (the start and the end).

For instance, you can use YEARFRAC to identify the proportion of a whole year’s benefits, or obligations to assign to a specific term.

Converts a binary number to decimal.

Converts a binary number to hexadecimal.

Converts a binary number to octal.

Returns a bitwise ‘AND’ of two numbers.

Returns a bitwise ‘OR’ of two numbers.

Returns a bitwise ‘XOR’ of two numbers.

Returns a number shifted left by the specified number of bits.

Returns a number shifted right by the specified number of bits.

Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.

Converts a decimal number to binary.

Converts a decimal number to hexadecimal.

Converts a decimal number to octal.

Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function.

Converts an hexadecimal number to binary

Converts an hexadecimal number to decimal

Converts an hexadecimal number to octal

Returns the accrued interest for a security that pays periodic interest.

AND operator.

If argument list contains a false statement, it returns false, otherwise it returns true

AND operator.

If argument list contains a false statement, it returns false, otherwise it returns true

Use CHOOSE to select one of up to 256 values based on the index number.

For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as i.

Use CHOOSE to select one of up to 256 values based on the index number.

For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as i.

The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.

OR operator.

If argument list contains at least one true statement, it returns true, otherwise it returns false

OR operator.

If argument list contains at least one true statement, it returns true, otherwise it returns false

The XOR function returns a logical Exclusive Or of all arguments.

The XOR function returns a logical Exclusive Or of all arguments.

Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set.

Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

The CORREL function returns the correlation coefficient of two arrays. Use the correlation coefficient to determine the relationship between two properties. For example, you can examine the relationship between a location’s average temperature and the use of air conditioners.

Counts the element of the given array

Counts the unique element of the given array

Returns the sum of squares of deviations of data points from their sample mean.

Returns the Fisher transformation at x. This transformation produces a function that is normally distributed rather than skewed. Use this function to perform hypothesis testing on the correlation coefficient.

Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.

The gamma function (represented by \Gamma, the capital letter gamma from the Greek alphabet) is one commonly used extension of the factorial function to complex numbers. The gamma function is defined for all complex numbers except the non-positive integers. For any positive integer n: \Gamma (n)=(n-1)!

Returns the natural logarithm of the gamma function, \Gamma (x).

Integral of the Gauss function

Computed using:

Returns the geometric mean.

In mathematics, the geometric mean is a mean or average, which indicates the central tendency or typical value of a set of numbers by using the product of their values (as opposed to the arithmetic mean which uses their sum). The geometric mean is defined as the nth root of the product of n numbers, i.e., for a set of numbers x_1, x_2, …, x_n, the geometric mean is defined as

Returns the harmonic mean

In mathematics, the harmonic mean (sometimes called the subcontrary mean) is one of several kinds of average, and in particular, one of the Pythagorean means. Typically, it is appropriate for situations when the average of rates is desired.

The harmonic mean can be expressed as the reciprocal of the arithmetic mean of the reciprocals of the given set of observations. As a simple example, the harmonic mean of 1, 4, and 4 is

Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution compared with the normal distribution. Positive kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a relatively flat distribution.

Returns the maximum element in the sequence.

The median is the number in the middle of a set of numbers.

If there is an even number of numbers in the set, then MEDIAN calculates the average of the two numbers in the middle.

Returns the minimum element in the sequence.

Returns the number of permutations for a given number of objects that can be selected from number objects.

A permutation is any set or subset of objects or events where internal order is significant. Permutations are different from combinations, for which the internal order is not significant. Use this function for lottery-style probability calculations.

Phi function

Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile.

Returns the skewness of a distribution. Skewness characterizes the degree of asymmetry of a distribution around its mean. Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values. Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.

Returns a normalized value from a distribution characterized by mean and standard deviation.

Returns the standard deviation of the list

The standard deviation (SD, also represented by the lower case Greek letter sigma σ for the population standard deviation or the Latin letter s for the sample standard deviation) is a measure of the amount of variation or dispersion of a set of values. A low standard deviation indicates that the values tend to be close to the mean (also called the expected value) of the set, while a high standard deviation indicates that the values are spread out over a wider range.

Computed using:

Returns the variance of the list

In probability theory and statistics, variance is the expectation of the squared deviation of a random variable from its mean. Informally, it measures how far a set of (random) numbers are spread out from their average value.

Computed using:

Interprets the given command

Huge list of all Tables functions.

While this is public, it’s not intended for use.

Common Formulas Functions (for parser)

Date/Time related Formulas Functions (for parser)

Engineering Formulas Functions (for parser)

Financial Formulas Functions (for parser)

Logical Formulas Functions (for parser)

Statistical Formulas Functions (for parser)