\PhpOffice\PhpSpreadsheet\CalculationMathTrig

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

Returns

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

Returns

Rounded Number

COMBIN()

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

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

Returns

Number of combinations

EVEN()

EVEN(float  $number) : integer

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

Returns

Rounded Number

FACT()

FACT(float  $factVal) : integer

FACT.

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

Excel Function: FACT(factVal)

Parameters

Returns

Factorial

FACTDOUBLE()

FACTDOUBLE(float  $factVal) : integer

FACTDOUBLE.

Returns the double factorial of a number.

Excel Function: FACTDOUBLE(factVal)

Parameters

Returns

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

Returns

Rounded Number

GCD()

GCD(mixed  ...$args) : integer

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

Returns

Greatest Common Divisor

INT()

INT(float  $number) : integer

INT.

Casts a floating point value to an integer

Excel Function: INT(number)

Parameters

Returns

Integer value

LCM()

LCM(mixed  ...$args) : integer

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

Returns

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

Returns

MDETERM()

MDETERM(array  $matrixValues) : float

MDETERM.

Returns the matrix determinant of an array.

Excel Function: MDETERM(array)

Parameters

Returns

MINVERSE()

MINVERSE(array  $matrixValues) : array

MINVERSE.

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

Excel Function: MINVERSE(array)

Parameters

Returns

MMULT()

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

MMULT.

Parameters

Returns

MOD()

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

MOD.

Parameters

Returns

Remainder

MROUND()

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

MROUND.

Rounds a number to the nearest multiple of a specified value

Parameters

Returns

Rounded Number

MULTINOMIAL()

MULTINOMIAL(  $args) : float

MULTINOMIAL.

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

Parameters

Returns

ODD()

ODD(float  $number) : integer

ODD.

Returns number rounded up to the nearest odd integer.

Parameters

Returns

Rounded Number

POWER()

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

POWER.

Computes x raised to the power y.

Parameters

Returns

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

Returns

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

Returns

RAND()

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

RAND.

Parameters

Returns

Random number

ROMAN()

ROMAN(  $aValue,   $style) 

Parameters

ROUNDUP()

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

ROUNDUP.

Rounds a number up to a specified number of decimal places

Parameters

Returns

Rounded Number

ROUNDDOWN()

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

ROUNDDOWN.

Rounds a number down to a specified number of decimal places

Parameters

Returns

Rounded Number

SERIESSUM()

SERIESSUM(  $args) : float

SERIESSUM.

Returns the sum of a power series

Parameters

Returns

SIGN()

SIGN(float  $number) : integer

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

Returns

sign value

SQRTPI()

SQRTPI(float  $number) : float

SQRTPI.

Returns the square root of (number * pi).

Parameters

Returns

Square Root of Number * Pi

SUBTOTAL()

SUBTOTAL(  $args) : float

SUBTOTAL.

Returns a subtotal in a list or database.

Parameters

Returns

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

Returns

SUMIF()

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

SUMIF.

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

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

Parameters

Returns

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

Returns

SUMPRODUCT()

SUMPRODUCT(mixed  ...$args) : float

SUMPRODUCT.

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

Parameters

Returns

SUMSQ()

SUMSQ(mixed  ...$args) : float

SUMSQ.

SUMSQ returns the sum of the squares of the arguments

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

Parameters

Returns

SUMX2MY2()

SUMX2MY2(array<mixed,mixed>  $matrixData1, array<mixed,mixed>  $matrixData2) : float

SUMX2MY2.

Parameters

Returns

SUMX2PY2()

SUMX2PY2(array<mixed,mixed>  $matrixData1, array<mixed,mixed>  $matrixData2) : float

SUMX2PY2.

Parameters

Returns

SUMXMY2()

SUMXMY2(array<mixed,mixed>  $matrixData1, array<mixed,mixed>  $matrixData2) : float

SUMXMY2.

Parameters

Returns

TRUNC()

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

TRUNC.

Truncates value to the number of fractional digits by number_digits.

Parameters

Returns

Truncated value

SEC()

SEC(float  $angle) : float|string

SEC.

Returns the secant of an angle.

Parameters

Returns

The secant of the angle

SECH()

SECH(float  $angle) : float|string

SECH.

Returns the hyperbolic secant of an angle.

Parameters

Returns

The hyperbolic secant of the angle

CSC()

CSC(float  $angle) : float|string

CSC.

Returns the cosecant of an angle.

Parameters

Returns

The cosecant of the angle

CSCH()

CSCH(float  $angle) : float|string

CSCH.

Returns the hyperbolic cosecant of an angle.

Parameters

Returns

The hyperbolic cosecant of the angle

COT()

COT(float  $angle) : float|string

COT.

Returns the cotangent of an angle.

Parameters

Returns

The cotangent of the angle

COTH()

COTH(float  $angle) : float|string

COTH.

Returns the hyperbolic cotangent of an angle.

Parameters

Returns

The hyperbolic cotangent of the angle

ACOT()

ACOT(float  $number) : float|string

ACOT.

Returns the arccotangent of a number.

Parameters

Returns

The arccotangent of the number

ACOTH()

ACOTH(float  $number) : float|string

ACOTH.

Returns the hyperbolic arccotangent of a number.

Parameters

Returns

The hyperbolic arccotangent of the number

filterHiddenArgs()

filterHiddenArgs(  $cellReference,   $args) 

Parameters

filterFormulaArgs()

filterFormulaArgs(  $cellReference,   $args) 

Parameters

factors()

factors(  $value) 

Parameters

romanCut()

romanCut(  $num,   $n) 

Parameters

evaluateGCD()

evaluateGCD(  $a,   $b) 

Parameters