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

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 ).

• 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.

• 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.

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.

Read Next:

• Excel Formulas to Highlight 3 Smallest Values with Criteria!!
• How to Wrap Text Manually in Excel Office 365? – {3 Ways}
• Remove Characters at the Start using Macros (VBA) in Excel 365!!
• Add a Degree Symbol to Selection Range using Macros (VBA) in Excel!
• Excel Formulas to Apply Conditional Formatting based on Another Column!