Percentages? How?
 

I am currently running a price guide that looks as follows:
A B C D E F
Item Price Cost SRP GP% Retail Unit

Column C is the Customer's Cost per Retail unit (F)
Column D is the Suggested Retail Price
Column E is the Gross Profit Percentage

Column E is =(D1-C1)/D1 to arrive at the GP%.

*Now* I want to reverse the process! I need to type a percentage into E and
have D pop up automatically. (I.e., instead of typing in an SRP of $2.50 on
an item that costs $1.36 to arrive at a GP of 45.6%, I want to type 40% and
find out what the SRP would be.)

Thanks

=C1/(1-E1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Shaun" wrote in message
...
I am currently running a price guide that looks as follows:
A B C D E F
Item Price Cost SRP GP% Retail Unit

Column C is the Customer's Cost per Retail unit (F)
Column D is the Suggested Retail Price
Column E is the Gross Profit Percentage

Column E is =(D1-C1)/D1 to arrive at the GP%.

*Now* I want to reverse the process! I need to type a percentage into E
and
have D pop up automatically. (I.e., instead of typing in an SRP of $2.50
on
an item that costs $1.36 to arrive at a GP of 45.6%, I want to type 40%
and
find out what the SRP would be.)

Thanks