You'd like to perform a curve fit using a model (an equation) that's not included in Excel's suite of curve fit functions and trendlines.
Perform a least-squares curve fit using Solver.
Solver is a fantastic Excel add-in that allows you to perform constrained optimization calculations. Solver uses the nonlinear Generalized Reduced Gradient optimization algorithm developed by Leon Lasdon and Allan Waren. Go to the Tools → Solver menu to open the Solver dialog box shown in Figure 8-10.
Figure 8-10. Solver dialog box
If you don't see the Solver menu item, then go to Tools → Add-Ins...and look for Solver in the available add-ins list. Select its checkbox to make it available.
Solver allows you to choose a target cell and either maximize it, minimize it, or attempt to set its value to some specified value by changing values in a given range of cells. The controls in the Solver dialog box allow you to set these parameters. After setting these parameters in the Solver dialog box, press Solve to initiate the iterative calculation. Solver will iterate until it finds a solution or until certain limits are reached (these effectively put the brakes on the iterative calculation so it will not continue forever). You can set these limits by opening the Options dialog via the Options button.
The target cell could be any cell containing ...