EFFECT

Returns the effective annual interest rate for a given nominal interest rate and number of
compounding periods per year.
=EFFECT(A1, B1)
EFFECT() Result is 10.38%
=EFFECT(A2, B2)
EFFECT() Result is 10.25%
=EFFECT(A3, B3)
EFFECT() Result is 2.52%