How to Find the Actual Price of the Discounted Price in Excel 365?
Tags: findtheactualpriceof, excelpreface
Published: 2021-03-23 04:03:34

---
title: How to Find the Actual Price of the Discounted Price in Excel 365?
published: true
date: 2021-03-22 04:10:44 UTC
tags: FindtheActualPriceof,ExcelPreface
canonical_url: https://geekexcel.com/how-to-find-the-actual-price-of-the-discounted-price-in-excel-365/
---

Here, we come up with the instructions to **find the actual price of the discounted price in Excel Office 365** with an example. We will achieve this with a simple formula. Let’s get into this article and learn the steps. 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)
## Find the Actual Price of the Discounted Price:

Follow the below-given instructions to find the actual price of the discounted price in the Excel spreadsheet.

- In the below example, you will see the **sold amount** ( **Column A** ) and **percentage sold value** ( **Column B** ).

![Example data](https://geekexcel.com/wp-content/uploads/2021/03/Example-data-1.png)<figcaption id="caption-attachment-22605">Example data</figcaption>

- Now, we are going to apply the formula in **Column C**.
- You can use the below-given formula to get the output value.

**Total amount = discounted amount / discount percent**

**Discounted amount:** This is the amount after the discount applied.

**Discount percentage:** It is a percent at which discount is given.

- You have to type the formula in **cell C2**.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_itXgCdy3ff.png)<figcaption id="caption-attachment-22608">Enter the formula</figcaption>

- After applying the formula, you need to **click** the **Enter** key.
- You need to apply this formula to the following cells in **Column C** and get the output as shown in the below screenshot.
- To fill the remaining cells with their corresponding formula, you need to click **CTRL** + **D** keys.

![Output](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_Qpq8h1AGsc.png)<figcaption id="caption-attachment-22607">Output</figcaption>

## Verdict:

To be crisp, you can clearly understand the steps to **find the actual price of the discounted price in Excel Office 365** with an example. Kindly, give your **suggestions/feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)**

**Read Next:**

- **[Excel Formulas to Highlight 3 Smallest Values with Criteria!!](https://geekexcel.com/excel-formulas-to-highlight-3-smallest-values-with-criteria/)**
- **[How to Wrap Text Manually in Excel Office 365? &#8211; {3 Ways}](https://geekexcel.com/how-to-wrap-text-manually-in-excel-office-365-3-ways/)**
- **[Remove Characters at the Start using Macros (VBA) in Excel 365!!](https://geekexcel.com/remove-characters-at-the-start-using-macros-vba-in-excel-365/)**
- **[Add a Degree Symbol to Selection Range using Macros (VBA) in Excel!](https://geekexcel.com/add-a-degree-symbol-to-selection-range-using-macros-vba-in-excel/)**
- **[Excel Formulas to Apply Conditional Formatting based on Another Column!](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-based-on-another-column/)**