You are here

Home » API reference » Loft Data Grids 7.2 » MathTrig.php » PHPExcel_Calculation_MathTrig

public static function PHPExcel_Calculation_MathTrig::FACT in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php \PHPExcel_Calculation_MathTrig::FACT()

* FACT * * Returns the factorial of a number. * The factorial of a number is equal to 1*2*3*...* number. * * Excel Function: * FACT(factVal) * * @access public * @category Mathematical and Trigonometric Functions *

Parameters

float $factVal Factorial Value: * @return int Factorial

6 calls to PHPExcel_Calculation_MathTrig::FACT()
PHPExcel_Calculation_Engineering::BESSELI in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* BESSELI * * Returns the modified Bessel function In(x), which is equivalent to the Bessel function evaluated * for purely imaginary arguments * * Excel Function: * BESSELI(x,ord) * * @access public * @category Engineering…
PHPExcel_Calculation_Engineering::BESSELJ in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* BESSELJ * * Returns the Bessel function * * Excel Function: * BESSELJ(x,ord) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_MathTrig::COMBIN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* COMBIN * * Returns the number of combinations for a given number of items. Use COMBIN to * determine the total possible number of groups for a given number of items. * * Excel Function: * COMBIN(numObjs,numInSet) * *…
PHPExcel_Calculation_MathTrig::MULTINOMIAL in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* MULTINOMIAL * * Returns the ratio of the factorial of a sum of values to the product of factorials. * *
PHPExcel_Calculation_Statistical::PERMUT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* PERMUT * * Returns the number of permutations for a given number of objects that can be * selected from number objects. A permutation is any set or subset of objects or * events where internal order is significant. Permutations are…

... See full list

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php, line 240

Class

PHPExcel_Calculation_MathTrig
PHPExcel_Calculation_MathTrig

Code

public static function FACT($factVal) {
  $factVal = PHPExcel_Calculation_Functions::flattenSingleValue($factVal);
  if (is_numeric($factVal)) {
    if ($factVal < 0) {
      return PHPExcel_Calculation_Functions::NaN();
    }
    $factLoop = floor($factVal);
    if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC) {
      if ($factVal > $factLoop) {
        return PHPExcel_Calculation_Functions::NaN();
      }
    }
    $factorial = 1;
    while ($factLoop > 1) {
      $factorial *= $factLoop--;
    }
    return $factorial;
  }
  return PHPExcel_Calculation_Functions::VALUE();
}