0
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))
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
Wholesale price is 80 and percent of markup is 95 percent percent percent what is the sale price?
The sale price is $156.00
What is the formula for buying gold per gram?
Market price x's Karat percent. Then divide by 31.13 (troy ounce) Then that total is your full melt price. Then you divide that by 2 for your average price a pawn shop would pay you for it.
How do you do a percent of discount to the nearest percent math question?
It is 100*(1 - Discounted price/Full price) or 100*Discount amount/Full price
Double price equals what percent?
Double price is equal to 200% of the original price.
How do you solve a commission problem where you need to find the original price?
Commission = percent x original price / 100 so original price = commission x 100 / percent
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 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%
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.
What is formula of sales price?
The sales price formula is Sale Price=(Normal Price)(Compliment of Markdown)
