You are here

public static function PHPExcel_Calculation_Statistical::MIN in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php \PHPExcel_Calculation_Statistical::MIN()

* MIN * * MIN returns the value of the element of the values passed that has the smallest value, * with negative numbers considered smaller than positive numbers. * * Excel Function: * MIN(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *

Parameters

mixed $arg,... Data values: * @return float

4 calls to PHPExcel_Calculation_Statistical::MIN()
PHPExcel_Calculation_Database::DMIN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Database.php
* DMIN * * Returns the smallest number in a column of a list or database that matches conditions you that * specify. * * Excel Function: * DMIN(database,field,criteria) * * @access public * @category Database Functions *
PHPExcel_Calculation_MathTrig::SUBTOTAL in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* SUBTOTAL * * Returns a subtotal in a list or database. * *
PHPExcel_Calculation_Statistical::GEOMEAN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* GEOMEAN * * Returns the geometric mean of an array or range of positive data. For example, you * can use GEOMEAN to calculate average growth rate given compound interest with * variable rates. * * Excel Function: …
PHPExcel_Calculation_Statistical::HARMEAN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* HARMEAN * * Returns the harmonic mean of a data set. The harmonic mean is the reciprocal of the * arithmetic mean of reciprocals. * * Excel Function: * HARMEAN(value1[,value2[, ...]]) * * @access public * @category Statistical…

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php, line 2291

Class

PHPExcel_Calculation_Statistical
PHPExcel_Calculation_Statistical

Code

public static function MIN() {

  // Return value
  $returnValue = null;

  // Loop through arguments
  $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args());
  foreach ($aArgs as $arg) {

    // Is it a numeric value?
    if (is_numeric($arg) && !is_string($arg)) {
      if (is_null($returnValue) || $arg < $returnValue) {
        $returnValue = $arg;
      }
    }
  }

  // Return
  if (is_null($returnValue)) {
    return 0;
  }
  return $returnValue;
}