Hi, Chuck W;
I have noticed that the Goal Seek numbers do not come out exactly correct.
For example, the second Product Sales number should have been $20,000, rather
than $19,990.53. But perhaps it is close enough for your purpose.
Regards,
Ian.

"Chuck W" wrote:

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%