PHPOffice /
PhpSpreadsheet
| @@ 1070-1083 (lines=14) @@ | ||
| 1067 | * @param float $number Number |
|
| 1068 | * @return float Square Root of Number * Pi |
|
| 1069 | */ |
|
| 1070 | public static function SQRTPI($number) |
|
| 1071 | { |
|
| 1072 | $number = Functions::flattenSingleValue($number); |
|
| 1073 | ||
| 1074 | if (is_numeric($number)) { |
|
| 1075 | if ($number < 0) { |
|
| 1076 | return Functions::NAN(); |
|
| 1077 | } |
|
| 1078 | ||
| 1079 | return sqrt($number * M_PI); |
|
| 1080 | } |
|
| 1081 | ||
| 1082 | return Functions::VALUE(); |
|
| 1083 | } |
|
| 1084 | ||
| 1085 | /** |
|
| 1086 | * SUBTOTAL |
|
| @@ 1701-1714 (lines=14) @@ | ||
| 1698 | * @param float $value |
|
| 1699 | * @return float |
|
| 1700 | */ |
|
| 1701 | public static function GAMMALN($value) |
|
| 1702 | { |
|
| 1703 | $value = Functions::flattenSingleValue($value); |
|
| 1704 | ||
| 1705 | if (is_numeric($value)) { |
|
| 1706 | if ($value <= 0) { |
|
| 1707 | return Functions::NAN(); |
|
| 1708 | } |
|
| 1709 | ||
| 1710 | return log(self::gamma($value)); |
|
| 1711 | } |
|
| 1712 | ||
| 1713 | return Functions::VALUE(); |
|
| 1714 | } |
|
| 1715 | ||
| 1716 | /** |
|
| 1717 | * GEOMEAN |
|
