Math aFunctions¶

ABS¶

ABC(Number n)

Returns the absolute value of a number.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The absolute value of a number.

Example:

=ABS(-145.789)
Output: 145.789

ACOS¶

ACOS(Number n)

Returns the arccosine of a number in radians in the range of 0 to PI.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The arccosine of a number in radians in the range of 0 to PI.

Note

The value of n should be in the range of -1 and 1.

Example:

=ACOS(45)
Output: 1.0973008

ASIN¶

ASIN(Number n)

Returns the arcsine of a number in radians in the range of -PI/2 to PI/2.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The arcsine of a number in radians in the range of -PI/2 to PI/2.

Note

The value of n should be in the range of -1 and 1.

Example:

=ASIN(0.456)
Output: 0.4734955

ATAN¶

ATAN(Number n)

Returns the arctangent of a number in radians in the range of -PI/2 to PI/2.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The arctangent of a number in radians in the range of -PI/2 to PI/2.

Example:

=ATAN(45)
Output: 1.5485778

AVG¶

AVG(Number N1, Number N2[, Number N3, ..., Number Nn])

Returns the average value from a set of values.

Arguments:	N1, N2, N3, ..., Nn (java.lang.Number) – Number can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The average value from a set of values.

Note

This function requires a minimum of 2 arguments.

Example:

=AVG(45, 23, 56.75, 1.23456)
Output: 31.25

CEIL¶

CEIL(Number n)

Rounds a number to the next highest integer value.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	A number rounded to the next highest integer value.

Example:

=CEIL(145.565)
Output: 146.0

COS¶

COS(Number n)

Returns the cosine of an angle.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The cosine of an angle.

Example:

=COS(45)
Output: 0.52532196

DEGREES¶

DEGREES(Number n)

Convert radians to degrees.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	Degrees value given value in radians.

Note

The resultant value will be float for input type byte, short, int, float and double for input type long and double.

Example:

=DEGREES(45)
Output: 2578.31

DIV¶

DIV(Number n1, Number n2)

Gives the result of division of 2 numbers.

Arguments:	n1 (java.lang.Number) – Can be byte, short, int, long, float or double. n2 (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The result of division of 2 numbers.

Example:

=DIV(34, 56.13456)
Output: 0.6056875

DIV_N¶

DIV_N(Number N1, Number N2[, Number N3, ..., Number Nn])

Gives the result of division of N numbers.

Arguments:	N1, N2, N3, ..., Nn (java.lang.Number) – Number can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The result of division of N numbers.

Note

This function requires a minimum of 2 arguments.

Example:

=DIV_N(12, 34, 34.56, 56.13456)
Output: 1.8192746E-4

DROUND¶

DROUND(Number n, Number p)

Rounds a number to the closest decimal place.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double. p (java.lang.Number) – Number of decimal places to which the number should be round to.
Return-type :	java.lang.Number
Returns:	A number rounding it to the closest decimal place.

Example:

=DROUND(145.565, 2)
Output: 145.57

EVEN¶

EVEN(Number n)

Returns the nearest even number.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The nearest even number.

Example:

=EVEN(22.77786565)
Output: 24.0

FLOOR¶

FLOOR(Number n)

Rounds a number to the next lowest integer value.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	A number to the next lowest integer value.

Example:

=FLOOR(145.789)
Output: 145.0

IFNAN¶

IFNAN(Object arg1, Object arg2[, Object arg3=0])

Returns a default value when the first argument is not a number.

Arguments:	arg1 (java.lang.Object) – Can be any value. arg2 (java.lang.Object) – The value to be returned when arg1 string value is not a valid number. arg3 (java.lang.Object) – (Optional) The value to be returned when arg1 string value is empty, if not present then 0 is assumed.
Return-type :	java.lang.Number
Returns:	A default value when the first argument is not a number.

Example:

=IFNAN("12345", -999999)
Output: 12345

=IFNAN("NaN")
Output: Error: IFNAN argument '2' is mandatory

=IFNAN("NaN", -999999)
Output: -999999

=IFNAN("", -999999)
Output: 0

=IFNAN("", -999999, 10)
Output: 10

LOG10¶

LOG10(Number n)

Returns the logarithmic value to the base 10.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The logarithmic value to the base 10.

Example:

=LOG10(23)
Output: 1.3617278

LOG2¶

LOG2(Number n)

Returns the logarithmic value to the base 2.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The logarithmic value to the base 2.

Example:

=LOG2(23)
Output: 4.523562

LOGn¶

LOGn(Number n)

Returns the natural logarithmic value of a number.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The natural logarithmic value of a number.

Example:

=LOGn(23)
Output: 3.1354942

MAX¶

MAX(Number N1, Number N2[, Number N3, ..., Number Nn])

Returns the largest value from a set of values.

Arguments:	N1, N2, N3, ..., Nn (java.lang.Number) – Number can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The largest value from a set of values.

Note

This function requires a minimum of 2 arguments.

Example:

=MAX(45, 23, 56.75, 1.23456)
Output: 56.75

MIN¶

MIN(Number N1, Number N2[, Number N3, ..., Number Nn])

Returns the lowest value from a set of values.

Arguments:	N1, N2, N3, ..., Nn (java.lang.Number) – Number can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The lowest value from a set of values.

Note

This function requires a minimum of 2 arguments.

Example:

=MIN(45, 23, 56.75, 1.23456)
Output: 1.23456

MOD¶

MOD(Number n1, Number n2)

Gives the remainder from the division of the first argument by the second.

Arguments:	n1 (java.lang.Number) – Can be byte, short, int or long. n2 (java.lang.Number) – Can be byte, short, int or long.
Return-type :	java.lang.Number
Returns:	The remainder from the division of the first argument by the second.

Note

float and double data types are not supported.

Example:

=MOD(147, 5)
Output: 2

MUL¶

MUL(Number n1, Number n2)

Gives the result of product of 2 numbers.

Arguments:	n1 (java.lang.Number) – Can be byte, short, int, long, float or double. n2 (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The result of product of 2 numbers.

Example:

=MUL(5.123f, 23.0d)
Output: 117.82900333404541

MUL_N¶

MUL_N(Number N1, Number N2[, Number N3, ..., Number Nn])

Gives the result of product of N numbers.

Arguments:	N1, N2, N3, ..., Nn (java.lang.Number) – Number can be byte, short, int, long, float or double. n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The result of product of N numbers.

Note

This function requires a minimum of 2 arguments.

Example:

=MUL_N(12, 34, 34.56, 56.13456)
Output: 791524.25

NEGATE¶

NEGATE(Number n)

Gives the negated value of a number.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The negated value of a number.

Example:

=NEGATE(145)
Output: -145

ODD¶

ODD(Number n)

Returns the nearest even number.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The nearest even number.

Example:

ODD(22.77786565)
Output: 23.0

POW¶

POW(Number n, Number p)

Gives the result of a number raised to the power.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double. p (java.lang.Number) – Value by which n need to be raised.
Return-type :	java.lang.Number
Returns:	The result of a number raised to the power.

Example:

=POW(2, 2.3)
Output: 4.9245777

RADIANS¶

RADIANS(Number n)

Converts the degrees to radians.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	Value in radians for given input value in degrees.

Note

The resultant value will be float for input type byte, short, int, float and double for input type long and double.

Example:

=RADIANS(2578.31)
Output: 45.0

RAND¶

RAND(Integer length[, String type="", Number seed])

Generates a random value depending on the length, type and seed values.

Arguments:	length (java.lang.Integer) – Desired output length of the of random value. type (java.lang.String) – (optional) Character type - Default; Number type - represented with character “N” or “NUM”. seed (java.lang.Number) – (optional) Can be int or long value.
Return-type :	java.lang.String
Returns:	A random value depending on the length, type and seed values.

Example:

RAND(6, "N")
RAND(6,"")
RAND(6,"N",455666)

Output:
215711
QXSRNB
458918

ROUND¶

ROUND(Number n)

Returns the rounded value.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The rounded value.

Example:

=ROUND(145.565)
Output: 146

SIN¶

SIN(Number n)

Returns the sine of an angle.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The sine of an angle.

Example:

=SIN(45)
Output: 0.8509035

SQRT¶

SQRT(Number n)

Returns the square root of a number.

Arguments:	n (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The square root of a number.

Example:

=SQRT(45)
Output: 6.708204

SUB¶

SUB(Number n1, Number n2)

Gives the result of subtraction of 2 numbers.

Arguments:	n1 (java.lang.Number) – Can be byte, short, int, long, float or double. n2 (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The result of subtraction of 2 numbers.

Example:

=SUB(12, 56.13456)
Output: -44.13456

SUB_N¶

SUB_N(Number N1, Number N2[, Number N3, ..., Number Nn])

Gives the result of subtraction of N numbers.

Arguments:	N1, N2, N3, ..., Nn (java.lang.Number) – Number can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The result of subtraction of N numbers.

Note

This function requires a minimum of 2 arguments.

Example:

=SUB_N(12, 34, 34.56, 56.13456)
Output: -112.694565

SUM¶

SUM(Number n1, Number n2)

Gives the result of addition of 2 numbers.

Arguments:	n1 (java.lang.Number) – Can be byte, short, int, long, float or double. n2 (java.lang.Number) – Can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The result of addition of 2 numbers.

Example:

=SUM(2.4566, 1.2345f)
Output: 3.6911001

SUM_N¶

SUM_N(Number N1, Number N2[, Number N3, ..., Number Nn])

Gives the result of addition of N numbers.

Arguments:	N1, N2, N3, ..., Nn (java.lang.Number) – Number can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	The result of addition of N numbers.

Note

This function requires a minimum of 2 arguments.

Example:

=SUM_N(12, 34, 34.56, 56.13456)
Output: 136.69455

TAN¶

TAN(Number n)

Returns the tangent of an angle.

Arguments:	n (java.lang.Number) – Number can be byte, short, int, long, float or double.
Return-type :	java.lang.Number
Returns:	Returns the tangent of an angle.

Example:

=TAN(45)
Output: 1.6197752

Math aFunctions¶

ABS¶

ACOS¶

ASIN¶

ATAN¶

AVG¶

CEIL¶

COS¶

DEGREES¶

DIV¶

DIV_N¶

DROUND¶

EVEN¶

FLOOR¶

IFNAN¶

LOG10¶

LOG2¶

LOGn¶

MAX¶

MIN¶

MOD¶

MUL¶

MUL_N¶

NEGATE¶

ODD¶

POW¶

RADIANS¶

RAND¶

ROUND¶

SIN¶

SQRT¶

SUB¶

SUB_N¶

SUM¶

SUM_N¶

TAN¶

Table Of Contents

Previous topic

Next topic

This Page

Navigation

Math aFunctions¶

ABS¶

ACOS¶

ASIN¶

ATAN¶

AVG¶

CEIL¶

COS¶

DEGREES¶

DIV¶

DIV_N¶

DROUND¶

EVEN¶

FLOOR¶

IFNAN¶

LOG10¶

LOG2¶

LOGn¶

MAX¶

MIN¶

MOD¶

MUL¶

MUL_N¶

NEGATE¶

ODD¶

POW¶

RADIANS¶

RAND¶

ROUND¶

SIN¶

SQRT¶

SUB¶

SUB_N¶

SUM¶

SUM_N¶

TAN¶

Table Of Contents

Previous topic

Next topic

This Page

Quick search

Navigation