Search moodle.org's
Developer Documentation
Developer Documentation
- 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.
Differences Between: [Versions 400 and 402] [Versions 400 and 403]
(no description)
| File Size: | 304 lines (9 kb) |
| Included or required: | 0 times |
| Referenced: | 0 times |
| Includes or requires: | 0 files |
Defines 1 class
Conditional:: (15 methods):
AVERAGEIF()
AVERAGEIFS()
COUNTIF()
COUNTIFS()
MAXIFS()
MINIFS()
SUMIF()
SUMIFS()
buildConditionSet()
buildConditionSetForValueRange()
buildConditions()
buildDatabase()
buildDatabaseWithValueRange()
buildDataSet()
databaseFromRangeAndValue()
Class: Conditional - X-Ref
| AVERAGEIF($range, $condition, $averageRange = []) X-Ref |
| AVERAGEIF. Returns the average value from a range of cells that contain numbers within the list of arguments Excel Function: AVERAGEIF(range,condition[, average_range]) return: null|float|string param: mixed[] $range Data values param: string $condition the criteria that defines which cells will be checked param: mixed[] $averageRange Data values |
| AVERAGEIFS(...$args) X-Ref |
| AVERAGEIFS. Counts the number of cells that contain numbers within the list of arguments Excel Function: AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2]…) return: null|float|string param: mixed $args Pairs of Ranges and Criteria |
| COUNTIF($range, $condition) X-Ref |
| COUNTIF. Counts the number of cells that contain numbers within the list of arguments Excel Function: COUNTIF(range,condition) return: int param: mixed[] $range Data values param: string $condition the criteria that defines which cells will be counted |
| COUNTIFS(...$args) X-Ref |
| No description |
| MAXIFS(...$args) X-Ref |
| MAXIFS. Returns the maximum value within a range of cells that contain numbers within the list of arguments Excel Function: MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2]…) return: null|float|string param: mixed $args Pairs of Ranges and Criteria |
| MINIFS(...$args) X-Ref |
| MINIFS. Returns the minimum value within a range of cells that contain numbers within the list of arguments Excel Function: MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2]…) return: null|float|string param: mixed $args Pairs of Ranges and Criteria |
| SUMIF($range, $condition, $sumRange = []) X-Ref |
| SUMIF. Totals the values of cells that contain numbers within the list of arguments Excel Function: SUMIF(range, criteria, [sum_range]) return: float|string param: mixed $range Data values param: mixed $sumRange param: mixed $condition |
| SUMIFS(...$args) X-Ref |
| SUMIFS. Counts the number of cells that contain numbers within the list of arguments Excel Function: SUMIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2]…) return: null|float|string param: mixed $args Pairs of Ranges and Criteria |
| buildConditionSet(...$args) X-Ref |
| No description |
| buildConditionSetForValueRange(...$args) X-Ref |
| No description |
| buildConditions(int $startOffset, ...$args) X-Ref |
| No description |
| buildDatabase(...$args) X-Ref |
| No description |
| buildDatabaseWithValueRange(...$args) X-Ref |
| No description |
| buildDataSet(int $startOffset, array $database, ...$args) X-Ref |
| No description |
| databaseFromRangeAndValue(array $range, array $valueRange = []) X-Ref |
| No description |
