PHPOffice /
PhpSpreadsheet
| @@ 1083-1094 (lines=12) @@ | ||
| 1080 | * @param float $number Number |
|
| 1081 | * @return float Square Root of Number * Pi |
|
| 1082 | */ |
|
| 1083 | public static function SQRTPI($number) |
|
| 1084 | { |
|
| 1085 | $number = Functions::flattenSingleValue($number); |
|
| 1086 | ||
| 1087 | if (is_numeric($number)) { |
|
| 1088 | if ($number < 0) { |
|
| 1089 | return Functions::NAN(); |
|
| 1090 | } |
|
| 1091 | return sqrt($number * M_PI) ; |
|
| 1092 | } |
|
| 1093 | return Functions::VALUE(); |
|
| 1094 | } |
|
| 1095 | ||
| 1096 | ||
| 1097 | /** |
|
| @@ 1718-1729 (lines=12) @@ | ||
| 1715 | * @param float $value |
|
| 1716 | * @return float |
|
| 1717 | */ |
|
| 1718 | public static function GAMMALN($value) |
|
| 1719 | { |
|
| 1720 | $value = Functions::flattenSingleValue($value); |
|
| 1721 | ||
| 1722 | if (is_numeric($value)) { |
|
| 1723 | if ($value <= 0) { |
|
| 1724 | return Functions::NAN(); |
|
| 1725 | } |
|
| 1726 | return log(self::gamma($value)); |
|
| 1727 | } |
|
| 1728 | return Functions::VALUE(); |
|
| 1729 | } |
|
| 1730 | ||
| 1731 | ||
| 1732 | /** |
|
