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.