Discount formula

[martinburnett770]

Hi. Newbie here.
I'm looking for a formula to help me work out a retail price.
I know all the basic formulas when I know all my prices or I'm adding margin to a cost price, but on this occasion I know the discounted prices, I'm trying to find the selling price BEFORE discount.

We are currently a trade only supplier but we are going to offer our services to the general public.
We have decided our trade customers will receive a 25% discount from the Public prices.
Being as we are trade only at the moment, I only have the current TRADE prices. So I need to work out what I'll be charging the public, so that when we discount the RETAIL price by 25% it brings it back to the current trade prices.

EG. Currently, we charge £34.99 to Trade.
I need to know the formula to work out what my RETAIL price will be so that when I take 25% off the retail price I am left back at £34.99

I hope I've explained that well enough, thanks in advance for any help.

 

[jtakw]

Hi,

Like this:

Book3.xlsx
	A	B
1	Trade Price	Retail Price
2	34.99	46.65
3	25.50	34.00
4	10.00	13.33
5	75.00	100.00
Sheet1024

Cell Formulas
Range	Formula
B2:B5	B2	=A2/0.75

 

[BSALV]

if you give 25% discount, you multiply with 75%
when you want to know the original price of a discounted product, you divide by 75%

Map1
	C	D	E
5		25%
6		75%
7	26,2425	34,99	46,65333
8
9		0,75	0,75
Blad1

Cell Formulas
Range	Formula
D6	D6	=1-D5
C7	C7	=+D7*D6
E7	E7	=+D7/D6
D9:E9	D9	=+C7/D7

 

[martinburnett770]

Thank you, I knew it would be really simple.

 

[jtakw]

You're welcome.