Find Original Value using result of discounted discount [closed]
$begingroup$
Am trying to build an excel sheet where I have an known Target Price (TP) that I want to achieve but don't now how to get the Original Price (OP).
TP = (OP - 10% discount on OP) - 20% fee on discounted OP
Can someone help with a simple answer?
percentages
$endgroup$
closed as off-topic by Travis, verret, Eevee Trainer, Leucippus, max_zorn Jan 10 at 6:03
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question is missing context or other details: Please provide additional context, which ideally explains why the question is relevant to you and our community. Some forms of context include: background and motivation, relevant definitions, source, possible strategies, your current progress, why the question is interesting or important, etc." – Travis, verret, Eevee Trainer, Leucippus, max_zorn
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
$begingroup$
Am trying to build an excel sheet where I have an known Target Price (TP) that I want to achieve but don't now how to get the Original Price (OP).
TP = (OP - 10% discount on OP) - 20% fee on discounted OP
Can someone help with a simple answer?
percentages
$endgroup$
closed as off-topic by Travis, verret, Eevee Trainer, Leucippus, max_zorn Jan 10 at 6:03
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question is missing context or other details: Please provide additional context, which ideally explains why the question is relevant to you and our community. Some forms of context include: background and motivation, relevant definitions, source, possible strategies, your current progress, why the question is interesting or important, etc." – Travis, verret, Eevee Trainer, Leucippus, max_zorn
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
$begingroup$
Am trying to build an excel sheet where I have an known Target Price (TP) that I want to achieve but don't now how to get the Original Price (OP).
TP = (OP - 10% discount on OP) - 20% fee on discounted OP
Can someone help with a simple answer?
percentages
$endgroup$
Am trying to build an excel sheet where I have an known Target Price (TP) that I want to achieve but don't now how to get the Original Price (OP).
TP = (OP - 10% discount on OP) - 20% fee on discounted OP
Can someone help with a simple answer?
percentages
percentages
asked Jan 9 at 5:25
olgaoolgao
6
6
closed as off-topic by Travis, verret, Eevee Trainer, Leucippus, max_zorn Jan 10 at 6:03
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question is missing context or other details: Please provide additional context, which ideally explains why the question is relevant to you and our community. Some forms of context include: background and motivation, relevant definitions, source, possible strategies, your current progress, why the question is interesting or important, etc." – Travis, verret, Eevee Trainer, Leucippus, max_zorn
If this question can be reworded to fit the rules in the help center, please edit the question.
closed as off-topic by Travis, verret, Eevee Trainer, Leucippus, max_zorn Jan 10 at 6:03
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question is missing context or other details: Please provide additional context, which ideally explains why the question is relevant to you and our community. Some forms of context include: background and motivation, relevant definitions, source, possible strategies, your current progress, why the question is interesting or important, etc." – Travis, verret, Eevee Trainer, Leucippus, max_zorn
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
$begingroup$
discounted OP = OP - 10% discount on OP = 0.9 * OP
TP=0.8* discounted OP=0.72 * OP
Therefore OP = TP/0.72
$endgroup$
$begingroup$
Well that was simple.Thanks
$endgroup$
– olgao
Jan 9 at 5:50
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
$begingroup$
discounted OP = OP - 10% discount on OP = 0.9 * OP
TP=0.8* discounted OP=0.72 * OP
Therefore OP = TP/0.72
$endgroup$
$begingroup$
Well that was simple.Thanks
$endgroup$
– olgao
Jan 9 at 5:50
add a comment |
$begingroup$
discounted OP = OP - 10% discount on OP = 0.9 * OP
TP=0.8* discounted OP=0.72 * OP
Therefore OP = TP/0.72
$endgroup$
$begingroup$
Well that was simple.Thanks
$endgroup$
– olgao
Jan 9 at 5:50
add a comment |
$begingroup$
discounted OP = OP - 10% discount on OP = 0.9 * OP
TP=0.8* discounted OP=0.72 * OP
Therefore OP = TP/0.72
$endgroup$
discounted OP = OP - 10% discount on OP = 0.9 * OP
TP=0.8* discounted OP=0.72 * OP
Therefore OP = TP/0.72
answered Jan 9 at 5:38
AndreiAndrei
11.7k21026
11.7k21026
$begingroup$
Well that was simple.Thanks
$endgroup$
– olgao
Jan 9 at 5:50
add a comment |
$begingroup$
Well that was simple.Thanks
$endgroup$
– olgao
Jan 9 at 5:50
$begingroup$
Well that was simple.Thanks
$endgroup$
– olgao
Jan 9 at 5:50
$begingroup$
Well that was simple.Thanks
$endgroup$
– olgao
Jan 9 at 5:50
add a comment |