Math and trigonometry

This page presents procedures from class WorksheetFunction related to the theme Math and trigonometry

IsEven - Checks the type of value and returns True or False depending on whether the value is even.

IsOdd - Checks the type of value and returns True or False depending on whether the value is odd.

Lcm - 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.

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

Log - Returns the logarithm of a number to the base that you specify.

Log10 - Returns the base-10 logarithm of a number.

Acos - Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is Arg1. The returned angle is given in radians in the range 0 (zero) to pi.

Acosh - Returns the inverse hyperbolic cosine of a number. Number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is Arg1, so Acosh(Cosh(number)) equals Arg1.

Acot - Returns the arccotangent of a number, in radians in the range 0 (zero) to pi.

Acoth - Returns the inverse hyperbolic cotangent of a number.

Aggregate - Returns an aggregate in a list or database.

Asin - Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is Arg1. The returned angle is given in radians in the range -pi/2 to pi/2.

Asinh - Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is Arg1, so Asinh(Sinh(number)) equals Arg1.

Atan2 - Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates. The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and a point with coordinates (x_num, y_num). The angle is given in radians between -pi and pi, excluding -pi.

Atanh - Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (excluding -1 and 1).

Combin - 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.

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

Cosh - Returns the hyperbolic cosine of a number.

Cot - Returns the cotangent of an angle.

Coth - Returns the hyperbolic cotangent of a number.

Csc - Returns the cosecant of an angle.

Csch - Returns the hyperbolic cosecant of an angle.

Degrees - Converts radians into degrees.

Even - 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.

Expon_Dist - Returns the exponential distribution. Use Expon_Dist to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use Expon_Dist to determine the probability that the process takes at most 1 minute.

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

FactDouble - Returns the double factorial of a number.

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

Floor_Precise - Rounds the specified number to the nearest multiple of significance.

Gcd - 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.

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

Odd - Returns number rounded up to the nearest odd integer.

Pi - Returns the number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.

Power - Returns the result of a number raised to a power.

Product - Multiplies all the numbers given as arguments and returns the product.

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

Radians - Converts degrees to radians.

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

Roman - Converts an arabic numeral to roman, as text.

Sec - Returns the secant of an angle.

Sech - Returns the hyperbolic secant of an angle.

SeriesSum - Returns the sum of a power series based on the following formula:.

Sinh - Returns the hyperbolic sine of a number.

SqrtPi - Returns the square root of (number * pi).

Subtotal - Creates subtotals.

Sum - Adds all the numbers in a range of cells.

SumIf - Adds the cells specified by a given criteria.

SumIfs - Adds the cells in a range that meet multiple criteria.

SumProduct - Multiplies corresponding components in the given arrays, and returns the sum of those products.

SumSq - Returns the sum of the squares of the arguments.

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

SumX2PY2 - 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.

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

Tanh - Returns the hyperbolic tangent of a number.