How to Use Excel NOMINAL Function in Office 365? -[with Examples]
Tags: excelfunctions, excelnominalfunction
Published: 2020-09-30 08:46:43

---
title: How to Use Excel NOMINAL Function in Office 365? -[with Examples]
published: true
date: 2020-09-29 12:12:56 UTC
tags: ExcelFunctions,ExcelNOMINALFunction
canonical_url: https://geekexcel.com/how-to-use-excel-nominal-function-in-office-365-with-examples/
---

## Excel NOMINAL Function:

![Excel NOMINAL Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_RzWChcrJXi.png)<figcaption id="caption-attachment-14829">Excel NOMINAL Function</figcaption>

In this article, we are going to see how to use the **Excel NOMINAL Function in Office 365** with its syntax, explanation, and example. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## **NOMINAL Function – Description:**

- This function **returns the nominal annual interest rate based on the given effective rate and the number of compounding periods per year**.

## **Syntax:**

**=NOMINAL(effect\_rate, npery)**

### Arguments Explanation:

**effect\_rate – ** It is the effective annual interest rate.

**npery –** It is the number of compounding periods per year.

### Note:

- If either of the argument is non-numerical value, then it returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).
- If the **effect\_rate is less than or equal to 0** or **npery is less than 1** , then this function returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).
- The effect\_rate should be a number between **0 and 1**.

## **Examples:**

Let’s see some examples to make you understand this concept.

### Example 1:

- In the below screenshot, you can see the **input values** in **Column**  **B and C**. The **output values** are displayed in **Column**  **D**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Example-1-5.png)<figcaption id="caption-attachment-14822">Example 1</figcaption>

### Example 2:

- If either of the argument is non-numerical value, then it returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Example-2-6.png)<figcaption id="caption-attachment-14823">Example 2</figcaption>

### Example 3:

- If the **effect\_rate is less than or equal to 0** or **npery is less than 1** , then this function returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Example-3-4.png)<figcaption id="caption-attachment-14824">Example 3</figcaption>

## **A Short Synopsis:**

In the above article, you can learn the usage of **Excel NOMINAL Function in Office 365** with its syntax, explanation, and example. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Use Excel ACCRINT Function in Office 365? -[with Examples]](https://geekexcel.com/how-to-use-excel-accrint-function-in-office-365-with-examples/)
- [How to Use Excel DOLLARFR Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-dollarfr-function-in-office-365-with-examples/)