mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-20 16:04: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>
54 lines
784 B
PHP
54 lines
784 B
PHP
<?php
|
|
|
|
// Settlement, Maturity, Investment, Redemption, Basis, Result
|
|
|
|
return [
|
|
[
|
|
0.05768,
|
|
'2008-02-15',
|
|
'2008-05-15',
|
|
1000000,
|
|
1014420,
|
|
2,
|
|
],
|
|
[
|
|
0.225,
|
|
'2005-04-01',
|
|
'2010-03-31',
|
|
1000,
|
|
2125,
|
|
],
|
|
[
|
|
0.225,
|
|
'2005-04-01',
|
|
'2010-03-31',
|
|
1000,
|
|
2125,
|
|
null,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'2008-02-15',
|
|
'2008-05-15',
|
|
1000000,
|
|
1014420,
|
|
'ABC',
|
|
],
|
|
[
|
|
'#NUM!',
|
|
'2008-02-15',
|
|
'2008-05-15',
|
|
1000000,
|
|
-1014420,
|
|
2,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'Invalid Date',
|
|
'2008-05-15',
|
|
1000000,
|
|
1014420,
|
|
2,
|
|
],
|
|
];
|