class Engineering (View source)

Constants

EULER

EULER.

Methods

static mixed[]
parseComplex(string $complexNumber) deprecated

parseComplex.

static float
BESSELI(float $x, int $ord)

BESSELI.

static float
BESSELJ(float $x, int $ord)

BESSELJ.

static float
BESSELK(float $x, int $ord)

BESSELK.

static float
BESSELY(float $x, int $ord)

BESSELY.

static string
BINTODEC(string $x)

BINTODEC.

static string
BINTOHEX(string $x, int $places = null)

BINTOHEX.

static string
BINTOOCT(string $x, int $places = null)

BINTOOCT.

static string
DECTOBIN(string $x, int $places = null)

DECTOBIN.

static string
DECTOHEX(string $x, int $places = null)

DECTOHEX.

static string
DECTOOCT(string $x, int $places = null)

DECTOOCT.

static string
HEXTOBIN(string $x, int $places = null)

HEXTOBIN.

static string
HEXTODEC(string $x)

HEXTODEC.

static string
HEXTOOCT(string $x, int $places = null)

HEXTOOCT.

static string
OCTTOBIN(string $x, int $places = null)

OCTTOBIN.

static string
OCTTODEC(string $x)

OCTTODEC.

static string
OCTTOHEX(string $x, int $places = null)

OCTTOHEX.

static string
COMPLEX(float $realNumber = 0.0, float $imaginary = 0.0, string $suffix = 'i')

COMPLEX.

static float
IMAGINARY(string $complexNumber)

IMAGINARY.

static float
IMREAL(string $complexNumber)

IMREAL.

static float
IMABS(string $complexNumber)

IMABS.

static float|string
IMARGUMENT(string $complexNumber)

IMARGUMENT.

static string
IMCONJUGATE(string $complexNumber)

IMCONJUGATE.

static float|string
IMCOS(string $complexNumber)

IMCOS.

static float|string
IMCOSH(string $complexNumber)

IMCOSH.

static float|string
IMCOT(string $complexNumber)

IMCOT.

static float|string
IMCSC(string $complexNumber)

IMCSC.

static float|string
IMCSCH(string $complexNumber)

IMCSCH.

static float|string
IMSIN(string $complexNumber)

IMSIN.

static float|string
IMSINH(string $complexNumber)

IMSINH.

static float|string
IMSEC(string $complexNumber)

IMSEC.

static float|string
IMSECH(string $complexNumber)

IMSECH.

static float|string
IMTAN(string $complexNumber)

IMTAN.

static string
IMSQRT(string $complexNumber)

IMSQRT.

static string
IMLN(string $complexNumber)

IMLN.

static string
IMLOG10(string $complexNumber)

IMLOG10.

static string
IMLOG2(string $complexNumber)

IMLOG2.

static string
IMEXP(string $complexNumber)

IMEXP.

static string
IMPOWER(string $complexNumber, float $realNumber)

IMPOWER.

static string
IMDIV(string $complexDividend, string $complexDivisor)

IMDIV.

static string
IMSUB(string $complexNumber1, string $complexNumber2)

IMSUB.

static string
IMSUM(string ...$complexNumbers)

IMSUM.

static string
IMPRODUCT(string ...$complexNumbers)

IMPRODUCT.

static int
DELTA(float $a, float $b = 0)

DELTA.

static int
GESTEP(float $number, float $step = 0)

GESTEP.

static 
erfVal($x)

No description

static int|string
BITAND(int $number1, int $number2)

BITAND.

static int|string
BITOR(int $number1, int $number2)

BITOR.

static int|string
BITXOR(int $number1, int $number2)

BITXOR.

static int|string
BITLSHIFT(int $number, int $shiftAmount)

BITLSHIFT.

static int|string
BITRSHIFT(int $number, int $shiftAmount)

BITRSHIFT.

static float|string
ERF(float $lower, float $upper = null)

ERF.

static float|string
ERFPRECISE(float $limit)

ERFPRECISE.

static float|string
ERFC(float $x)

ERFC.

static array
getConversionGroups()

getConversionGroups Returns a list of the different conversion groups for UOM conversions.

static array
getConversionGroupUnits(string $group = null)

getConversionGroupUnits Returns an array of units of measure, for a specified conversion group, or for all groups.

static array
getConversionGroupUnitDetails(string $group = null)

getConversionGroupUnitDetails.

static array
getConversionMultipliers()

getConversionMultipliers Returns an array of the Multiplier prefixes that can be used with Units of Measure in CONVERTUOM().

static float|string
CONVERTUOM(float $value, string $fromUOM, string $toUOM)

CONVERTUOM.

Details

static mixed[] parseComplex(string $complexNumber) deprecated

deprecated 2.0.0 No longer used by internal code. Please use the Complex\Complex class instead

parseComplex.

Parses a complex number into its real and imaginary parts, and an I or J suffix

Parameters

string $complexNumber The complex number

Return Value

mixed[] Indexed on "real", "imaginary" and "suffix"

static float BESSELI(float $x, int $ord)

BESSELI.

Returns the modified Bessel function In(x), which is equivalent to the Bessel function evaluated for purely imaginary arguments

Excel Function: BESSELI(x,ord)

Parameters

float $x The value at which to evaluate the function. If x is nonnumeric, BESSELI returns the #VALUE! error value.
int $ord The order of the Bessel function. If ord is not an integer, it is truncated. If $ord is nonnumeric, BESSELI returns the #VALUE! error value. If $ord < 0, BESSELI returns the #NUM! error value.

Return Value

float

static float BESSELJ(float $x, int $ord)

BESSELJ.

Returns the Bessel function

Excel Function: BESSELJ(x,ord)

Parameters

float $x The value at which to evaluate the function. If x is nonnumeric, BESSELJ returns the #VALUE! error value.
int $ord The order of the Bessel function. If n is not an integer, it is truncated. If $ord is nonnumeric, BESSELJ returns the #VALUE! error value. If $ord < 0, BESSELJ returns the #NUM! error value.

Return Value

float

static float BESSELK(float $x, int $ord)

BESSELK.

Returns the modified Bessel function Kn(x), which is equivalent to the Bessel functions evaluated for purely imaginary arguments.

Excel Function: BESSELK(x,ord)

Parameters

float $x The value at which to evaluate the function. If x is nonnumeric, BESSELK returns the #VALUE! error value.
int $ord The order of the Bessel function. If n is not an integer, it is truncated. If $ord is nonnumeric, BESSELK returns the #VALUE! error value. If $ord < 0, BESSELK returns the #NUM! error value.

Return Value

float

static float BESSELY(float $x, int $ord)

BESSELY.

Returns the Bessel function, which is also called the Weber function or the Neumann function.

Excel Function: BESSELY(x,ord)

Parameters

float $x The value at which to evaluate the function. If x is nonnumeric, BESSELK returns the #VALUE! error value.
int $ord The order of the Bessel function. If n is not an integer, it is truncated. If $ord is nonnumeric, BESSELK returns the #VALUE! error value. If $ord < 0, BESSELK returns the #NUM! error value.

Return Value

float

static string BINTODEC(string $x)

BINTODEC.

Return a binary value as decimal.

Excel Function: BIN2DEC(x)

Parameters

string $x The binary number (as a string) that you want to convert. The number cannot contain more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2DEC returns the #NUM! error value.

Return Value

string

static string BINTOHEX(string $x, int $places = null)

BINTOHEX.

Return a binary value as hex.

Excel Function: BIN2HEX(x[,places])

Parameters

string $x The binary number (as a string) that you want to convert. The number cannot contain more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2HEX returns the #NUM! error value.
int $places The number of characters to use. If places is omitted, BIN2HEX uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros). If places is not an integer, it is truncated. If places is nonnumeric, BIN2HEX returns the #VALUE! error value. If places is negative, BIN2HEX returns the #NUM! error value.

Return Value

string

static string BINTOOCT(string $x, int $places = null)

BINTOOCT.

Return a binary value as octal.

Excel Function: BIN2OCT(x[,places])

Parameters

string $x The binary number (as a string) that you want to convert. The number cannot contain more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2OCT returns the #NUM! error value.
int $places The number of characters to use. If places is omitted, BIN2OCT uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros). If places is not an integer, it is truncated. If places is nonnumeric, BIN2OCT returns the #VALUE! error value. If places is negative, BIN2OCT returns the #NUM! error value.

Return Value

string

static string DECTOBIN(string $x, int $places = null)

DECTOBIN.

Return a decimal value as binary.

Excel Function: DEC2BIN(x[,places])

Parameters

string $x The decimal integer you want to convert. If number is negative, valid place values are ignored and DEC2BIN returns a 10-character (10-bit) binary number in which the most significant bit is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number < -512 or if number > 511, DEC2BIN returns the #NUM! error value. If number is nonnumeric, DEC2BIN returns the #VALUE! error value. If DEC2BIN requires more than places characters, it returns the #NUM! error value.
int $places The number of characters to use. If places is omitted, DEC2BIN uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros). If places is not an integer, it is truncated. If places is nonnumeric, DEC2BIN returns the #VALUE! error value. If places is zero or negative, DEC2BIN returns the #NUM! error value.

Return Value

string

static string DECTOHEX(string $x, int $places = null)

DECTOHEX.

Return a decimal value as hex.

Excel Function: DEC2HEX(x[,places])

Parameters

string $x The decimal integer you want to convert. If number is negative, places is ignored and DEC2HEX returns a 10-character (40-bit) hexadecimal number in which the most significant bit is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number < -549,755,813,888 or if number > 549,755,813,887, DEC2HEX returns the #NUM! error value. If number is nonnumeric, DEC2HEX returns the #VALUE! error value. If DEC2HEX requires more than places characters, it returns the #NUM! error value.
int $places The number of characters to use. If places is omitted, DEC2HEX uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros). If places is not an integer, it is truncated. If places is nonnumeric, DEC2HEX returns the #VALUE! error value. If places is zero or negative, DEC2HEX returns the #NUM! error value.

Return Value

string

static string DECTOOCT(string $x, int $places = null)

DECTOOCT.

Return an decimal value as octal.

Excel Function: DEC2OCT(x[,places])

Parameters

string $x The decimal integer you want to convert. If number is negative, places is ignored and DEC2OCT returns a 10-character (30-bit) octal number in which the most significant bit is the sign bit. The remaining 29 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number < -536,870,912 or if number > 536,870,911, DEC2OCT returns the #NUM! error value. If number is nonnumeric, DEC2OCT returns the #VALUE! error value. If DEC2OCT requires more than places characters, it returns the #NUM! error value.
int $places The number of characters to use. If places is omitted, DEC2OCT uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros). If places is not an integer, it is truncated. If places is nonnumeric, DEC2OCT returns the #VALUE! error value. If places is zero or negative, DEC2OCT returns the #NUM! error value.

Return Value

string

static string HEXTOBIN(string $x, int $places = null)

HEXTOBIN.

Return a hex value as binary.

Excel Function: HEX2BIN(x[,places])

Parameters

string $x the hexadecimal number you want to convert. Number cannot contain more than 10 characters. The most significant bit of number is the sign bit (40th bit from the right). The remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number is negative, HEX2BIN ignores places and returns a 10-character binary number. If number is negative, it cannot be less than FFFFFFFE00, and if number is positive, it cannot be greater than 1FF. If number is not a valid hexadecimal number, HEX2BIN returns the #NUM! error value. If HEX2BIN requires more than places characters, it returns the #NUM! error value.
int $places The number of characters to use. If places is omitted, HEX2BIN uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros). If places is not an integer, it is truncated. If places is nonnumeric, HEX2BIN returns the #VALUE! error value. If places is negative, HEX2BIN returns the #NUM! error value.

Return Value

string

static string HEXTODEC(string $x)

HEXTODEC.

Return a hex value as decimal.

Excel Function: HEX2DEC(x)

Parameters

string $x The hexadecimal number you want to convert. This number cannot contain more than 10 characters (40 bits). The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number is not a valid hexadecimal number, HEX2DEC returns the #NUM! error value.

Return Value

string

static string HEXTOOCT(string $x, int $places = null)

HEXTOOCT.

Return a hex value as octal.

Excel Function: HEX2OCT(x[,places])

Parameters

string $x The hexadecimal number you want to convert. Number cannot contain more than 10 characters. The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number is negative, HEX2OCT ignores places and returns a 10-character octal number. If number is negative, it cannot be less than FFE0000000, and if number is positive, it cannot be greater than 1FFFFFFF. If number is not a valid hexadecimal number, HEX2OCT returns the #NUM! error value. If HEX2OCT requires more than places characters, it returns the #NUM! error value.
int $places The number of characters to use. If places is omitted, HEX2OCT uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros). If places is not an integer, it is truncated. If places is nonnumeric, HEX2OCT returns the #VALUE! error value. If places is negative, HEX2OCT returns the #NUM! error value.

Return Value

string

static string OCTTOBIN(string $x, int $places = null)

OCTTOBIN.

Return an octal value as binary.

Excel Function: OCT2BIN(x[,places])

Parameters

string $x The octal number you want to convert. Number may not contain more than 10 characters. The most significant bit of number is the sign bit. The remaining 29 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number is negative, OCT2BIN ignores places and returns a 10-character binary number. If number is negative, it cannot be less than 7777777000, and if number is positive, it cannot be greater than 777. If number is not a valid octal number, OCT2BIN returns the #NUM! error value. If OCT2BIN requires more than places characters, it returns the #NUM! error value.
int $places The number of characters to use. If places is omitted, OCT2BIN uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros). If places is not an integer, it is truncated. If places is nonnumeric, OCT2BIN returns the #VALUE! error value. If places is negative, OCT2BIN returns the #NUM! error value.

Return Value

string

static string OCTTODEC(string $x)

OCTTODEC.

Return an octal value as decimal.

Excel Function: OCT2DEC(x)

Parameters

string $x The octal number you want to convert. Number may not contain more than 10 octal characters (30 bits). The most significant bit of number is the sign bit. The remaining 29 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number is not a valid octal number, OCT2DEC returns the #NUM! error value.

Return Value

string

static string OCTTOHEX(string $x, int $places = null)

OCTTOHEX.

Return an octal value as hex.

Excel Function: OCT2HEX(x[,places])

Parameters

string $x The octal number you want to convert. Number may not contain more than 10 octal characters (30 bits). The most significant bit of number is the sign bit. The remaining 29 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number is negative, OCT2HEX ignores places and returns a 10-character hexadecimal number. If number is not a valid octal number, OCT2HEX returns the #NUM! error value. If OCT2HEX requires more than places characters, it returns the #NUM! error value.
int $places The number of characters to use. If places is omitted, OCT2HEX uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros). If places is not an integer, it is truncated. If places is nonnumeric, OCT2HEX returns the #VALUE! error value. If places is negative, OCT2HEX returns the #NUM! error value.

Return Value

string

static string COMPLEX(float $realNumber = 0.0, float $imaginary = 0.0, string $suffix = 'i')

COMPLEX.

Converts real and imaginary coefficients into a complex number of the form x +/- yi or x +/- yj.

Excel Function: COMPLEX(realNumber,imaginary[,suffix])

Parameters

float $realNumber the real coefficient of the complex number
float $imaginary the imaginary coefficient of the complex number
string $suffix The suffix for the imaginary component of the complex number. If omitted, the suffix is assumed to be "i".

Return Value

string

static float IMAGINARY(string $complexNumber)

IMAGINARY.

Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.

Excel Function: IMAGINARY(complexNumber)

Parameters

string $complexNumber the complex number for which you want the imaginary coefficient

Return Value

float

static float IMREAL(string $complexNumber)

IMREAL.

Returns the real coefficient of a complex number in x + yi or x + yj text format.

Excel Function: IMREAL(complexNumber)

Parameters

string $complexNumber the complex number for which you want the real coefficient

Return Value

float

static float IMABS(string $complexNumber)

IMABS.

Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format.

Excel Function: IMABS(complexNumber)

Parameters

string $complexNumber the complex number for which you want the absolute value

Return Value

float

static float|string IMARGUMENT(string $complexNumber)

IMARGUMENT.

Returns the argument theta of a complex number, i.e. the angle in radians from the real axis to the representation of the number in polar coordinates.

Excel Function: IMARGUMENT(complexNumber)

Parameters

string $complexNumber the complex number for which you want the argument theta

Return Value

float|string

static string IMCONJUGATE(string $complexNumber)

IMCONJUGATE.

Returns the complex conjugate of a complex number in x + yi or x + yj text format.

Excel Function: IMCONJUGATE(complexNumber)

Parameters

string $complexNumber the complex number for which you want the conjugate

Return Value

string

static float|string IMCOS(string $complexNumber)

IMCOS.

Returns the cosine of a complex number in x + yi or x + yj text format.

Excel Function: IMCOS(complexNumber)

Parameters

string $complexNumber the complex number for which you want the cosine

Return Value

float|string

static float|string IMCOSH(string $complexNumber)

IMCOSH.

Returns the hyperbolic cosine of a complex number in x + yi or x + yj text format.

Excel Function: IMCOSH(complexNumber)

Parameters

string $complexNumber the complex number for which you want the hyperbolic cosine

Return Value

float|string

static float|string IMCOT(string $complexNumber)

IMCOT.

Returns the cotangent of a complex number in x + yi or x + yj text format.

Excel Function: IMCOT(complexNumber)

Parameters

string $complexNumber the complex number for which you want the cotangent

Return Value

float|string

static float|string IMCSC(string $complexNumber)

IMCSC.

Returns the cosecant of a complex number in x + yi or x + yj text format.

Excel Function: IMCSC(complexNumber)

Parameters

string $complexNumber the complex number for which you want the cosecant

Return Value

float|string

static float|string IMCSCH(string $complexNumber)

IMCSCH.

Returns the hyperbolic cosecant of a complex number in x + yi or x + yj text format.

Excel Function: IMCSCH(complexNumber)

Parameters

string $complexNumber the complex number for which you want the hyperbolic cosecant

Return Value

float|string

static float|string IMSIN(string $complexNumber)

IMSIN.

Returns the sine of a complex number in x + yi or x + yj text format.

Excel Function: IMSIN(complexNumber)

Parameters

string $complexNumber the complex number for which you want the sine

Return Value

float|string

static float|string IMSINH(string $complexNumber)

IMSINH.

Returns the hyperbolic sine of a complex number in x + yi or x + yj text format.

Excel Function: IMSINH(complexNumber)

Parameters

string $complexNumber the complex number for which you want the hyperbolic sine

Return Value

float|string

static float|string IMSEC(string $complexNumber)

IMSEC.

Returns the secant of a complex number in x + yi or x + yj text format.

Excel Function: IMSEC(complexNumber)

Parameters

string $complexNumber the complex number for which you want the secant

Return Value

float|string

static float|string IMSECH(string $complexNumber)

IMSECH.

Returns the hyperbolic secant of a complex number in x + yi or x + yj text format.

Excel Function: IMSECH(complexNumber)

Parameters

string $complexNumber the complex number for which you want the hyperbolic secant

Return Value

float|string

static float|string IMTAN(string $complexNumber)

IMTAN.

Returns the tangent of a complex number in x + yi or x + yj text format.

Excel Function: IMTAN(complexNumber)

Parameters

string $complexNumber the complex number for which you want the tangent

Return Value

float|string

static string IMSQRT(string $complexNumber)

IMSQRT.

Returns the square root of a complex number in x + yi or x + yj text format.

Excel Function: IMSQRT(complexNumber)

Parameters

string $complexNumber the complex number for which you want the square root

Return Value

string

static string IMLN(string $complexNumber)

IMLN.

Returns the natural logarithm of a complex number in x + yi or x + yj text format.

Excel Function: IMLN(complexNumber)

Parameters

string $complexNumber the complex number for which you want the natural logarithm

Return Value

string

static string IMLOG10(string $complexNumber)

IMLOG10.

Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.

Excel Function: IMLOG10(complexNumber)

Parameters

string $complexNumber the complex number for which you want the common logarithm

Return Value

string

static string IMLOG2(string $complexNumber)

IMLOG2.

Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.

Excel Function: IMLOG2(complexNumber)

Parameters

string $complexNumber the complex number for which you want the base-2 logarithm

Return Value

string

static string IMEXP(string $complexNumber)

IMEXP.

Returns the exponential of a complex number in x + yi or x + yj text format.

Excel Function: IMEXP(complexNumber)

Parameters

string $complexNumber the complex number for which you want the exponential

Return Value

string

static string IMPOWER(string $complexNumber, float $realNumber)

IMPOWER.

Returns a complex number in x + yi or x + yj text format raised to a power.

Excel Function: IMPOWER(complexNumber,realNumber)

Parameters

string $complexNumber the complex number you want to raise to a power
float $realNumber the power to which you want to raise the complex number

Return Value

string

static string IMDIV(string $complexDividend, string $complexDivisor)

IMDIV.

Returns the quotient of two complex numbers in x + yi or x + yj text format.

Excel Function: IMDIV(complexDividend,complexDivisor)

Parameters

string $complexDividend the complex numerator or dividend
string $complexDivisor the complex denominator or divisor

Return Value

string

static string IMSUB(string $complexNumber1, string $complexNumber2)

IMSUB.

Returns the difference of two complex numbers in x + yi or x + yj text format.

Excel Function: IMSUB(complexNumber1,complexNumber2)

Parameters

string $complexNumber1 the complex number from which to subtract complexNumber2
string $complexNumber2 the complex number to subtract from complexNumber1

Return Value

string

static string IMSUM(string ...$complexNumbers)

IMSUM.

Returns the sum of two or more complex numbers in x + yi or x + yj text format.

Excel Function: IMSUM(complexNumber[,complexNumber[,...]])

Parameters

string ...$complexNumbers Series of complex numbers to add

Return Value

string

static string IMPRODUCT(string ...$complexNumbers)

IMPRODUCT.

Returns the product of two or more complex numbers in x + yi or x + yj text format.

Excel Function: IMPRODUCT(complexNumber[,complexNumber[,...]])

Parameters

string ...$complexNumbers Series of complex numbers to multiply

Return Value

string

static int DELTA(float $a, float $b = 0)

DELTA.

Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function.

Excel Function: DELTA(a[,b])

Parameters

float $a the first number
float $b The second number. If omitted, b is assumed to be zero.

Return Value

int

static int GESTEP(float $number, float $step = 0)

GESTEP.

Excel Function: GESTEP(number[,step])

Returns 1 if number >= step; returns 0 (zero) otherwise Use this function to filter a set of values. For example, by summing several GESTEP functions you calculate the count of values that exceed a threshold.

Parameters

float $number the value to test against step
float $step The threshold value. If you omit a value for step, GESTEP uses zero.

Return Value

int

static erfVal($x)

Parameters

$x

static int|string BITAND(int $number1, int $number2)

BITAND.

Returns the bitwise AND of two integer values.

Excel Function: BITAND(number1, number2)

Parameters

int $number1
int $number2

Return Value

int|string

static int|string BITOR(int $number1, int $number2)

BITOR.

Returns the bitwise OR of two integer values.

Excel Function: BITOR(number1, number2)

Parameters

int $number1
int $number2

Return Value

int|string

static int|string BITXOR(int $number1, int $number2)

BITXOR.

Returns the bitwise XOR of two integer values.

Excel Function: BITXOR(number1, number2)

Parameters

int $number1
int $number2

Return Value

int|string

static int|string BITLSHIFT(int $number, int $shiftAmount)

BITLSHIFT.

Returns the number value shifted left by shift_amount bits.

Excel Function: BITLSHIFT(number, shift_amount)

Parameters

int $number
int $shiftAmount

Return Value

int|string

static int|string BITRSHIFT(int $number, int $shiftAmount)

BITRSHIFT.

Returns the number value shifted right by shift_amount bits.

Excel Function: BITRSHIFT(number, shift_amount)

Parameters

int $number
int $shiftAmount

Return Value

int|string

static float|string ERF(float $lower, float $upper = null)

ERF.

Returns the error function integrated between the lower and upper bound arguments.

Note: In Excel 2007 or earlier, if you input a negative value for the upper or lower bound arguments, the function would return a #NUM! error. However, in Excel 2010, the function algorithm was improved, so that it can now calculate the function for both positive and negative ranges. PhpSpreadsheet follows Excel 2010 behaviour, and accepts negative arguments.

Excel Function: ERF(lower[,upper])

Parameters

float $lower lower bound for integrating ERF
float $upper upper bound for integrating ERF. If omitted, ERF integrates between zero and lower_limit

Return Value

float|string

static float|string ERFPRECISE(float $limit)

ERFPRECISE.

Returns the error function integrated between the lower and upper bound arguments.

Excel Function: ERF.PRECISE(limit)

Parameters

float $limit bound for integrating ERF

Return Value

float|string

static float|string ERFC(float $x)

ERFC.

Returns the complementary ERF function integrated between x and infinity

Note: In Excel 2007 or earlier, if you input a negative value for the lower bound argument, the function would return a #NUM! error. However, in Excel 2010, the function algorithm was improved, so that it can now calculate the function for both positive and negative x values. PhpSpreadsheet follows Excel 2010 behaviour, and accepts nagative arguments.

Excel Function: ERFC(x)

Parameters

float $x The lower bound for integrating ERFC

Return Value

float|string

static array getConversionGroups()

getConversionGroups Returns a list of the different conversion groups for UOM conversions.

Return Value

array

static array getConversionGroupUnits(string $group = null)

getConversionGroupUnits Returns an array of units of measure, for a specified conversion group, or for all groups.

Parameters

string $group The group whose units of measure you want to retrieve

Return Value

array

static array getConversionGroupUnitDetails(string $group = null)

getConversionGroupUnitDetails.

Parameters

string $group The group whose units of measure you want to retrieve

Return Value

array

static array getConversionMultipliers()

getConversionMultipliers Returns an array of the Multiplier prefixes that can be used with Units of Measure in CONVERTUOM().

Return Value

array of mixed

static float|string CONVERTUOM(float $value, string $fromUOM, string $toUOM)

CONVERTUOM.

Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.

Excel Function: CONVERT(value,fromUOM,toUOM)

Parameters

float $value the value in fromUOM to convert
string $fromUOM the units for value
string $toUOM the units for the result

Return Value

float|string