How to use the PRICE Function in Excel office 365?
Tags: tousethepricefunctio, excel, excelfunctions
Published: 2021-09-03 03:24:21

---
title: How to use the PRICE Function in Excel office 365?
published: true
date: 2021-09-03 01:34:15 UTC
tags: ToUseThePRICEFunctio,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-price-function-in-excel-office-365/
---

In this article, you will learn how to use the **PRICE**  **Function In Excel Office 365** using its basic syntax, explanation, and examples. Let’s see them below!! Get the 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)

## PRICE Function

The **PRICE function** is a **built-in financial function** which returns the **price per $100 face value of a security** that pays periodic interest.

## PRICE Function Syntax

```
=PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])
```

**Syntax Explanation:**

- **Settlement:** Settlement date of the security.
- **Maturity:** Maturity date of the security. The maturity date is the date when the security expires.
- **Rate:** The security’s annual coupon rate.
- **Yld:** The security’s annual yield.
- **Redemption:** Redemption value per $100 face value.
- **Frequency:** Coupon payments per year (annual = 1, semiannual = 2; quarterly = 4.
- **basis:** [optional] Day count basis.

## Example1

- Firstly, you need to create a **sample data with input values**.

![](https://geekexcel.com/wp-content/uploads/2021/09/Sample-data-5.png)<figcaption>Sample data</figcaption>

- Then, you have values to calculate the **bond PRICE per $100 face value of a security** that pays **periodic interest**.
- Now, you need to use the following **formula** given below.

```
=PRICE(B1, B2, B3, B4, B5, B6, 0)
```

![](https://geekexcel.com/wp-content/uploads/2021/09/PRICE-Function.png)<figcaption>PRICE Function</figcaption>

**NOTE:** Dates in the formula must be entered using cell reference. Excel date format creates problems while computing results and Press **Enter** to get the Price.

- After that, the formula returns the **price per $100 face value**  **of a security** that pays periodic interest.

## Example2

- Firstly, you need to create a **sample data with input values**.

![](https://geekexcel.com/wp-content/uploads/2021/09/Ex-2-Sample-data-6.png)<figcaption>Sample data</figcaption>

- Then, you have to calculate the **bond PRICE per $100 face value of a security** that pays periodic interest.
- Now, you need to use the following **formula** given below.

```
=PRICE(B1, B2, B3, B4, B5, B6, 0)
```

![](https://geekexcel.com/wp-content/uploads/2021/09/Ex-2-Price-Function.png)<figcaption>PRICE Function</figcaption>

**NOTE:** Dates in the formula must be entered using cell reference. Excel date format creates problems while computing results and Press **Enter** to get the Price.

- After that, the formula returns the **price per $100 face value**  **of a security** that pays periodic interest.

**Check this too:**

- [TBILLPRICE function](https://geekexcel.com/how-to-use-the-tbillprice-function-in-excel-office-365/)
- [CUMPRINC function](https://geekexcel.com/how-to-use-the-cumprinc-function-in-excel-spreadsheet/)

## Verdict

From this chapter, you can get some clarification about **how to use the PRICE**  **Function In Excel Office 365**. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Related Articles:**

- **[Excel Formulas to Lookup a Latest Price ~ A Complete Tutorial!!](https://geekexcel.com/lookup-a-latest-price-excel-formula/)**
- **[Excel Formulas to Find Original Price from Percentage Discount!!](https://geekexcel.com/excel-formulas-to-find-original-price-from-percentage-discount/)**
- **[How to Find the Actual Price of the Discounted Price in Excel 365?](https://geekexcel.com/how-to-find-the-actual-price-of-the-discounted-price-in-excel-365/)**
- **[How to use the RECEIVED Function in Excel office 365?](https://geekexcel.com/how-to-use-the-received-function-in-excel-office-365/)**