mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-20 23:21:01 +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>
53 lines
756 B
PHP
53 lines
756 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
10.33803507,
|
|
[0.04, 10000, 15000],
|
|
],
|
|
[
|
|
3.859866162622655,
|
|
[0.025, 2000, 2200],
|
|
],
|
|
[
|
|
87.6054764193714,
|
|
[0.025 / 12, 1000, 1200],
|
|
],
|
|
[
|
|
3.5644379226484437,
|
|
[0.03, 9000, 10000],
|
|
],
|
|
[
|
|
14.206699082890474,
|
|
[0.05, 50, 100],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
['NaN', 50, 100],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
[0.05, 'NaN', 100],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
[0.05, 50, 'NaN'],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[-0.10, 50, 100],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[0.00, 50, 100],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[0.05, 0, 100],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[0.05, 50, 0],
|
|
],
|
|
];
|