Click here to Skip to main content
15,893,487 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i've used Microsoft.VisualBasic.Financial class to find Rate

here is the below code i've used,
C#
lblEffcost.Text = (((Financial.Rate(_RATE_Param1, _RATE_Param2, _RATE_Param3, _RATE_Param4, 0, 0)) * 12) * 100).ToString();

here in above for some parameter the Rate method is working fine, for some other parameters its showing an exception error as
"Cannot calculate rate using the arguments provided"

but for those parameters are working in Excel sheet
----
Some how i need to find Rate as like excel....
can some one give idea or any other free dll or api or apk to get Rate
Posted
Updated 3-Jan-12 5:26am
v2

Here you a working solution - Financial Calculations in C#
 
Share this answer
 
Generally speaking, since those functions use iterative methods they may produce different (implementation dependent) behaviours. However, they 'looks' pretty the same, are you really sure that you feed both Excel function and VB.NET with exactly identical parameters?
 
Share this answer
 
Comments
sabariananthr 3-Jan-12 23:41pm    
yes sure...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900