PHPOffice /
PhpSpreadsheet
| @@ 1409-1415 (lines=7) @@ | ||
| 1406 | } |
|
| 1407 | ||
| 1408 | $f = self::NPV($x1, $values); |
|
| 1409 | if ($f < 0.0) { |
|
| 1410 | $rtb = $x1; |
|
| 1411 | $dx = $x2 - $x1; |
|
| 1412 | } else { |
|
| 1413 | $rtb = $x2; |
|
| 1414 | $dx = $x1 - $x2; |
|
| 1415 | } |
|
| 1416 | ||
| 1417 | for ($i = 0; $i < self::FINANCIAL_MAX_ITERATIONS; ++$i) { |
|
| 1418 | $dx *= 0.5; |
|
| @@ 2262-2268 (lines=7) @@ | ||
| 2259 | } |
|
| 2260 | ||
| 2261 | $f = self::XNPV($x1, $values, $dates); |
|
| 2262 | if ($f < 0.0) { |
|
| 2263 | $rtb = $x1; |
|
| 2264 | $dx = $x2 - $x1; |
|
| 2265 | } else { |
|
| 2266 | $rtb = $x2; |
|
| 2267 | $dx = $x1 - $x2; |
|
| 2268 | } |
|
| 2269 | ||
| 2270 | for ($i = 0; $i < self::FINANCIAL_MAX_ITERATIONS; ++$i) { |
|
| 2271 | $dx *= 0.5; |
|
