mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-24 08:08:28 +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>
45 lines
932 B
PHP
45 lines
932 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
1014584.6544071021,
|
|
'15-Feb-2008', '15-May-2008', 1000000, 0.0575, 2,
|
|
],
|
|
[
|
|
1120.2128404396835,
|
|
'6-Jul-2017', '15-Jan-2020', 1000, 0.0425,
|
|
],
|
|
[
|
|
1120.2128404396835,
|
|
'6-Jul-2017', '15-Jan-2020', 1000, 0.0425, null,
|
|
],
|
|
[
|
|
273037.54266211606,
|
|
'15-Feb-2008', '15-Nov-2017', 100000, 0.065,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'Invalid Date', '15-Nov-2017', 100000, 0.065, 0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'15-Feb-2008', 'Invalid Date', 100000, 0.065, 0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'15-Feb-2008', '15-Nov-2017', 'NaN', 0.065, 0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'15-Feb-2008', '15-Nov-2017', 100000, 'NaN', 0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'15-Feb-2008', '15-Nov-2017', 100000, 0.065, 'NaN',
|
|
],
|
|
[
|
|
'#NUM!',
|
|
'15-Feb-2008', '15-Nov-2017', -1000, 0.065, 0,
|
|
],
|
|
];
|