How do I do PVIF function in MS Excel?

[GL]

How do I do PVIF function in MS Excel?

 

[Niek Otten]

What are PVIV functions?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do I do PVIF function in MS Excel?

 

[joeu2004]

What are PVIV functions?

Googling "pvif" finds an "explanation" (by example) at
http://lucasbaltes.com/pub/phpfinancials/unix/phpfinancials.phps .

Ostensibly, PVIF can be computed by:

=(1 + intRate) ^ (1/n)

where "intRate" is the compound annual rate, and "n" is the number of
compounding periods per year.

Alternatively:

=rate(n, 0, -1, 1+intRate)

But RATE() does not always succeed without the "guess" argument (sigh).