ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us
How to Use Excel > Excel Formula > Get the Original Price from Percentage Increase/Decrease

Get the Original Price from Percentage Increase/Decrease

Get the Original Price from Percentage Increase/Decrease
Table of contents :
  • Get the Original Price from Percentage Increase
  • Get the Original Price from Percentage Decrease

Get the Original Price from Percentage Increase Decrease

Get the Original Price from Percentage Increase

What was the original price of the smartphone before the price increase?

Get the Original Price from Percentage Increase

Current prices are in column B, price after a 20% increase (column C). What is the formula to get the original smartphone price before the percentage increase?

The Formula

=number/(1+percentage_increase)

How does the formula work

=B2/(1+C2)

The formula is the opposite of how to get the price after percentage increase formula.

How to Add Percentage in Excel (get the price after percentage increase)

The formula to get the price after percentage increase uses multiplication formula, to get the original price, use division formula and the formula in the parentheses remains the same.

=(1+C2) the result is 1.2 because the divisor is greater than 1, the original price will be smaller than the current price in cell B2. The result is $140.99, the original price before the price increase.

Get the Original Price from Percentage Decrease

What is the price of the smartphone before the discount is applied?

Get the Original Price from Percentage Decrease

To get the original price before the discount is the opposite of getting the price after the discount.

How to Subtract Percentage in Excel (get the price after percentage discount)

To get the price after the discount, use the multiplication formula, while to get the price before the discount, use the division formula. The formula inside the parentheses remains the same.

The Formula

=number/(1-percentage_decrease)

How does the formula work

=B2/(1-C2)

The result of the formula (1-C2) is 0.8, smaller than 1. The original price before the discount will be greater than the current price in B2.

Related Article

Articles related to this article
  • How to Subtract in Excel
  • How to Do Multiplication in Excel
  • How to Do Division in Excel
Usefull links
  • Microsoft Multiply by a percentage documentation
Share
Tweet
Google+
Email
Prev Article

Related Articles

VLOOKUP Error
The Wrong Cell Reference The wrong cell reference is the …

VLOOKUP Error – Frequently Error and Solution

VLOOKUP Multiple Criteria
The Solution for Numeric Result For example, there is data …

VLOOKUP Multiple Criteria – Solution for Numeric or Non-Numeric Result

Excel Divide by Zero
Pay attention to the data below. A store sells five …

Excel Divide by Zero Error

Different between SUMIF and SUMIFS
SUMIFS vs. SUMIF Here is a table of differences between …

Difference between SUMIF and SUMIFS

Excel provides three different functions to extract a day, month, …

How to Extract Day, Month and Year from Date in Excel

Tags:Add Percentage in Excel Division Formula How to Add a Percentage in Excel How to Subtract a Percentage in Excel Multiplication Formula Subtract Percentage in Excel Subtraction Formula

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • Get the Original Price from Percentage Increase/Decrease
  • How to Add/Subtract Percentage in Excel
  • How to Extract Day, Month and Year from Date in Excel
  • How to Add Seconds, Minutes and Hours to a Time in Excel
  • How to Add Days, Weeks, Months and Years to a Date in Excel
  • How to Calculate Time Difference in Excel
  • Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel
  • Flash Fill Excel
  • Paste Special Excel
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
  • Excel LEFT Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2022 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh