Need formula to calculate List Price.

  • Thread starter Thread starter lukus2005
  • Start date Start date
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).
 
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!
 
Back
Top