PHPOffice /
PhpSpreadsheet
| @@ 1115-1128 (lines=14) @@ | ||
| 1112 | * |
|
| 1113 | * @return float Square Root of Number * Pi |
|
| 1114 | */ |
|
| 1115 | public static function SQRTPI($number) |
|
| 1116 | { |
|
| 1117 | $number = Functions::flattenSingleValue($number); |
|
| 1118 | ||
| 1119 | if (is_numeric($number)) { |
|
| 1120 | if ($number < 0) { |
|
| 1121 | return Functions::NAN(); |
|
| 1122 | } |
|
| 1123 | ||
| 1124 | return sqrt($number * M_PI); |
|
| 1125 | } |
|
| 1126 | ||
| 1127 | return Functions::VALUE(); |
|
| 1128 | } |
|
| 1129 | ||
| 1130 | protected static function filterHiddenArgs($cellReference, $args) |
|
| 1131 | { |
|
| @@ 1761-1774 (lines=14) @@ | ||
| 1758 | * |
|
| 1759 | * @return float |
|
| 1760 | */ |
|
| 1761 | public static function GAMMALN($value) |
|
| 1762 | { |
|
| 1763 | $value = Functions::flattenSingleValue($value); |
|
| 1764 | ||
| 1765 | if (is_numeric($value)) { |
|
| 1766 | if ($value <= 0) { |
|
| 1767 | return Functions::NAN(); |
|
| 1768 | } |
|
| 1769 | ||
| 1770 | return log(self::gamma($value)); |
|
| 1771 | } |
|
| 1772 | ||
| 1773 | return Functions::VALUE(); |
|
| 1774 | } |
|
| 1775 | ||
| 1776 | /** |
|
| 1777 | * GEOMEAN. |
|
