S
Shaun
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
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