Excel functions / Financial

NOMINAL function

The quoted yearly rate behind an effective rate. The reverse of EFFECT.

Syntax

=NOMINAL(effect_rate, npery)

Arguments

When to use it

NOMINAL turns an effective yearly rate back into the quoted rate for a given compounding: the rate a bank would advertise. It is the inverse of EFFECT.

Examples

  1. The quoted rate behind 5.3543% effective, quarterly

    ABCD
    1EffectivePer year
    25.3543%45.250%

    In D2: =NOMINAL(A2, B2) → 5.250%

    Try this example

Common mistakes

NOMINAL in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try NOMINAL in the playground

Related functions