Hi,

There is a formula called retail ratio which is Product
Sales divided by the sum of Product Sales and Service
Sales. or RR = P/(S+P). I am trying to create a "What
If" chart which would allow someone to plug in values for
the Retail Ratio. The Service Sales are also known.
What I am trying to do is to solve for what the Product
Sales would be. So RR and S are know but P is not.
Since it is both in the numerator and denomiator, I am
trying to come up with a formula that solves for this.
Here is what my chart looks like. Can someone help?

Thanks,

Chuck

Person Service Sales Product Sales Total Sales RR
100 $20,000.00 40%
200 $30,000.00 40%
300 $40,000.00 40%
400 $50,000.00 40%