Calculated field to get the needed Sales to achieve goal

[dirtythetoy]

Excel experts, i need help to come up with a calculated field that will essentially work as a goal seeker. Here's the scenario:

Conversion Rate% = Sales / Sales + Disconnect

Given that we have Sales and disconnect on the data, I need a calculated field formula to compute for the needed sales to achieve the 34% Goal Conversion Rate. On the attached sample, i used Goal seek to get the needed sales. See attached for the sample data.

[bebo021999]

Try in B1:
=B5*100/(1-B5)-B6

[dirtythetoy]

Try in B1:
=B5*100/(1-B5)-B6

Thanks but it only works on the example figures. It's becoming inaccurate when i changed the number of disconnected sales.

[shg]

Another way:

	A	B	C
1	Conversion Goal	34%	B1: Input
2	Losses	100	B2: Input
3	Wins	34	B3: Input
4	Add'l wins to meet goal	17.515	B4: =(SUM(B2:B3) * B1 - B3) / (1 - B1)
5	Check	34.00%	B5: =SUM(B3:B4)/SUM(B2:B4)