PhpSpreadsheet/tests/data/Calculation/Financial/ISPMT.php

91 lines
1.1 KiB
PHP

<?php
// rate, per, nper, pv, result
return [
[
-66111.111111111,
0.0085,
1,
36,
8000000,
],
[
-533333.33333333,
0.10,
1,
3,
8000000,
],
[
-205.270833333,
0.004175,
1,
60,
50000,
],
[
-201.791666667,
0.004175,
2,
60,
50000,
],
[
0.0,
0.00,
1,
3,
8000000,
],
[
0.0,
0.125,
3,
3,
8000000,
],
[
'#VALUE!',
'NaN',
3,
3,
8000000,
],
[
'#VALUE!',
0.125,
'NaN',
3,
8000000,
],
[
'#VALUE!',
0.125,
3,
'NaN',
8000000,
],
[
'#VALUE!',
0.125,
3,
3,
'NaN',
],
[
'#NUM!',
0.125,
-1,
3,
800000,
],
[
'#NUM!',
0.125,
4,
3,
800000,
],
];