Very simple, but difficult formula question
 

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.

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.


"pugsly8422" wrote in message
...
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.

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.

pugsly8422 wrote:

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.

--

Dave Peterson

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.

"pugsly8422" wrote:

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.

Thanks everyone for your help, I knew it was much easier than I was making it
out to be!

Thanks again!!




"Dave Peterson" wrote:

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.

pugsly8422 wrote:

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.

--

Dave Peterson