answersLogoWhite

0


Best Answer

If you put the original price in cell A1, then the formula you insert into cell B1 or whichever other cell you wish to calculate the new value is:

=A1*(1-(30/100))

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the formula if price drops in 30 percent in excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Formula of net profit in Excel?

The formula of net profit in MS Excel is:- =net profit(cost price+sell price/100*200*2)


A dress is on sale for a 15 percent discount If the sale price of the dress is 51 dollars then the original price of the dress was?

The original price was $60, and 15% off drops that to $51.


What is the formula for markup 30 percent?

Multiply the pre-markup price by 1.3


Formula for calculating gross?

GP=(sell price-cost)/sell price. In excel, whatever result you get format that cell to be a percentage by hitting the % button in the menu bar.


There is a sale where the price of a pair of jeans is reduced by 50 percent By what percent must the price increase to be back at the original price?

100%For example, let's say the original price is $100.Reducing it by 50% drops the price down to $50.In order to return the price to $100, $50 must be doubled, which is saying it must be increased by 100%.


If the markup formula is 40 percent of cost and the selling price of an item is 49.99 what is the cost?

$35.71


Where can one find enormous price drops?

Many retailers and stores advertise huge price drops on their merchandise. Walmart is one of the leading examples of retailers that offer enormous price drops.


What is the wholesale price for a item sells for 213.90 at 130 percent markup price?

The formula is: 1.3y = 213.90 Where y = wholesale price. Solving for y: y = 213.90 / 1.3 y = $164.54


Wholesale price is 80 and percent of markup is 95 percent percent percent what is the sale price?

The sale price is $156.00


How can you use advanced Excel tools such as conditional formatting and additional tools to manage business finances?

An effective use of conditional formatting is to automatically highlight a cell if the total drops below a specified limit, such as stock price.


How do you write formula in Excel to add 20 percent in cost price?

You could do it in a few ways. Assumung the cost price was in cell A2 and in another cell you wanted to show it having been increased by 20%, you could do any of these: =A2*120% =A2*1.2 =A2+A2*20%


What is formula of sales price?

The sales price formula is Sale Price=(Normal Price)(Compliment of Markdown)