Methods

ATAN2()

ATAN2(float  $xCoordinate = null, float  $yCoordinate = null) : float

ATAN2.

This function calculates the arc tangent of the two variables x and y. It is similar to calculating the arc tangent of y ÷ x, except that the signs of both arguments are used to determine the quadrant of the result. The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and a point with coordinates (xCoordinate, yCoordinate). The angle is given in radians between -pi and pi, excluding -pi.

Note that the Excel ATAN2() function accepts its arguments in the reverse order to the standard PHP atan2() function, so we need to reverse them here before calling the PHP atan() function.

Excel Function: ATAN2(xCoordinate,yCoordinate)

Parameters

float $xCoordinate

the x-coordinate of the point

float $yCoordinate

the y-coordinate of the point

Returns

float —

the inverse tangent of the specified x- and y-coordinates

CEILING()

CEILING(float  $number, float  $significance = null) : float

CEILING.

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.

Excel Function: CEILING(number[,significance])

Parameters

float $number

the number you want to round

float $significance

the multiple to which you want to round

Returns

float —

Rounded Number

COMBIN()

COMBIN(int  $numObjs, int  $numInSet) : int

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.

Excel Function: COMBIN(numObjs,numInSet)

Parameters

int $numObjs

Number of different objects

int $numInSet

Number of objects in each combination

Returns

int —

Number of combinations

EVEN()

EVEN(float  $number) : int

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.

Excel Function: EVEN(number)

Parameters

float $number

Number to round

Returns

int —

Rounded Number

FACT()

FACT(float  $factVal) : int

FACT.

Returns the factorial of a number. The factorial of a number is equal to 123*...* number.

Excel Function: FACT(factVal)

Parameters

float $factVal

Factorial Value

Returns

int —

Factorial

FACTDOUBLE()

FACTDOUBLE(float  $factVal) : int

FACTDOUBLE.

Returns the double factorial of a number.

Excel Function: FACTDOUBLE(factVal)

Parameters

float $factVal

Factorial Value

Returns

int —

Double Factorial

FLOOR()

FLOOR(float  $number, float  $significance = null) : float

FLOOR.

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

Excel Function: FLOOR(number[,significance])

Parameters

float $number

Number to round

float $significance

Significance

Returns

float —

Rounded Number

GCD()

GCD(mixed  ...$args) : int

GCD.

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

Excel Function: GCD(number1[,number2[, ...]])

Parameters

mixed $args variadic

Data values

Returns

int —

Greatest Common Divisor

INT()

INT(float  $number) : int

INT.

Casts a floating point value to an integer

Excel Function: INT(number)

Parameters

float $number

Number to cast to an integer

Returns

int —

Integer value

LCM()

LCM(mixed  ...$args) : int

LCM.

Returns the lowest common multiplier of a series of numbers 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.

Excel Function: LCM(number1[,number2[, ...]])

Parameters

mixed $args variadic

Data values

Returns

int —

Lowest Common Multiplier

logBase()

logBase(float  $number = null, float  $base = 10) : float

LOG_BASE.

Returns the logarithm of a number to a specified base. The default base is 10.

Excel Function: LOG(number[,base])

Parameters

float $number

The positive real number for which you want the logarithm

float $base

The base of the logarithm. If base is omitted, it is assumed to be 10.

Returns

float —

MDETERM()

MDETERM(array  $matrixValues) : float

MDETERM.

Returns the matrix determinant of an array.

Excel Function: MDETERM(array)

Parameters

array $matrixValues

A matrix of values

Returns

float —

MINVERSE()

MINVERSE(array  $matrixValues) : array

MINVERSE.

Returns the inverse matrix for the matrix stored in an array.

Excel Function: MINVERSE(array)

Parameters

array $matrixValues

A matrix of values

Returns

array —

MMULT()

MMULT(array  $matrixData1, array  $matrixData2) : array

MMULT.

Parameters

array $matrixData1

A matrix of values

array $matrixData2

A matrix of values

Returns

array —

MOD()

MOD(int  $a = 1, int  $b = 1) : int

MOD.

Parameters

int $a

Dividend

int $b

Divisor

Returns

int —

Remainder

MROUND()

MROUND(float  $number, int  $multiple) : float

MROUND.

Rounds a number to the nearest multiple of a specified value

Parameters

float $number

Number to round

int $multiple

Multiple to which you want to round $number

Returns

float —

Rounded Number

MULTINOMIAL()

MULTINOMIAL(mixed  ...$args) : float

MULTINOMIAL.

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

Parameters

mixed $args variadic

Returns

float —

ODD()

ODD(float  $number) : int

ODD.

Returns number rounded up to the nearest odd integer.

Parameters

float $number

Number to round

Returns

int —

Rounded Number

POWER()

POWER(float  $x, float  $y = 2) : float

POWER.

Computes x raised to the power y.

Parameters

float $x
float $y

Returns

float —

PRODUCT()

PRODUCT(mixed  ...$args) : float

PRODUCT.

PRODUCT returns the product of all the values and cells referenced in the argument list.

Excel Function: PRODUCT(value1[,value2[, ...]])

Parameters

mixed $args variadic

Data values

Returns

float —

QUOTIENT()

QUOTIENT(mixed  ...$args) : float

QUOTIENT.

QUOTIENT function returns the integer portion of a division. Numerator is the divided number and denominator is the divisor.

Excel Function: QUOTIENT(value1[,value2[, ...]])

Parameters

mixed $args variadic

Data values

Returns

float —

RAND()

RAND(int  $min, int  $max) : int

RAND.

Parameters

int $min

Minimal value

int $max

Maximal value

Returns

int —

Random number

ROMAN()

ROMAN(mixed  $aValue, mixed  $style) : mixed

Parameters

mixed $aValue
mixed $style

Returns

mixed —

ROUNDUP()

ROUNDUP(float  $number, int  $digits) : float

ROUNDUP.

Rounds a number up to a specified number of decimal places

Parameters

float $number

Number to round

int $digits

Number of digits to which you want to round $number

Returns

float —

Rounded Number

ROUNDDOWN()

ROUNDDOWN(float  $number, int  $digits) : float

ROUNDDOWN.

Rounds a number down to a specified number of decimal places

Parameters

float $number

Number to round

int $digits

Number of digits to which you want to round $number

Returns

float —

Rounded Number

SERIESSUM()

SERIESSUM(mixed  ...$args) : float

SERIESSUM.

Returns the sum of a power series

Parameters

mixed $args variadic

Returns

float —

SIGN()

SIGN(float  $number) : int

SIGN.

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.

Parameters

float $number

Number to round

Returns

int —

sign value

SQRTPI()

SQRTPI(float  $number) : float

SQRTPI.

Returns the square root of (number * pi).

Parameters

float $number

Number

Returns

float —

Square Root of Number * Pi

SUBTOTAL()

SUBTOTAL(mixed  ...$args) : float

SUBTOTAL.

Returns a subtotal in a list or database.

Parameters

mixed $args variadic

Returns

float —

SUM()

SUM(mixed  ...$args) : float

SUM.

SUM computes the sum of all the values and cells referenced in the argument list.

Excel Function: SUM(value1[,value2[, ...]])

Parameters

mixed $args variadic

Data values

Returns

float —

SUMIF()

SUMIF(mixed  $aArgs, string  $condition, mixed  $sumArgs = []) : float

SUMIF.

Counts the number of cells that contain numbers within the list of arguments

Excel Function: SUMIF(value1[,value2[, ...]],condition)

Parameters

mixed $aArgs

Data values

string $condition

the criteria that defines which cells will be summed

mixed $sumArgs

Returns

float —

SUMIFS()

SUMIFS(mixed  ...$args) : float

SUMIFS.

Counts the number of cells that contain numbers within the list of arguments

Excel Function: SUMIFS(value1[,value2[, ...]],condition)

Parameters

mixed $args variadic

Data values

Returns

float —

SUMPRODUCT()

SUMPRODUCT(mixed  ...$args) : float

SUMPRODUCT.

Excel Function: SUMPRODUCT(value1[,value2[, ...]])

Parameters

mixed $args variadic

Data values

Returns

float —

SUMSQ()

SUMSQ(mixed  ...$args) : float

SUMSQ.

SUMSQ returns the sum of the squares of the arguments

Excel Function: SUMSQ(value1[,value2[, ...]])

Parameters

mixed $args variadic

Data values

Returns

float —

SUMX2MY2()

SUMX2MY2(array  $matrixData1, array  $matrixData2) : float

SUMX2MY2.

Parameters

array $matrixData1

Matrix #1

array $matrixData2

Matrix #2

Returns

float —

SUMX2PY2()

SUMX2PY2(array  $matrixData1, array  $matrixData2) : float

SUMX2PY2.

Parameters

array $matrixData1

Matrix #1

array $matrixData2

Matrix #2

Returns

float —

SUMXMY2()

SUMXMY2(array  $matrixData1, array  $matrixData2) : float

SUMXMY2.

Parameters

array $matrixData1

Matrix #1

array $matrixData2

Matrix #2

Returns

float —

TRUNC()

TRUNC(float  $value, int  $digits) : float

TRUNC.

Truncates value to the number of fractional digits by number_digits.

Parameters

float $value
int $digits

Returns

float —

Truncated value

SEC()

SEC(float  $angle) : float|string

SEC.

Returns the secant of an angle.

Parameters

float $angle

Number

Returns

float|string —

The secant of the angle

SECH()

SECH(float  $angle) : float|string

SECH.

Returns the hyperbolic secant of an angle.

Parameters

float $angle

Number

Returns

float|string —

The hyperbolic secant of the angle

CSC()

CSC(float  $angle) : float|string

CSC.

Returns the cosecant of an angle.

Parameters

float $angle

Number

Returns

float|string —

The cosecant of the angle

CSCH()

CSCH(float  $angle) : float|string

CSCH.

Returns the hyperbolic cosecant of an angle.

Parameters

float $angle

Number

Returns

float|string —

The hyperbolic cosecant of the angle

COT()

COT(float  $angle) : float|string

COT.

Returns the cotangent of an angle.

Parameters

float $angle

Number

Returns

float|string —

The cotangent of the angle

COTH()

COTH(float  $angle) : float|string

COTH.

Returns the hyperbolic cotangent of an angle.

Parameters

float $angle

Number

Returns

float|string —

The hyperbolic cotangent of the angle

ACOT()

ACOT(float  $number) : float|string

ACOT.

Returns the arccotangent of a number.

Parameters

float $number

Number

Returns

float|string —

The arccotangent of the number

ACOTH()

ACOTH(float  $number) : float|string

ACOTH.

Returns the hyperbolic arccotangent of a number.

Parameters

float $number

Number

Returns

float|string —

The hyperbolic arccotangent of the number

filterHiddenArgs()

filterHiddenArgs(mixed  $cellReference, mixed  $args) : mixed

Parameters

mixed $cellReference
mixed $args

Returns

mixed —

filterFormulaArgs()

filterFormulaArgs(mixed  $cellReference, mixed  $args) : mixed

Parameters

mixed $cellReference
mixed $args

Returns

mixed —

factors()

factors(mixed  $value) : mixed

Parameters

mixed $value

Returns

mixed —

romanCut()

romanCut(mixed  $num, mixed  $n) : mixed

Parameters

mixed $num
mixed $n

Returns

mixed —

evaluateGCD()

evaluateGCD(mixed  $a, mixed  $b) : mixed

Parameters

mixed $a
mixed $b

Returns

mixed —