mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-24 06:48:34 +00:00
Mark Baker
a34695e0f9
* Additional unit tests and rationalisation for Financial Functions * Providing a series of sample files for Financial functions * Refactor the last of the existing Financial functions * Some more unit tests with default assignments from null arguments Co-authored-by: Adrien Crivelli <adrien.crivelli@gmail.com>
151 lines
1.9 KiB
PHP
151 lines
1.9 KiB
PHP
<?php
|
|
|
|
// rate, nper, pv, start_period, end_period, type, result
|
|
|
|
return [
|
|
[
|
|
-11135.232130750999,
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
13,
|
|
24,
|
|
0,
|
|
],
|
|
[
|
|
-937.5,
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
1,
|
|
1,
|
|
0,
|
|
],
|
|
[
|
|
-937.5,
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
1,
|
|
1,
|
|
null,
|
|
],
|
|
[
|
|
-2299.6141712553544,
|
|
0.004175,
|
|
60,
|
|
50000,
|
|
1,
|
|
12,
|
|
0,
|
|
],
|
|
[
|
|
-1836.8883999349455,
|
|
0.004175,
|
|
60,
|
|
50000,
|
|
13,
|
|
24,
|
|
0,
|
|
],
|
|
[
|
|
-1350.4402595996685,
|
|
0.004175,
|
|
60,
|
|
50000,
|
|
25,
|
|
36,
|
|
0,
|
|
],
|
|
[
|
|
-839.0535854569902,
|
|
0.004175,
|
|
60,
|
|
50000,
|
|
37,
|
|
48,
|
|
0,
|
|
],
|
|
[
|
|
-301.4498641014851,
|
|
0.004175,
|
|
60,
|
|
50000,
|
|
49,
|
|
60,
|
|
0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'NaN',
|
|
360,
|
|
125000,
|
|
24,
|
|
13,
|
|
0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
0.0075,
|
|
'NaN',
|
|
125000,
|
|
24,
|
|
13,
|
|
0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
0.0075,
|
|
360,
|
|
'NaN',
|
|
24,
|
|
13,
|
|
0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
'NaN',
|
|
13,
|
|
0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
24,
|
|
'NaN',
|
|
0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
24,
|
|
13,
|
|
'NaN',
|
|
],
|
|
[
|
|
'#NUM!',
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
13,
|
|
24,
|
|
2,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
0.0075,
|
|
10,
|
|
125000,
|
|
24,
|
|
13,
|
|
0,
|
|
],
|
|
];
|