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


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

Excel function: N/A

next up previous contents index
Next: EIGEN Up: A. Function Reference Previous: EDATE   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003