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