NOMINAL (PQL - xl)

This function returns the nominal annual interest rate for a given effective rate and number of compounding periods per year

  • Library: PQL \ Spreadsheet \ Financial
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

NOMINAL(effect rate, npery)

Function Arguments

Name

Description

Type

Optional

effect rate

Value representing the effective interest rate

Number

npery

Number of compounding periods per year; if not an integer, the number is truncated

Number

Comments

This function is the same as the Microsoft Excel 'NOMINAL' function - using the same inputs, logic and outputs.