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
|