Very simple, but difficult formula question

P

pugsly8422

We get a discout when purchasing some products, so the discounted price is
entered onto our sheets. I want to put in a formula that will use the
discounted price to show the original price. Is it possible to use a
consistent formula for all of them and come out correct on each one?

We recieve an 8% discount, here is an example:

Original cost - $91.95
Our cost - $84.59

I'm trying to figure out a formula that will use only our cost to show the
original cost for each of the amounts on the sheets.

Thanks in advance for your assistance with this matter.
 
N

N Harkawat

Provided its always 8% then
=A1/0.92
where cell A1 holds *our cost*

Why do you think that it is difficult....
Or am I missing something.
 
D

Dave Peterson

You could use something like:

=A1/(1-0.08)

=(yourcost) / (1 - discount%)

If your cost in C2:C99, you could put your discount 8% in A1 and use a formula
like this in D2 (inserted column).

=c2/(1-$a$1)

And drag down.

Then you could just change A1 when your discount changes. This does assume that
the discount is always the same for each part.
 
B

Barb R.

Let's say "Our cost" is in cell A20

=ROUND(A20/(1-0.08),2)

If you have different discounts, you can change 0.08 to a variable.
 
Top