Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Apply a simple formula to multiple rows? | New Users to Excel | |||
simple formula with blank cells | Excel Worksheet Functions | |||
Need a simple formula please | Excel Worksheet Functions | |||
Formula Question... LookUP | Excel Discussion (Misc queries) |