PHPOffice /
PhpSpreadsheet
| @@ 1570-1583 (lines=14) @@ | ||
| 1567 | * |
|
| 1568 | * @return float |
|
| 1569 | */ |
|
| 1570 | public static function GAMMALN($value) |
|
| 1571 | { |
|
| 1572 | $value = Functions::flattenSingleValue($value); |
|
| 1573 | ||
| 1574 | if (is_numeric($value)) { |
|
| 1575 | if ($value <= 0) { |
|
| 1576 | return Functions::NAN(); |
|
| 1577 | } |
|
| 1578 | ||
| 1579 | return log(self::gamma($value)); |
|
| 1580 | } |
|
| 1581 | ||
| 1582 | return Functions::VALUE(); |
|
| 1583 | } |
|
| 1584 | ||
| 1585 | /** |
|
| 1586 | * GEOMEAN. |
|
| @@ 1055-1068 (lines=14) @@ | ||
| 1052 | * |
|
| 1053 | * @return float Square Root of Number * Pi |
|
| 1054 | */ |
|
| 1055 | public static function SQRTPI($number) |
|
| 1056 | { |
|
| 1057 | $number = Functions::flattenSingleValue($number); |
|
| 1058 | ||
| 1059 | if (is_numeric($number)) { |
|
| 1060 | if ($number < 0) { |
|
| 1061 | return Functions::NAN(); |
|
| 1062 | } |
|
| 1063 | ||
| 1064 | return sqrt($number * M_PI); |
|
| 1065 | } |
|
| 1066 | ||
| 1067 | return Functions::VALUE(); |
|
| 1068 | } |
|
| 1069 | ||
| 1070 | protected static function filterHiddenArgs($cellReference, $args) |
|
| 1071 | { |
|
