Public Function Nominal( _
ByVal vEffectiveRate As Variant _
, ByVal vPeriodsPerYear As Variant _
) As Variant Nominal(.055, 4) = 0.0539006977649699
Nominal(.055, 12) = 0.0536603870045163
Nominal(.055, 365) = 0.0535446939881523See the NominalVerify Subroutine for more examples of this Function. Effect Function
NOMINAL Function (Microsoft Excel)vEffectiveRate: Effective annual interest rate. Must be greater than zero (>0), otherwise this function returns Null. Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.