math

67 Articles in this category

- DarkLight

# math

67 Articles in this category

- DarkLight

## ABS

Calculates the absolute value of the given number, i.e. if the number is negative, its positive value is returned.
Function signature
ABS(number: Number) => Number
Examples

Updated on : 27 May 2022

## Acos

Calculates the inverse cosine or arccosine of the given number. The value is returned in radians.
Function signature
ACOS(number: Number) => Number
Examples

Updated on : 27 May 2022

## Acosec

Calculates the inverse cosecant or arccosecant of the given number. The value is returned in radians.
Function signature
ACOSEC(number: Number) => Number
Examples

Updated on : 27 May 2022

## Acosh

Calculates the inverse hyberbolic cosine of the given number. The value is returned in radians.
Function signature
ACOSH(number: Number) => Number
Examples

Updated on : 27 May 2022

## Acot

Calculates the inverse cotangent or arccotangent of the given number. The value is returned in radians.
Function signature
ACOT(number: Number) => Number
Examples

Updated on : 27 May 2022

## Acoth

Calculates the inverse hyberbolic cotangent of the given number. The value is returned in radians.
Function signature
ACOTH(number: Number) => Number
Examples

Updated on : 27 May 2022

## Asec

Calculates the inverse secant or arcsecant of the given number. The value is returned in radians.
Function signature
ASEC(number: Number) => Number
Examples

Updated on : 27 May 2022

## Asin

Calculates the inverse sine of the given number. The value is returned in radians.
Function signature
ASIN(number: Number) => Number
Examples

Updated on : 27 May 2022

## Asinh

Calculates the inverse hyberbolic sine of the given number. The value is returned in radians.
Function signature
ASINH(number: Number) => Number
Examples

Updated on : 27 May 2022

## Atan

Calculates the inverse tangent or arctangent of the given number. The value is returned in radians.
Function signature
ATAN(number: Number) => Number
Examples

Updated on : 27 May 2022

## Atanh

Calculates the hyberbolic arctangent of the given number. The value is returned in radians.
Function signature
ATANH(number: Number) => Number
Examples

Updated on : 27 May 2022

## Ceil

Rounds the given number up to the next integer.
Function signature
CEIL(number: Number) => Number
Examples

Updated on : 27 May 2022

## Cos

Given an angle in radians, calculates its cosine.
Function signature
COS(number: Number) => Number
Examples

Updated on : 27 May 2022

## Cosec

Given an angle in radians, calculates its cosecant.
Function signature
COSEC(number: Number) => Number
Examples

Updated on : 27 May 2022

## Cosech

Given an angle in radians, calculates its hyberbolic cosecant.
Function signature
COSECH(number: Number) => Number
Examples

Updated on : 27 May 2022

## Cosh

Calculates the hyberbolic cosine for the given number.
Function signature
COSH(number: Number) => Number
Examples

Updated on : 27 May 2022

## Cot

Given an angle in radians, calculates its cotangent.
Function signature
COT(number: Number) => Number
Examples

Updated on : 27 May 2022

## Coth

Given an angle in radians, calculates its hyberbolic cotangent.
Function signature
COTH(number: Number) => Number
Examples

Updated on : 27 May 2022

## Degrees

Given an angle in radians, returns its value in degrees.
Function signature
DEGREES(number: Number) => Number
Examples

Updated on : 27 May 2022

## Div

Divides the first number parameter with the second one, truncating any decimal points and returning an integer.|
Function signature
DIV(dividend: Number, divisor: Number) => Number
Examples

Updated on : 27 May 2022

## Divide

Divides the first number with the second one, returning an integer or a decimal number accordingly. Equivalent to the the / operator.
Function signature
DIVIDE(dividend: Number, divisor: Number) => Number
Examples

Updated on : 27 May 2022

## Euler

Returns Euler's constant (the base of natural logarithms), approximately 2.718.
Function signature
EULER() => Number
Examples

Updated on : 27 May 2022

## Even

Returns the given number, rounded up to the nearest even integer. If the given number is an even integer, returns itself.
Function signature
EVEN(number: Number) => Number
Examples

Updated on : 27 May 2022

## Exp

Returns Euler's constant, raised to the given power.
Function signature
EXP(number: Number) => Number
Examples

Updated on : 27 May 2022

## Factorial

Returns the factorial of the given number, i.e. value of the mathematical notation _n!_.
Function signature
FACTORIAL(number: Number) => Number
Examples

Updated on : 27 May 2022

## Floor

Returns the given number, rounded down to the nearest integer. If the given number is an integer, returns itself.
Function signature
FLOOR(number: Number) => Number
Examples

Updated on : 27 May 2022

## Greatest_commmon_divisor

Given a list of numbers, calculates the greatest common divisor for them.
Function signature
GREATEST_COMMON_DIVISOR(list: Array) => Number
Examples

Updated on : 27 May 2022

## Hypot

Calculate the hypotenusea of a list of numbers, i.e. the square root of the sum of squares of the numbers.
Function signature
HYPOT(values: Array) => Number
Examples

Updated on : 27 May 2022

## Is_even

Returns true if the given number is even, false if it's odd.
Function signature
IS_EVEN(number: Number) => Boolean
Examples

Updated on : 27 May 2022

## Is_nan

Returns true if the given number is NaN , a special "not a number" symbol. For example, dividing any number by 0 results in NaN .
Function signature
IS_NAN(number: Number) => Boolean
Examples

Updated on : 27 May 2022

## Is_odd

Updated on : 27 May 2022

## Least_common_multiple

Given a list of numbers, calculates the least common multiple for them.
Function signature
LEAST_COMMON_MULTIPLE(list: Array) => Number
Examples

Updated on : 27 May 2022

## In

Calculates the natural logarithm for the given number, i.e. logarithm in base _e_ (Euler's number).
Function signature
LN(number: Number) => Number
Examples

Updated on : 27 May 2022

## Log

Given a number, calculates its logarithm in the given base.
Function signature
LOG(number: Number, base: Number) => Number
Examples

Updated on : 27 May 2022

## Log2

Calculates the base 2 logarithm of the given number.
Function signature
LOG2(number: Number) => Number
Examples

Updated on : 27 May 2022

## Log10

Calculates the base 10 logarithm of the given number.
Function signature
LOG10(number: Number) => Number
Examples

Updated on : 27 May 2022

## Max

Given a list of numbers, returns the highest number in the list.
Function signature
MAX(values: Array) => Number
Examples

Updated on : 27 May 2022

## Min

Given a list of numbers, returns the smallest number in the list.
Function signature
MIN(values: Array) => Number
Examples

Updated on : 27 May 2022

## Mod

Given a dividend and a divisor, returns the result of the modulo operation.
Function signature
MOD(dividend: Number, divisor: Number) => Number
Examples

Updated on : 27 May 2022

## Multinominal

Given a list of numbers, calculates the factorial of their sum, divided by the product of each number's factorial.
Function signature
MULTINOMIAL(values: Array) => Number
Examples

Updated on : 27 May 2022

## Multiply

Multiplies two numbers, returning their product. Equivalent to the * operator.
Function signature
MULTIPLY(multiplicand: Number, multiplier: Number) => Number
Examples

Updated on : 27 May 2022

## Odd

Returns the given number, rounded up to the nearest odd integer. If the given number is an odd integer, returns itself.
Function signature
ODD(number: Number) => Number
Examples

Updated on : 27 May 2022

## Pi

Returns the value of pi (the ratio of the circumference of a circle to its diameter) to 15 decimal places, i.e. 3.141592653589793 .
Function signature
PI() => Number
Examples

Updated on : 27 May 2022

## Power

Calculates the value of the given number raised to the given power.
Function signature
POWER(base: Number, power: Number) => Number
Examples

Updated on : 27 May 2022

## Product

Given a list of numbers, calculate the product of multiplying the numbers with each other.
Function signature
PRODUCT(values: Array) => Number
Examples

Updated on : 27 May 2022

## Radians

Given an angle in degrees, returns its value in radians.
Function signature
RADIANS(number: Number) => Number
Examples

Updated on : 27 May 2022

## Random_array

Generates a list of (pseudo) random numbers, each between 0 (inclusive) and 1 (exclusive), i.e. 0 ≤ n < 1.
Function signature
RANDOM_ARRAY(count: Number) => Array
Examples

Updated on : 27 May 2022

## Random

Returns a (pseudo) random number between 0 (inclusive) and 1 (exclusive), e.g. 0 ≤ n < 1.
Function signature
RANDOM() => Number
Examples

Updated on : 27 May 2022

## Sec

Given an angle in radians, returns its secant.
Function signature
SEC(number: Number) => Number
Examples

Updated on : 27 May 2022

## Sech

Given an angle in radians, returns its hyperbolic secant.
Function signature
SECH(number: Number) => Number
Examples

Updated on : 27 May 2022

## Sequence

Generates a list of sequential numbers, separated by the given step value.
Function signature
SEQUENCE(startnumber: Number, countnumber: Number, stepnumber: Number) => Array
Examples

Updated on : 27 May 2022

## Series_sum

Calculates the sum of a power series. Given a list of numbers , and the constants , and , the sum is calculated using the formula:
...

Updated on : 27 May 2022

## Sign

Returns -1 if the parameter is a negative number, 1 if it is positive, and 0 if it is zero. Returns null if it's not a number.
Function signature
SIGN(number: Number) => Number
Examples

Updated on : 27 May 2022

## Sin

Given an angle in radians, calculates its sine.
Function signature
SIN(number: Number) => Number
Examples

Updated on : 27 May 2022

## Sinh

Calculates the hyberbolic sine for the given number.
Function signature
SINH(number: Number) => Number
Examples

Updated on : 27 May 2022

## Sqrt_pi

Calculates the square root of the product of the given (positive) number and pi.
Function signature
SQRT_PI(number: Number) => Number
Examples

Updated on : 27 May 2022

## Sqrt

Calculate the square root for the given number.
Function signature
SQRT(number: Number) => Number
Examples

Updated on : 27 May 2022

## Sum_squared

Given a list of numbers, returns the sum of the squares of the numbers.
Function signature
SUM_SQUARED(values: Array) => Number
Examples

Updated on : 27 May 2022

## Sum

Given an array of numbers, calculates their sum. If the array is empty, returns 0.
Function signature
SUM(values: Array) => Number
Examples

Updated on : 27 May 2022