How do I do PVIF function in MS Excel?
 

How do I do PVIF function in MS Excel?

How do I do PVIF function in MS Excel?
 

What are PVIV functions?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"GL" wrote in message ...
| How do I do PVIF function in MS Excel?

How do I do PVIF function in MS Excel?
 

Niek Otten wrote:
"GL" wrote:
How do I do PVIF function in MS Excel?

What are PVIV functions?

Googling "pvif" finds an "explanation" (by example) at
http://lucasbaltes.com/pub/phpfinanc...inancials.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).