ARABIC()
ARABIC(string $roman) : int|string
ARABIC.
Converts a Roman numeral to an Arabic numeral.
Excel Function: ARABIC(text)
Parameters
| string | $roman |
Returns
int|string —the arabic numberal contrived from the roman numeral
ATAN2(float $xCoordinate = null, float $yCoordinate = null) : float|string
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)
| float | $xCoordinate | the x-coordinate of the point |
| float | $yCoordinate | the y-coordinate of the point |
the inverse tangent of the specified x- and y-coordinates, or a string containing an error
BASE(float $number, float $radix, int $minLength = null) : string
BASE.
Converts a number into a text representation with the given radix (base).
Excel Function: BASE(Number, Radix [Min_length])
| float | $number | |
| float | $radix | |
| int | $minLength |
the text representation with the given radix (base)
CEILING(float $number, float $significance = null) : float|string
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])
| float | $number | the number you want to round |
| float | $significance | the multiple to which you want to round |
Rounded Number, or a string containing an error
COMBIN(int $numObjs, int $numInSet) : int|string
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)
| int | $numObjs | Number of different objects |
| int | $numInSet | Number of objects in each combination |
Number of combinations, or a string containing an error
EVEN(float $number) : int|string
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)
| float | $number | Number to round |
Rounded Number, or a string containing an error
FLOOR(float $number, float $significance = null) : float|string
FLOOR.
Rounds number down, toward zero, to the nearest multiple of significance.
Excel Function: FLOOR(number[,significance])
| float | $number | Number to round |
| float | $significance | Significance |
Rounded Number, or a string containing an error
FLOORMATH(float $number, float $significance = null, int $mode) : float|string
FLOOR.MATH.
Round a number down to the nearest integer or to the nearest multiple of significance.
Excel Function: FLOOR.MATH(number[,significance[,mode]])
| float | $number | Number to round |
| float | $significance | Significance |
| int | $mode | direction to round negative numbers |
Rounded Number, or a string containing an error
FLOORPRECISE(float $number, float $significance = 1) : float|string
FLOOR.PRECISE.
Rounds number down, toward zero, to the nearest multiple of significance.
Excel Function: FLOOR.PRECISE(number[,significance])
| float | $number | Number to round |
| float | $significance | Significance |
Rounded Number, or a string containing an error
GCD(mixed ...$args) : int|mixed|string
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[, ...]])
| mixed | $args variadic | Data values |
Greatest Common Divisor, or a string containing an error
LCM(mixed ...$args) : int|string
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[, ...]])
| mixed | $args variadic | Data values |
Lowest Common Multiplier, or a string containing an error
logBase(float $number = null, float $base = 10) : float|string
LOG_BASE.
Returns the logarithm of a number to a specified base. The default base is 10.
Excel Function: LOG(number[,base])
| 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. |
The result, or a string containing an error
ROUNDUP(float $number, int $digits) : float|string
ROUNDUP.
Rounds a number up to a specified number of decimal places
| float | $number | Number to round |
| int | $digits | Number of digits to which you want to round $number |
Rounded Number, or a string containing an error
ROUNDDOWN(float $number, int $digits) : float|string
ROUNDDOWN.
Rounds a number down to a specified number of decimal places
| float | $number | Number to round |
| int | $digits | Number of digits to which you want to round $number |
Rounded Number, or a string containing an error
SUBTOTAL(int $functionType, array ...$args) : float|string
SUBTOTAL.
Returns a subtotal in a list or database.
| int | $functionType | A number 1 to 11 that specifies which function to use in calculating subtotals within a range list Numbers 101 to 111 shadow the functions of 1 to 11 but ignore any values in the range that are in hidden rows or columns |
| array | $args variadic | A mixed data series of values |
SUMIF(mixed $range, string $criteria, mixed $sumRange = []) : float
SUMIF.
Totals the values of cells that contain numbers within the list of arguments
Excel Function: SUMIF(range, criteria, [sum_range])
| mixed | $range | Data values |
| string | $criteria | the criteria that defines which cells will be summed |
| mixed | $sumRange |