NOMINAL function

Category: Financial
Introduced: Excel 2003

Summary

Returns the annual nominal interest 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

=NOMINAL(A2,A3)

Microsoft Support Page

https://support.microsoft.com/en-us/office/nominal-function-7f1ae29b-6b92-435e-b950-ad8b190ddd2b

Back to Functions