Class RateImpl
Rate implementation
Inheritance
System.Object
RateImpl
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.FormulaParsing.Excel.Functions.Finance.Implementations
Assembly: EPPlus.dll
Syntax
public static class RateImplMethods
LEvalRate(Double, Double, Double, Double, Double, PmtDue)
LEvalRate
Declaration
public static double LEvalRate(double Rate, double NPer, double Pmt, double PV, double dFv, PmtDue Due)Parameters
| Type | Name | Description |
|---|---|---|
| System.Double | Rate | |
| System.Double | NPer | |
| System.Double | Pmt | |
| System.Double | PV | |
| System.Double | dFv | |
| PmtDue | Due |
Returns
| Type | Description |
|---|---|
| System.Double |
Rate(Double, Double, Double, Double, PmtDue, Double)
Rate
Declaration
public static FinanceCalcResult<double> Rate(double NPer, double Pmt, double PV, double FV = 0, PmtDue Due = PmtDue.EndOfPeriod, double Guess = 0.1)Parameters
| Type | Name | Description |
|---|---|---|
| System.Double | NPer | |
| System.Double | Pmt | |
| System.Double | PV | |
| System.Double | FV | |
| PmtDue | Due | |
| System.Double | Guess |
Returns
| Type | Description |
|---|---|
| FinanceCalcResult<System.Double> |
Exceptions
| Type | Condition |
|---|---|
| System.ArgumentException |