Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.3.x will end 7 October 2024 (12 months).
  • Bug fixes for security issues in 4.3.x will end 21 April 2025 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.2.x is supported too.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Engineering/ -> Compare.php (source)

[Source view]

Differences Between: [Versions 400 and 403]

(no description)

File Size: 82 lines (3 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.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.

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

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

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