Need formula to calculate List Price.

L

lukus2005

Need help with an excel formula to figure out the list price. I was
given the discount (%) and my net price but I want to figure out what
was the origin list price before the discount was applied.

I have following cells which have the data I need to look at to get
final cost.
A10 - Contains the net price (my price)
B10 - Contains my discount (%)
C10 - Where I want the list price to appear (price before discount was
applied)

I need a formula that will calculate what amount my discount was based
on (list price).
 
R

RagDyeR

You're welcome, and appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

One way:

=A10/(1-B10)
Click to expand...

TY... You da man!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In a sales quote sheet - sum totals by license type 1
If question 3
Can I do multiple IF/OR statements? 2
How do I find the original price? 4
Finetune formula to get currency format? 1
Calculations 2
How to Create a Discount Calculator based on volume 2
Assigning a value to a text 1

Top