mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-22 10:14:09 +00:00
Mark Baker
d5dc58d20e
* Split Information functions into a dedicated class and namespace and categorise as Value or Error * Refactor all error functions into the new ExcelError class
49 lines
718 B
PHP
49 lines
718 B
PHP
<?php
|
|
|
|
// nominal_rate, npery, Result
|
|
|
|
use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
|
|
|
|
return [
|
|
[
|
|
0.053542667370758003,
|
|
0.052499999999999998,
|
|
4,
|
|
],
|
|
[
|
|
0.103812890625,
|
|
0.10000000000000001,
|
|
4,
|
|
],
|
|
[
|
|
0.10249999999999999,
|
|
0.10000000000000001,
|
|
2,
|
|
],
|
|
[
|
|
0.025156250000000002,
|
|
0.025000000000000001,
|
|
2,
|
|
],
|
|
[
|
|
ExcelError::NAN(),
|
|
0.025,
|
|
-1,
|
|
],
|
|
[
|
|
ExcelError::NAN(),
|
|
-0.025,
|
|
1,
|
|
],
|
|
[
|
|
ExcelError::VALUE(),
|
|
0.025,
|
|
'NaN',
|
|
],
|
|
[
|
|
ExcelError::VALUE(),
|
|
'NaN',
|
|
1,
|
|
],
|
|
];
|