\PhpOffice\PhpSpreadsheet\Calculation\EngineeringCompare

Summary

Methods
Properties
Constants
DELTA()
GESTEP()
No public properties found
No constants found
No protected methods found
No protected properties found
N/A
No private methods found
No private properties found
N/A

Methods

DELTA()

DELTA(float  $a, float  $b) : int|string

DELTA.

Excel Function: DELTA(a[,b])

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.

Parameters

float $a

the first number

float $b

The second number. If omitted, b is assumed to be zero.

Returns

int|string —

(string in the event of an error)

GESTEP()

GESTEP(float  $number, float  $step) : int|string

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.

Returns

int|string —

(string in the event of an error)