Nominal interest rate is the stated rate on the financial product.

Effective annual interest rate is the interest rate actually earned due to compounding.

The effective rate is the actual rate due to compounding.

Excel formula: Effective annual interest rate

The nominal rate is typically the stated rate.

Excel NOMINAL function