This is a very complicated function that assumes you have reliable data to input. Recommend you use the Solver Add-In. See related links for specific details about Solver and an example of how to use it with test data (including the formula to use in Excel).
If the Solver is not installed on your version of Excel, use the Excel help function to learn how to install the Solver in your particular application.
Here are some generic instructions for Excel 2007 for installing the Solver Add-In:
1) Click the Microsoft Office Button, and then click Excel Options.
2) Click Add-Ins, and then in the Manage box, select Excel Add-ins.
3) Click Go.
4) In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
TIP: If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.
5) If you get prompted that the Solver Add-in is not currently installed on your computer, click Yes to install it.
6) After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab.
No yuji naka is not dead
James Naka was born in 1984.
Acanthoplesiops naka was created in 2004.
Naka Bokunen was born in 1953.
The population of Dewas Naka is 8,250.
Naka no Shibai was created in 1652.
Naka no Shibai ended in 1999.
Kansuke Naka was born in 1885.
Kansuke Naka died in 1965.
Naka Drotské was born in 1971.
John Naka died in 2004.
John Naka was born in 1914.