next up previous contents index
Next: EIGEN Up: A Function Reference Previous: EDATE

EFFECT

 

Syntax: @EFFECT(R, P)

R = Nominal rate
P = Number of compounding periods per year

@EFFECT returns the effective annual interest rate.

Example:

@EFFECT(6.75%, 5) = 0.06935


next up previous contents index
Next: EIGEN Up: A Function Reference Previous: EDATE

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999