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