[Excel Financial Functions] Not able to pass Rate parameter in FinancialNPer function 

[Excel Financial Functions] Not able to pass Rate parameter in FinancialNPer function 

  
Forge Component
(1)
Published on 2010-08-20 by Pedro Carrilho
1 vote
Published on 2010-08-20 by Pedro Carrilho
Hi,

I'm having problems using the function FinancialNPer and FinancialPMT.
It's working only when the rate in 0. Imagine that the rate is 0.49 and I got an error in ServiceCenter: "Value was either too large or to small for a Decimal"

I don't understand why

In Excel we must put a percentage in the value like this:
=NPER(0,49%;-1000;10000;0)

But your function on rate parameter is asking for a decimal.

Can you help me?

Thank you.

Kind regards,
Nuno Oliveira


If all of our problems were like this one, we will be very happy.
The problem was simple. I was trying to pass in the rate parameter 0.49... tried to pass 0.49%
The solution is to calculate 0.49% which is 0.0049 and pass this value and it's working

Thanks

Kind regards,
Nuno Oliveira