Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.0.x will end 8 May 2023 (12 months).
  • Bug fixes for security issues in 4.0.x will end 13 November 2023 (18 months).
  • PHP version: minimum PHP 7.3.0 Note: the minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is also supported.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Engineering/ -> Compare.php (source)

[Source view]

Differences Between: [Versions 400 and 401] [Versions 400 and 402] [Versions 400 and 403]

(no description)

File Size: 70 lines (2 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

Compare:: (2 methods):
  DELTA()
  GESTEP()


Class: Compare  - X-Ref

DELTA($a, $b = 0)   X-Ref
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.

return: int|string (string in the event of an error)
param: float $a the first number
param: float $b The second number. If omitted, b is assumed to be zero.

GESTEP($number, $step = 0)   X-Ref
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.

return: int|string (string in the event of an error)
param: float $number the value to test against step
param: float $step The threshold value. If you omit a value for step, GESTEP uses zero.