xny/vendor/phpoffice/phpspreadsheet/tests/data/Calculation/Financial/NPER.php

<?php

// rate, pmt, pv, fv, type, result

return [
    [
        59.673865674295001,
        [0.01, -100, -1000, 10000, 1],
    ],
    [
        60.082122853762002,
        [0.01, -100, -1000, 10000],
    ],
    [
        -9.5785940398132006,
        [0.01, -100, -1000],
    ],
    [
        54.787577259999999,
        [0.003333333333, -1000, 50000],
    ],
    [
        11.90373729,
        [0.015, -1200, 9000, 5000, 1],
    ],
    [
        11.493114445230,
        [-0.015, -1200, 9000, 5000, 1],
    ],
    [
        -11.328655672030,
        [0.015, 1200, 9000, 5000, 1],
    ],
    [
        -3.046573306812,
        [0.015, -1200, -9000, 5000, 1],
    ],
    [
        3.621654926975,
        [0.015, -1200, 9000, -5000, 1],
    ],
    [
        11.666666667,
        [0.0, -1200, 9000, 5000, 1],
    ],
    [
        '#VALUE!',
        ['NaN', -1200, 9000, 5000, 1],
    ],
    [
        '#VALUE!',
        [0.015, 'NaN', 9000, 5000, 1],
    ],
    [
        '#VALUE!',
        [0.015, -1200, 'NaN', 5000, 1],
    ],
    [
        '#VALUE!',
        [0.015, -1200, 9000, 'NaN', 1],
    ],
    [
        '#VALUE!',
        [0.015, -1200, 9000, 5000, 'NaN'],
    ],
    [
        '#NUM!',
        [0.015, -1200, 9000, 5000, 2],
    ],
    [
        '#NUM!',
        [0.015, 0.0, 0.0, 5000, 1],
    ],
    [
        '#NUM!',
        [0.0, 0.0, -500, 5000, 1],
    ],
    [
        '#NUM!',
        [0.25, 0.5, 0.0, 150, 1],
    ],
];