PHPOffice /
PhpSpreadsheet
| @@ 1111-1124 (lines=14) @@ | ||
| 1108 | * |
|
| 1109 | * @return float Square Root of Number * Pi |
|
| 1110 | */ |
|
| 1111 | public static function SQRTPI($number) |
|
| 1112 | { |
|
| 1113 | $number = Functions::flattenSingleValue($number); |
|
| 1114 | ||
| 1115 | if (is_numeric($number)) { |
|
| 1116 | if ($number < 0) { |
|
| 1117 | return Functions::NAN(); |
|
| 1118 | } |
|
| 1119 | ||
| 1120 | return sqrt($number * M_PI); |
|
| 1121 | } |
|
| 1122 | ||
| 1123 | return Functions::VALUE(); |
|
| 1124 | } |
|
| 1125 | ||
| 1126 | /** |
|
| 1127 | * SUBTOTAL. |
|
| @@ 1765-1778 (lines=14) @@ | ||
| 1762 | * |
|
| 1763 | * @return float |
|
| 1764 | */ |
|
| 1765 | public static function GAMMALN($value) |
|
| 1766 | { |
|
| 1767 | $value = Functions::flattenSingleValue($value); |
|
| 1768 | ||
| 1769 | if (is_numeric($value)) { |
|
| 1770 | if ($value <= 0) { |
|
| 1771 | return Functions::NAN(); |
|
| 1772 | } |
|
| 1773 | ||
| 1774 | return log(self::gamma($value)); |
|
| 1775 | } |
|
| 1776 | ||
| 1777 | return Functions::VALUE(); |
|
| 1778 | } |
|
| 1779 | ||
| 1780 | /** |
|
| 1781 | * GEOMEAN. |
|
