How to use NOMINAL Function in Excel

The Excel NOMINAL function returns the nominal interest rate, given an effective annual interest rate and the number of compounding periods per year. The effective rate is the actual rate due to compounding. The nominal rate is typically the stated rate.

Syntax:= NOMINAL (effect_rate, npery)

The NOMINAL function syntax has the following arguments:

  • Effect_rate    Required. The effective interest rate.
  • Npery    Required. The number of compounding periods per year.

Example: Let’s look at some Excel NOMINAL function examples and explore how to use the NOMINAL function as a worksheet function in Microsoft Excel:

NOMINAL Function

Syntax:  =NOMINAL(A2,B2)


NOMINAL Function

Based on the Excel spreadsheet above, the following NOMINAL examples would return:

Syntax: =NOMINAL(A3,B3)
Result: 6.00%

Syntax: =NOMINAL(A4,B4)
Result: 6.02%

Syntax: =NOMINAL(A5,B5)
Result: 6.03%

Syntax: =NOMINAL(A6,B6)
Result: 6.00%

Syntax: =NOMINAL(A7,B7)
Result: 6.02%

Syntax: =NOMINAL(A8,B8)
Result: 9.65%

Syntax: =NOMINAL(A9,B9)
Result: 6.14%

Syntax: =NOMINAL(A10,B10)
Result: 6.10%


  1. Remember that npery gets truncated to an integer.
  2. #NUM! error – Occurs when:
    1. The given effect_rate is less than or equal to zero.
    2. The given npery is less than 1.
  3. The NOMINAL function will return a VALUE! error if any of the given arguments is non-numeric.
  4. The NOMINAL rate is related to the EFFECTIVE rate. The relationship between the NOMINAL and EFFECT functions can be understood by the following formula:

Add a Comment

Your email address will not be published. Required fields are marked *