php实现excel计算,如何在PHP中计算Excel Rate公式？

我正在尝试使用此功能计算Excel费率公式但它并没有给我确切的结果 . 在这段代码中需要帮助一些东西 .

这是excel公式和 Value 观..

= RATE(B4 * 12，-1 (B5 B6)，B2) 12以下是值 . B4 = 30(以年为单位)B5 = 2761.02 B6 = 817 B2 = 5,00,000

我在下面使用 PHP 功能 .

define('FINANCIAL_MAX_ITERATIONS', 128);

define('FINANCIAL_PRECISION', 1.0e-08);

function RATE($nper, $pmt, $pv, $fv = 0.0, $type = 0, $guess = 0.1) {

$rate = $guess;

if (abs($rate) < FINANCIAL_PRECISION) {

$y = $pv * (1 + $nper * $rate) + $pmt * (1 + $rate * $type) * $nper + $fv;

} else {

$f = exp($nper * log(1 + $rate));

$y = $pv * $f + $pmt * (1 / $rate + $type) * ($f - 1) + $fv;

}

$y0 = $pv + $pmt * $nper + $fv;

$y1 = $pv * $f + $pmt * (1 / $rate + $type) * ($f - 1) + $fv;

// find root by secant method

$i = $x0 = 0.0;

$x1 = $rate;

while ((abs($y0 - $y1) > FINANCIAL_PRECISION) && ($i < FINANCIAL_MAX_ITERATIONS)) {

$rate = ($y1 * $x0 - $y0 * $x1) / ($y1 - $y0);

$x0 = $x1;

$x1 = $rate;

if (abs($rate) < FINANCIAL_PRECISION) {

$y = $pv * (1 + $nper * $rate) + $pmt * (1 + $rate * $type) * $nper + $fv;

} else {

$f = exp($nper * log(1 + $rate));

$y = $pv * $f + $pmt * (1 / $rate + $type) * ($f - 1) + $fv;

}

$y0 = $y1;

$y1 = $y;

++$i;

}

return $rate;

}